December 3, 2013 at 9:30 am
I need to display a bunch of data for a single category.
Category - IT and Hardware
Configuration_Items - Servernames approx 6000
I do not understand what char type should I use to show that much data.
Even when I group its around 2000 rows.Some have 5 rows of same category
December 3, 2013 at 9:48 am
sharonsql2013 (12/3/2013)
I need to display a bunch of data for a single category.Category - IT and Hardware
Configuration_Items - Servernames approx 6000
I do not understand what char type should I use to show that much data.
Even when I group its around 2000 rows.Some have 5 rows of same category
Going to need a bit more detail here. What are you trying to do? Are you merging all the rows into a single row or do you have multiple rows in your output? What do the tables look like? What does the data look like? What do you want for output?
Please take a few minutes and read the first article in my signature.
_______________________________________________________________
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply