SQL Cursor example filters data from another table based on data from one table

SQL Cursor example filters data from another table based on data from one table

DECLARE @MID nvarchar (20)
DECLARE @UTime datetime

DECLARE @TBL_Temp Table
(
MID nvarchar (20),
Uptime datetime,
Chat nvarchar (20)
)

--get User
DECLARE my_cursor Cursor--Defining cursors
For (SELECT distinct MID, Uptime from Tlinktest)

OPEN My_cursor

FETCH NEXT from My_cursor to @MID, @UTime

while (@ @fetch_status =0)
BEGIN

INSERT into @TBL_Temp SELECT TOP 2 * from tlinkcontent WHERE MID = @MID and Uptime < @UTime

FETCH NEXT from My_cursor to @MID, @UTime

END

Close My_cursor

Deallocate my_cursor

SELECT * from @TBL_Temp

SQL Cursor example filters data from another table based on data from one table