Filter Derived Column!!!

• Anjali-159814

  SSC-Addicted

  Points: 435

  More actions

  February 3, 2005 at 10:30 pm

  #84693

  Is this possible?

  Select CategoryID, dbo.getNoOfItems(CategoryID) AS NoOfItems where ParentID = @ParentID and NoOfItems > 5

  getNoOfItems is a udf which returns an int value after complex calculations.

  Thanks in advance.

• babuganesh2000

  Hall of Fame

  Points: 3123

  More actions

  February 4, 2005 at 12:21 am

  #540611

  Select CategoryID, dbo.getNoOfItems(CategoryID) AS NoOfItems where ParentID = @ParentID and dbo.getNoOfItems(CategoryID)  > 5

   

  I hope this would work.

   

  Cheers,

  Ganesh