Thread
:
Use Temp Table Variable in Stored Procedure
View Single Post
#
3
(
permalink
)
April 15th, 2011, 03:50 PM
joshgeake
Registered User
Join Date: Apr 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
solution
I wrote a post about this a while ago - you essentially need to form the sql statement first by declaring a long varchar and then executing it.
http://www.geakeit.co.uk/2011/02/05/a-table-input-variable-in-a-stored-procedure-and-bypassing-must-declare-the-table-variable-msg-1087/
joshgeake
View Public Profile
Find all posts by joshgeake