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-04 : 08:53:30
|
Rafi writes "Howdy Guru!
I've been wrestling with this for awhile, and I just can't come up with a solution, so maybe you could help me.
In my stored procedure, I receive two parameters, a Condition, and PropertiesToReturn.
SELECT @PropertiesToReturn, IDENTITY(int, 1,1) AS ID
INTO #TempTable
FROM Products
WHERE FREETEXT (*, @Condition)
As you can see I'm trying to SELECT the rows into a temporary table, but the @PropertiesToReturn just can't fit there because of the error SQL generates into my face.
I'm aware of the EXEC command, which can help me if I build my query into a temp_sql_query, but when trying this, I realized the EXEC command didn't create the #TempTable.
So I'm clueless.
(BTW: Could you post me your answer also to my Email please? :)" |
|
|
|
|
|
Dynamic Parameters, EXEC command and CREATE TABLE.