question

suraz avatar image
suraz asked

i m expecting single row answer in different column

![alt text][1] [1]: /storage/temp/2548-capture.png
splitstring-splitting
capture.png (2.1 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tom Staab avatar image
Tom Staab answered
You are describing a string splitter. Jeff Moden gives a very detailed explanation of various techniques along with performance test results. I suggest you read his excellent article here: [ http://www.sqlservercentral.com/articles/Tally+Table/72993/][1] Let us know if you have any questions or need more assistance. [1]: http://www.sqlservercentral.com/articles/Tally+Table/72993/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.