-- if 9455 is the CID you want to test for
CREATE TABLE #tmp(tablename VARCHAR(255), UnmatchedCID VARCHAR(32));
INSERT INTO #tmp
EXEC sp_msforeachtable
'select top 1 ''?'' as tablename, ''YES'' UnmatchedCID from ? where CID <> 9455'
INSERT INTO #tmp
EXEC sp_msforeachtable
'select top 1 ''?'' as tablename, ''NO'' UnmatchedCID from ? where CID = 9455'
SELECT * FROM #tmp
DROP TABLE #tmp;
SQL Syntax return TABLE NAMES by column VALUE
Posted - 11/21/2012 : 12:40:35
