• vishnurajeshsat (8/2/2012)


    Dear Sean Lange & SSC Rookie,

    Thanks for your reply.I cant able to show my table in this forum. Can you tell me how to add image in this forum then i will explain clearly that what i am really struggling.

    Why can't you share the table structure? If it is because of not wanting to share your real structure just make something up that is close and only has the columns you need. Change the names and such to protect yourself. Then post some sample data. Again change values and do what you need to protect the real data. Everything you can do to make something close to your real issue will help.

    An image is not really going to provide much to allow us to help you with the code.

    _______________________________________________________________

    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/