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 2000 Forums
 Transact-SQL (2000)
 cursor

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-23 : 09:45:17
mac writes "how can i write a cursor that will populate just a sequence that doesnt start with 1 like i have and id with a sequence 1,2,3,4 bu i only want the cursor to show the id and the number of sequence that doesnt have the number 1 in it"

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2006-08-23 : 09:47:20
how bout an example of a sequence you might want to generate... one that doesn't include '1'...

Corey

Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."
Go to Top of Page

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-08-23 : 09:49:34
have look at this function

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47685&SearchTerms=Numbers,table

Chirag
Go to Top of Page
   

- Advertisement -