Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Result that matches all the values from a list

    Hi John,

    I got your point. Yes your solution is correct for my question.

    Thanks for your great help!

    Regards,

    P.Paul

    John Mitchell-245523 (8/22/2013)

    prasanta.paul 88490 (8/22/2013)

    Am I doing correct?

    You tell me. Is it returning...

    August 22, 2013 at 2:25 am

    #1643795

  • RE: Result that matches all the values from a list

    Hi John,

    I have changed the code as below. It is returning data.

    FROM

    HAVING

    COUNT(*) = (SELECT COUNT(*) FROM TblData)

    TO

    HAVING

    COUNT(*) > 0

    Am I doing correct?

    Regards,

    P.Paul

    John Mitchell-245523 (8/22/2013)

    Here you go. Obviously it doesn't...

    August 22, 2013 at 2:05 am

    #1643787

  • RE: Result that matches all the values from a list

    John Mitchell-245523 (8/22/2013)

    Join @tblData to TableB, group by StudentID, and return those rows having count(*) equal to the number of rows in @tblData. Without full DDL and sample data,...

    August 22, 2013 at 1:30 am

    #1643775

Viewing 3 posts - 1 through 3 (of 3 total)