Post reply

Sub query check??

  • March 21, 2005 at 5:18 pm

    #548100

    SELECT CategoryID,

      CategoryName + Case IsNull(dtSubs.NoOfSub, 0) When 0 Then '' Else ' there are subs' End            

    FROM Categories c

    LEFT JOIN

    (

      SELECT ParentID, COUNT(*) AS NoOfSub

      FROM   Categories

      GROUP BY ParentID

    ) dtSubs

    ON (dtSubs.ParentID = c.CategoryID)

    WHERE     (c.ParentID = @CategoryID)

  • March 21, 2005 at 5:31 pm

    #548102

    Thanks a lot PW.  Works perfectly.

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

You must be logged in to reply to this topic. Login to reply