I am trying to figure out how to do this query using T-SQL that will allow me to query the table it finds the data in. Currently I have this in a stored procedure and @Temp is the temp table it puts the results in. It just shows that it found the data in table X in column X.

Hey all I am trying to figure out how to do this query using MS SQL T-SQL that will allow me to query the table it finds the data in. Currently I have this in a stored procedure and the @Temp is the temp table it puts the results in. It just shows that it found the data in table X in Column X.

I am trying to add to a string as follows: