How to identify that which is first and last row of cursor

declare @TblNAME table( Name varchar(256))

insert into @TblNAME values('jayesh')

insert into @TblNAME values('bhavesh')

insert into @TblNAME values('pinal')

insert into @TblNAME values('kajal')

insert into @TblNAME values('komal')

insert into @TblNAME values('sonal')

insert into @TblNAME values('yes')

declare @Name varchar(256)

declare @LastRecord varchar(256)

declare @Final table(Name varchar(256))

DECLARE CUR CURSOR FOR

select Name from @TblNAME

OPEN CUR

FETCH NEXT FROM CUR INTO @Name

WHILE @@FETCH_STATUS =0

BEGIN

if not exists(select 1 from @Final)

begin

insert into @Final values(@Name)

end

set @LastRecord = @Name

FETCH NEXT FROM CUR INTO @Name

END

CLOSE CUR

DEALLOCATE CUR

select Name As FirstRecord,@LastRecord LastRecord from @Final

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jayesh Vaghasiya8y ago
declare @TblNAME table( Name varchar(256))
insert into @TblNAME values('jayesh')
insert into @TblNAME values('bhavesh')
insert into @TblNAME values('pinal')
insert into @TblNAME values('kajal')
insert into @TblNAME values('komal')
insert into @TblNAME values('sonal')
insert into @TblNAME values('yes')
declare @Name varchar(256)
declare @LastRecord varchar(256)
declare @Final table(Name varchar(256))
DECLARE CUR CURSOR FOR
select Name from @TblNAME
OPEN CUR
FETCH NEXT FROM CUR INTO @Name
WHILE @@FETCH_STATUS =0
BEGIN

if not exists(select 1 from @Final)
begin
insert into @Final values(@Name)
end
set @LastRecord = @Name

FETCH NEXT FROM CUR INTO @Name
END
CLOSE CUR
DEALLOCATE CUR
select Name As FirstRecord,@LastRecord LastRecord from @Final
0
Code Alone8y ago
To find that use ORDER BY clause. After that user top 1 desc and top 1 asc. This may be a way for this approach.
0