some one write query for this problem

Question

Post reply

some one write query for this problem

writearjun53

Ten Centuries

Points: 1060
More actions
March 28, 2013 at 4:17 am

#270475

I have a table that contain a row
table name = PMInfo
pmid,member
1, jay-raj-kit
i want output like that
1 , jay
1 , raj
1, kit
Regards
Arjun.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Kingston Dhasian SSCoach Points: 19799 More actions · Answer 1

You can use the DelimitedSplit8K function for your requirement

SELECTPMI.pmid, DS.Item

FROMPMInfo AS PMI

CROSS APPLY dbo.DelimitedSplit8K( PMI.member, '-') AS DS

The code for the function is present in the article by Jeff Moden below

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/

writearjun53 Ten Centuries Points: 1060 More actions · Answer 2

Hello Kingston Dhasian,

I have tried this query but it has show error "Invalid column name DS.ITEM".

I have converted this query as my table structure.

Regards,

Arjun

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

writearjun53 (3/28/2013)
Hello Kingston Dhasian,
I have tried this query but it has show error "Invalid column name DS.ITEM".
I have converted this query as my table structure.
Regards,
Arjun

You will need to a) read the article b) create the function.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

writearjun53 Ten Centuries Points: 1060 More actions · Answer 4

Yes I have read article and found the solution

Thanks all.

Regards,

Arjun

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

writearjun53 (3/28/2013)
Yes I have read article and found the solution
Thanks all.
Regards,
Arjun

Chris forgot about step c) Understand the code. This is important because it is you that has to support it.

_______________________________________________________________

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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

writearjun53 (3/28/2013)
Yes I have read article and found the solution
Thanks all.
Regards,
Arjun

You say you found the solution, forum etiquette would have you share your solution for others.