Post reply

Convert common Separated number to # table

  • October 2, 2023 at 4:11 pm

    #4299782

    @reportParameter 1008,1009,1011,1014 values need to insert to #Table

    Note: @reportParameter is not returning values to db as string from report server

    Select * from

    STRING_SPLIT(1008,1009,1011,1014,',')

    Could you Please solution.

     

  • October 2, 2023 at 4:13 pm

    #4299783

    The value needs to be a string:

    STRING_SPLIT('1008,1009,1011,1014',',')

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply