Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-10 : 14:55:07
|
Marius writes "I have the following query:
DECLARE @ActivityString VARCHAR(100),
SET @ActivityString = '3,14,15,16,17,4,5,6,7,8,9,10,1'
SELECT DISTINCT Reference.reeReferenceID
FROM Reference
INNER JOIN StatusReference ON Reference.sreStatusReferenceID = StatusReference.sreStatusReferenceID
AND Reference.sreStatusReferenceID = 1
INNER JOIN ReferenceDialog ON Reference.reeReferenceID = ReferenceDialog.reeReferenceID
AND ReferenceDialog.acyActivityID IN (@ActivityString)
Of course I get error...How can I make this work without to string the select clause t.ex.
DECLARE @ActivityString VARCHAR(100),
@SQL VARCHAR(2000)
SET @ActivityString = '3,14,15,16,17,4,5,6,7,8,9,10,1'
SET @SQL = 'SELECT DISTINCT Reference.reeReferenceID
FROM Reference
INNER JOIN StatusReference ON Reference.sreStatusReferenceID = StatusReference.sreStatusReferenceID
AND Reference.sreStatusReferenceID = 1
INNER JOIN ReferenceDialog ON Reference.reeReferenceID = ReferenceDialog.reeReferenceID
AND ReferenceDialog.acyActivityID IN ('+@ActivityString+')'
EXEC(@SQL)" |
|
|
|
|
|
|
|
String