Click here to Skip to main content
15,922,584 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
SQL
-- set @Arg_SKU_LIST
        DECLARE @VALUES VARCHAR(max)
        DECLARE @QUERY1 NVARCHAR(MAX)
        SET @QUERY1='SELECT @VALUES = COALESCE(@VALUES + ''''''' +','+''''''' ,'''') + CAST(sku AS NVARCHAR(50)) FROM ' + @TableName +' WHERE item_active IS NULL AND ACCD='+@Accd
       EXEC SP_EXECUTESQL @QUERY1,N'@VALUES VARCHAR(max) OUTPUT', @VALUES OUTPUT
       SET @Arg_SKU_LIST=@VALUES
      set @Arg_SKU_LIST= ''''+@Arg_SKU_LIST+''''
        set @count=1



plz give some idea what acctully happen in this query?
Posted
Updated 18-Jun-12 1:26am
v3

1 solution

look This[^] it will give you some basic idea about dynamic query.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900