Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Scotty2
- Order by date
-
Incremental Counter
Hi Tim1 My temporary table is "#x_temp". My Spare Field is "counter", set to zeros on creation. If I write : - update #x_temp set counter = (select max(t2.counter) + 1 from #x_temp t2) then all the rows have counter set to 1. If I leave out the 2nd reference to #x_temp, I...- Scotty2
- Post #5
- Forum: Sybase: Adaptive (SQL) Server
-
Incremental Counter
Tim I am doing my processing from within a Stored Procedure, using SELECT bla bla INTO Temporary Table from bla bla. Can "Sequenced Columns" be set-up for a Temporary Table's column, within such a scenario ? I have Sybase Books ONLINE, & SQL Server 11 .0 Generic / Reference Manual...- Scotty2
- Post #3
- Forum: Sybase: Adaptive (SQL) Server
-
Incremental Counter
Hi. My table is in the order I want it to be, but I need to update a spare field in each row with an incremental counter, so that I can do an "order by". ie Field1 Field2 Spare Field Row 1 AAA 02 17 2001 Set value to 1 Row...- Scotty2
- Thread
- Replies: 4
- Forum: Sybase: Adaptive (SQL) Server
