get all values separated by commas
How to get all values separated by commas, with only a SELECT query and a variable.
2012-07-19 (first published: 2012-07-03)
2,257 reads
Scripts
2012-07-18 (first published: 2008-01-25)
2,201 reads
2012-07-17 (first published: 2007-11-21)
2,276 reads
Function to Split Multivalued Parameter
This Function is written to split Multivalued Parameter passed by Reporting Services 2005.
2012-07-16 (first published: 2007-08-01)
2,819 reads
2012-07-13 (first published: 2008-03-20)
2,235 reads
TopBlocker
Script to log top blocker processes in a database. Top blocker is defined as the process that is at the top of a blocking chain.
2012-07-12 (first published: 2007-10-30)
3,045 reads
Check Used Table Space for User Defined Tables
Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.
2012-07-11 (first published: 2012-07-04)
1,278 reads
2012-07-06 (first published: 2012-06-29)
1,009 reads
2012-07-05 (first published: 2012-06-15)
956 reads
Remove comments from the SQL Code
Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.
2012-07-04 (first published: 2009-03-25)
2,609 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers