• vigneshlagoons (10/9/2013)


    Hi Sean,

    So for this time are these dats enough.

    Here is the challenge. You are looking for help to your problem. From what you have posted it will take me an hour to put this together into something so I have your tables and data on my system. That means an hour of effort just to setup the problem. Keep in mind that you are the one getting paid for this, not me. We are all volunteers around here. Yes I could cobble together enough to put this together but I don't have an extra hour in my day to do the leg work. Maybe somebody else is bored and will step up to do this for you.

    _______________________________________________________________

    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/