SELECT *
FROM sys.dm_sql_referencing_entities(<YourTableNameHere>, 'OBJECT')

Drew

I think this captures everything.

;
WITH DeliverySites AS
(
    SELECT *,
        STUFF(
            (
                SELECT ',', DeliverySite AS [text()]
                FROM #MyTemp sub
                WHERE main.POID = sub.POID
                ORDER...

Instead of doing a crosstab/pivot, you can also just use a HAVING clause with the correct criteria.

SELECT [Param]
FROM #mytable
GROUP BY [Param]
HAVING MAX(CASE...

This looks like an EAV table.  Storing things in an EAV table makes it much harder to query.  You can use Cross Tabs and Pivots to change...

Another example of people not supplying nearly enough information.  I got an email from someone saying that I met the qualifications for a job at their company and wanting to...

Use a CASE expression.

select DEP_Code, DEP_Name, cast(0 as bit) Favourite,
  case
  when DEP_Code = 'ACHR' then 7
  when DEP_Code = 'IT' then 8