sql - Select Top 1 field and assign to local variable -

sql - Select Top 1 field and assign to local variable -

i want take value of extracteddate query , utilize @lastextractdate in next query. how do that?

select top 1 [extracteddate] [onsitev4].[dbo].[sqlpendingindex] order extracteddate desc

next query:

insert @table(hex, keydeviceid, objectdatetime, extracteddate ) select convert(varchar(max), convert(varbinary(max), objectvalue, 1)) hex, keydeviceid, objectdatetime , getdate () sqlpending (objectsubtype '%gas%') , (objectdatetime > @lastextractdate)

why not utilize this:

declare @lastextractdate date select top 1 @lastextractdate=[extracteddate] [onsitev4].[dbo].[sqlpendingindex] order extracteddate desc

sql sql-server