<br /> declare @col varchar(255), @cmd varchar(max)<br /> DECLARE getinfo cursor for<br /> SELECT c.name FROM sys.tables t JOIN sys.columns c ON t.Object_ID = c.Object_ID WHERE t.Name = 'tblDeductions' AND c.name like 'fld%name'<br /> OPEN getinfo<br /> FETCH NEXT FROM getinfo into @col<br /> WHILE @@FETCH_STATUS = 0<br /> BEGIN<br /> SELECT @cmd = 'IF EXISTS (SELECT top 1 * FROM tblDeductions WHERE [' + @col + '] IS NOT NULL) BEGIN print ''' + @col + ''' end'<br /> exec (@cmd)<br /> FETCH NEXT FROM getinfo into @col<br /> END<br /> CLOSE getinfo<br /> DEALLOCATE getinfo<br />
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)