Monthly Archives: June 2008

SQL – Using COALESCE to Build Comma-Delimited String

I had a query that returned one column with multiple records.  I wanted only one record with all the values to be comma separated.  I could do this with a cursor, but that throws a big warning sign.  So i … Continue reading

Posted in SQL Server | Leave a comment

How to find SQL Relationship and Dependencies (Dependency)

    SQL SERVER – Query to display Foreign Key relationships and name of the constraint for each table in Database. I tested the query at the following website and it seems to work.  In the response section someone claims … Continue reading

Posted in SQL Server | Leave a comment