• riya_dave (8/1/2013)


    this is my DDL

    create table member

    (memberid int,

    primarycondition varchar(50),

    PrimaryIntensity int,

    secondarycondition varchar(50),

    Secondaryintensioty int)

    sample data i already provided in my previous thread

    I am not a paid employee of this site. I do not want to go digging around through all your posts to find the information that you should be providing. I say this because I truly want to help, but you don't seem willing to put in even as much effort to a solution to your problems as you are expecting of other to do. I know that there a number of people around these forums who see certain posters names and simply skip on to the next one because they know the post is not going to have the details to offer much help without a lot of effort. Your name is certainly on that list. You need to make an effort at making it easy on the folks who are offering their advice free of charge.

    _______________________________________________________________

    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/