March 2, 2015 at 12:37 pm
Hello everyone, need some help here. I have the following results:
ID, Office1
1, Testing
1, Hello World
What i am trying to do is to get this result:
ID, Office1, Office2
1, Testing, Hello World
Any ideas how i can accomplish this task.
March 2, 2015 at 12:51 pm
This is pretty straight forward. You can use PIVOT or my preference is to use cross tabs. See the articles in my signature about cross tabs. If you know how many columns to end up with you can use the static version. If not, you will need to use the dynamic version.
_______________________________________________________________
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/
March 2, 2015 at 3:39 pm
I reviewed the Cross Tab and Pivot queries you suggested. I went with Cross Tab, but i am getting this result now.
ID, Office, Office1, Office2
1,Testing, Testing, NULL
2,Hello World, NULL, Testing
March 2, 2015 at 4:06 pm
charlesafarr (3/2/2015)
I reviewed the Cross Tab and Pivot queries you suggested. I went with Cross Tab, but i am getting this result now.ID, Office, Office1, Office2
1,Testing, Testing, NULL
2,Hello World, NULL, Testing
It is probably something pretty straight forward. However, I have no idea what your tables look like, what the query is that you ran etc. In short, I can't help you with the code because I have no details. Please see the first article in my signature for best practices when posting questions.
_______________________________________________________________
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/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply