March 29, 2013 at 1:40 pm
Hi,
i have a table which looks like this:
custiditemdateamount
131-1-2013 1
121-1-2013 2
241-2-2013 2
241-2-2013 1
and i want to make it look like this:
dateitem1item2item3
1-1-2013
custid
1201
1311
1411
1-2-2013
custid
2511
2111
2411
can anyone help me with some guidence on this
thanx in advance,
regards,
bryan
March 29, 2013 at 2:15 pm
bryan van ritter (3/29/2013)
Hi,i have a table which looks like this:
custiditemdateamount
131-1-2013 1
121-1-2013 2
241-2-2013 2
241-2-2013 1
and i want to make it look like this:
dateitem1item2item3
1-1-2013
custid
1201
1311
1411
1-2-2013
custid
2511
2111
2411
can anyone help me with some guidence on this
thanx in advance,
regards,
bryan
I would recommend you take a few minutes and read the article found at the first link in my signature. It explains the best practices for posting questions. If you post ddl, sample data and desired output like in that article you will have lots of people jumping on your issue and you will get an answer very quickly.
_______________________________________________________________
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 31, 2013 at 1:36 pm
solved the problem myselve.
bryan
March 31, 2013 at 3:43 pm
bryan van ritter (3/31/2013)
solved the problem myselve.bryan
Great! That is good news. Now, forum etiquette would have you post your solution as it may benefit others with a similar problem or issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply