SQLServerCentral - Scripts by Luigi Marinescu

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,800 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,194 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,334 reads