September 2, 2003 at 10:54 am
I am using SQL 7.0 and I am trying to create a view with a cursor inside that has a date variable inside of the cursor. Can you use a variable inside of a view??
Any help is greatly appreciated. Thanks!!!
September 2, 2003 at 11:06 am
September 2, 2003 at 12:49 pm
That's what stored procedures are for.
--
If you post the code, we can help convert it to a proc.
Edited by - jpipes on 09/02/2003 12:49:51 PM
September 3, 2003 at 1:12 pm
You can trick it by inserting the current spid (@@spid) and the value into a table, joining on the spid in the view to get the value. Hack of course. I agree that if you need params, usually you should be using a proc.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply