nicoleaslater (9/26/2012)
I AM new, and I am grateful for your help. I am actually quite new at query writing as well and I often find exactly what I am looking for on this forum without asking a question, so this was my first go. I see what you are saying for next time.For now, thank you. What you wrote is pretty close to what I am talking about. I have been playing with converting these to integers but I am still getting conversion errors. I think utilizing your solution, which is a bit more complex than mine, will work for me. Thanks again, hopefully I won't be back with more questions. 😉
No problems. You should not feel guilty about asking questions when you need help. But you seem to be someone who is willing and/or desires to figure it out on your own. That is excellent and you always learn more from making mistakes than getting it right. 🙂 If you do need more help in the future don't hesitate. Now you know the type of format to post in. Keep in mind that especially in your field you don't have to post the full tables and the should always be generic.
Give a shout back here if you need some help tweaking your code into the final shape.
_______________________________________________________________
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/