RE: Query to get first number
How About this declare @j int declare @i int set @j=1 declare a cursor for select [column] from order by [column] open a fetch next from a into @i while @@fetch_status=0 begin if @i<>@j begin break end set @j=@j+1 fetch next from a into @i end print @j close a deallocate a Pay Respect to […]
2003-08-29
1 reads