November 29, 2011 at 2:40 am
Hi guys and girls
I have posted this on another forum before, but I will redo it here. I have loaded an Excel file with the data in it. I am a bit new to the forums so I am not sure how to do the CREATE TABLE as I am expected to do. I am sure though, with the file, the data can just be imported as test data. I have given the file that I have at the moment, and also the way I want it to be displayed. If someone can please assist me with this. I need to do it with Visual Studio/BIDS.
Kind regards
Fred
November 29, 2011 at 9:50 am
Fred, you will have to supply a little more information.
It isn't clear from your example whether the groups across are static or dynamic, and the same goes for the rows.
Do you want to show 4 rows down, split into as many groups across as it will take? Or are the groups across fixed, with as many rows down as it will take to display all the data?
Or are these items grouped by something else that you did not supply?
Martin.
November 29, 2011 at 10:42 am
Fred, please don't cross post. it just fragments your responses. The reason nobody has answered your question is because you have not provided enough information about what you are trying to do.
Please direct all replies to the original thread. http://www.sqlservercentral.com/Forums/Topic1211822-391-1.aspx
_______________________________________________________________
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply