@variable Concatenation problem

[Azita79]

Hi All,

in my sproc I have a local variable @strSQL. I keep concatenating to this variable in my sproc and I wana use it in my "WHERE" clause at the end.

IF ...
SET @strSQL = @strSQL + ....
IF
.
.
.

@strSQL contains something like this : 'TBL.ID = 345'
BEGIN
SELECT ....
WHERE ---->> here I wana use what's in @strSQL


any ideas?

Thanks
Azita

 

[tlbroadbent]

You can't use a variable for the WHERE clause. You must name the columns. You'll need to create a SQL statement and EXECUTE it.

Declare @strSQLStmnt varchar(4000)

IF ...
SET @strSQL = @strSQL + ....
IF
.
.
.

@strSQL contains something like this : 'TBL.ID = 345'
BEGIN

SET @strSQLStmnt = 'SELECT .... WHERE ' + @strSQL

Exec(@strSQLStmnt) Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[Azita79]

Thank you Terry

Azita