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

Popular posts from this blog

How to use DbFunctions.TruncateTime

Microsoft Access Connectivity from C#

Tool 'dotnet-ef' failed to install. dotnet core