Code: Detail

SqlServer+Tsql - (English)

using table variables

this example is about to use table variables in a procedure

Last update: 22/07/2010
SqlServer+Tsql       
 
N/A
N/A
N/A
1
 

    declare @TMP_table  table
               (     COD VARCHAR(7),
                     Rating char(2),
                     Average numeric(5,2) )

            
      insert into @TMP_table
      SELECT  code,
              Rating,
              min(Average)
      FROM  table1 P
            LEFT JOIN table2 C 
      ON    P.pk = C.pk
      WHERE P.sector IN ('goto', 'xumb')
      ORDER BY GP.rating

Source:
 
Users who have marked this routine as a favorite
 
 
 
The site ti4fun is not responsible for the content on sites for which you have external links

Articles, routines, tips, forums, blogs or any other content posted on ti4fun site is not tested and not validated, so you should test and validate any information collected on the ti4fun site before applying it to final use environment, such as example, production. the TI4FUN site is not responsible for quality or for any damages, direct, indirect or consequential, from use of any content posted by the authors in the site.

All content published on the ti4fun site is the responsibility of the author and do not necessarily express the views of the site ti4fun and its employees.