Create temp table and insert into in store procedure

DECLARE @singleDuplicateData TABLE (
ID NVARCHAR(50),
StyleID NVARCHAR(50),
CLID NVARCHAR(50),
FileName NVARCHAR(550),
FilePath NVARCHAR(550)
)
INSERT INTO @singleDuplicateData
        (
          StyleID ,
          CLID ,
          FileName,
 FilePath
        )

select top 1 StyleID,CLID,FileName,FilePath  from #temptblFiles  t  WHERE t.CLID=@CL AND t.StyleID=@Style

Comments