Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Luigi Marinescu

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

JOIN technique

another way to join the tables  Read more...
By Luigi Marinescu 2009/12/07 | Source: SQLServerCentral.com | Category: join
Rating: |  Discuss |   Briefcase | 2,978 reads

Split string into table, separator can be more than 1 char

Split string like ('123,43,5465,6788,1231,111', ',') into table, separator (,) can be more than 1 char  Read more...
By Luigi Marinescu 2009/11/19 | Source: SQLServerCentral.com | Category: split
Rating: |  Discuss |   Briefcase | 1,307 reads

Display COUNT(*) but ONLY TOP 100

Let’s say you have a result set with 5000 records but you want to display only 100 of them and in the same time to display the count of ALL records (5000).  Read more...
By Luigi Marinescu 2009/11/20 | Source: SQLServerCentral.com | Category: count(*)
Rating: |  Discuss |   Briefcase | 2,416 reads
   Items 1 to 3 of 3