InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 01:22:53 GMT20http://www.sqlservercentral.com/Forums/Topic508460-8-1.aspxI think you're misunderstanding what is going on. The DECLARE CURSOR does use the variable as it's defined at the time when the DECLARE is issued. Meaning - in programmer terminology - the DECLARE CURSOR sets up and initializes the cursor in one statement. There's no deferred resolution going on. The only thing that hasn't happened yet is that the cursor hasn't been materialized (which occurs with the OPEN statement).In this case you get nothing, since at the time of the declare - the variable is NULL.This is normal behavior and to be expected.Thu, 29 May 2008 09:22:28 GMTMatt Miller (#4)http://www.sqlservercentral.com/Forums/Topic508460-8-1.aspxHi,Not sure if this is normal.I have never used a cursor in my life :-) (very happy about that)Do you have to use a cursor for this problem?ThanksChrisThu, 29 May 2008 09:13:13 GMTChristopher Stobbshttp://www.sqlservercentral.com/Forums/Topic508460-8-1.aspxHi,Im trying to use a variable within a cursor but I actually populate the variable after the cursor declaration and it doesn't appear to use the value. I created code for a sample as the code this is not working in is rather long and would be confusing if I posted itMy question is ... Is this NORMAL behavior ?For exampledeclare @tab_name varchar(200), @res_name varchar(200)--set @tab_name = 'sysowners' -- uncomment this line and the cursor will return a value--declare sample cursor for select name from sysobjectswhere lower(name) = lower(@tab_name)--set @tab_name = 'sysowners'open samplefetch sample into @res_namewhile @@fetch_status = 0 begin print @res_name fetch sample into @res_nameendclose sampledeallocate sampleThu, 29 May 2008 09:00:59 GMTjsmith7290