Databases
StackOverflow2013
Postsdbo
POTable Group By - Tsql -
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTable Group By - Tsql -
    text
    copied!<p><a href="http://img187.imageshack.us/img187/8453/testhc3.png" rel="nofollow noreferrer">alt text http://img187.imageshack.us/img187/8453/testhc3.png</a></p> <p><a href="http://img145.imageshack.us/img145/3306/test2bn4.png" rel="nofollow noreferrer">alt text http://img145.imageshack.us/img145/3306/test2bn4.png</a></p> <p>The first picture is my query. I need to obtain results in second picture.</p> <pre><code>select OrarioA, OrarioB, MAX(VW_DettaglioOrariLinee_FromAToB.IDOrario), dbo.VW_DettaglioOrariLinee_FromAToB.IDDettaglioOrarioA, dbo.VW_DettaglioOrariLinee_FromAToB.IDDettaglioOrarioB FROM dbo.VW_DettaglioOrariLinee_FromAToB INNER JOIN Tb_Linee ON dbo.VW_DettaglioOrariLinee_FromAToB.IDRelA = Tb_Linee.IDRelA AND dbo.VW_DettaglioOrariLinee_FromAToB.IDRelB = Tb_Linee.IDRelB INNER JOIN dbo.periodi ON dbo.VW_DettaglioOrariLinee_FromAToB.IDOrario = dbo.periodi.IDOrario INNER JOIN dbo.relgiornisettimanaorarilinee ON dbo.VW_DettaglioOrariLinee_FromAToB.IDOrario = dbo.relgiornisettimanaorarilinee.IDOrario </code></pre> <p>This is my real query:</p> <pre><code>WITH Tb_Linee AS ( SELECT * FROM VW_rellineestazionamenti WHERE IDLINEA = @IDLINEA AND IDStazA = @IDStazA AND IDStazB = @IDStazB AND PosizioneA = @PosizioneA AND PosizioneB = @PosizioneB ) select OrarioA, OrarioB, VW_DettaglioOrariLinee_FromAToB.IDOrario, dbo.VW_DettaglioOrariLinee_FromAToB.IDDettaglioOrarioA, dbo.VW_DettaglioOrariLinee_FromAToB.IDDettaglioOrarioB FROM dbo.VW_DettaglioOrariLinee_FromAToB INNER JOIN Tb_Linee ON dbo.VW_DettaglioOrariLinee_FromAToB.IDRelA = Tb_Linee.IDRelA AND dbo.VW_DettaglioOrariLinee_FromAToB.IDRelB = Tb_Linee.IDRelB INNER JOIN dbo.periodi ON dbo.VW_DettaglioOrariLinee_FromAToB.IDOrario = dbo.periodi.IDOrario INNER JOIN dbo.relgiornisettimanaorarilinee ON dbo.VW_DettaglioOrariLinee_FromAToB.IDOrario = dbo.relgiornisettimanaorarilinee.IDOrario </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload