Thanks in advance
Please, help me with a code to assign query result ( count(*)) to @RowCount.
/* DECLARE Part Omitted */
SET @Job_Code = '(Job_Code = ''A'')';
SET @RowCount = -1;
SET @SQL = 'Select Count(*) FROM MyTable WHERE' + @Job_Code;
/* Help please!
I need code kind of doing assining Count(*) to @RowCount --
SET @RowCount = EXEC(@SQL)*/
the following SQL also work..
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?