lisa.ogle (9/5/2013)
If you looked at my earlier post- I posted my query I posted the error message and i attached a sample of my data on my last post to the person that was trying to help me Any good psychic would have noticed that. I have decided to use another option but thank you for your time. Good Day. Tell me can you tell what I am thinking?....
I am guessing you have no idea who Erland is? Might want to google his name and read up about the ability of the person who was trying to help you. The list of things he stated that need to be posted to offer solid assistance is absolutely correct. I had suggested you look at the link in my signature would have told you the same thing.
I am glad you were able to figure out another way to solve your issue. Come back again if you need assistance.
_______________________________________________________________
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/