Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

passing comma delimited string as parameter to stored proc Expand / Collapse
Author
Message
Posted Tuesday, March 4, 2014 7:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 13,138, Visits: 11,977
bikrant.sharma (3/3/2014)
REPLACE(@DefaultValue, ',',''',''')
@DefaultValue = '''' + @DefaultValue + ''''


That doesn't help with a parameter. That is why you have to parse it. Read through the responses in this thread.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1547323
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse