meghna.bhargav (9/6/2013)
I do understand what you mean! But I am in middle of Live issue thinking if i post here, I can get solution.When you start typing the issue in the message box, it does not take table format nor space formatting as it is in word or outlook.
Anyways, Thanks for taking time on this.
Meghna
If you use the IFCode shortcuts (over on the left when posting) it will keep your code cleanly formatted. You should be typing your code in SSMS instead of Word. You can't test your script in there. 😛
I understand you are dealing with a production issue. This is all the more reason to make it easy for people. You will get a LOT more people willing to help when your post is easy to use.
I apologize if you think I am being a pain, I am trying to help you understand the best way to get the assistance that you need.
Are you good now with your issue or do still need some help?
_______________________________________________________________
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/