sqlizcool (9/22/2015)
Thank you for teaching me how to fish, I really appreciate the tip. I was able to use join to grab the data. I am 100% more efficient than I was yesterday.
That is great and thanks for letting me know. This is not a super easy topic and you seem to have a great attitude towards it. Please come back and post again anytime you need some help. We are rather unique at this site that we like to teach you how to fish instead of handing a nicely cooked fillet. 😀
_______________________________________________________________
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/