I realize that I slightly misstated my question. How may we track user activity as it is occurring to provide support for a user that may be encountering a problem with...

SQL Server will not allow you to say

Select * from Table where ColumnName in (@Paramater)

Options include:

1) Use dyanmic SQL:

declare @DynSQL varchar(1000)

declare @Company varchar(1000) --Parameter declaration would be in proc declaration

set...

Try executing the below statement before executing the dynamic sql.

print @cprice_sql

The above statement will allow you to preview the sql before it is executed.

Also, if @LNID is a non-string...

You can highlight the table name in QA and then press Alt, F1. Make sure you are still holding down Alt when you click F1.

Hi,

Is there a way to display...