SQL SERVER INTO ??

I am doing some trouleshoot, can someone help me breakdown this statement below to help me understand clearly. For the most part the statement is select records and looping through the records. After the cursor is the INTO Statement inserting values into the variables below. Look at the bold print below.

FETCH NEXT FROM curDCS INTO @Jobnumber,@Phase,@Hours,@PayType,@TimeSheetDtlID

SELECT @numLineSeqNumber = COUNT(1) + 1

FROM TimesheetDtl

WHERE TimeSheetHdrId = @TimeSheetHdrId

AND @TimesheetLineKey IS NOT NULL

DECLARE curDCS CURSOR

FOR SELECT Jobnumber,

Phase,

Hours,

PayType,

TimeSheetDtlId

FROM TimesheetDtl

WHERE TimeSheetHdrId = @TimeSheetHdrId

AND intTimeLineKey IS NULL

OPEN curDCS

FETCH NEXT FROM curDCS INTO @Jobnumber,@Phase,@Hours,@PayType,@TimeSheetDtlID

2 Replies

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

David Smith10y ago
Thanks
0
Manas Mohapatra10y ago
FETCH NEXT FROM curDCS INTO @Jobnumber,@Phase,@Hours,@PayType,@TimeSheetDtlID

It fetch next raw from cursor and assign column values to respective variables like JobNumber, Phase, Hours, PayType and TimeSheetDtID. And these variables are already declared before this statement executes.
0