Home Forums SQL Server 7,2000 T-SQL Use Results from a Cross Join for dynamic SQL RE: Use Results from a Cross Join for dynamic SQL

  • Yes, I think thats right for one respondent. I am saying

    1 A Yes

    1 B Yes

    1 C Yes

    Might produce 1 A or 1B or 1 C if 1 respondent has answered 1 to all the products.

    However with if we have 2 respondents and resp1 give yes to A and B. And Resp 2 gives Yes 2 only A & C

    then A=2,B=1, and C=1

    quote:


    Are you saying

    1 A Yes

    1 B Yes

    1 C Yes

    produces

    A 1

    AB 1

    AC 1

    BC 1

    and

    1 A Yes

    1 B Yes

    1 C No

    produces

    A 1

    AB 1


    Edited by - AKshah1 on 05/07/2003 07:51:49 AM