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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 useing local variables in cursor

Author  Topic 

Swati Jain
Posting Yak Master

139 Posts

Posted - 2009-07-01 : 04:51:26
declare @count int

DECLARE curBilling CURSOR FOR
select query...

open cur..
into var..

insert into tlb(count)value(@count)
here set @count=@count+1 -----Here cursor dont allow to use local varibale

how to overcome?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-07-01 : 05:45:51
Show more please.
At this point I cannot see any mistake.

Fred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -