Home Forums SQL Server 7,2000 T-SQL How to give Parameter value to the function RE: How to give Parameter value to the function

  • August 14, 2017 at 1:43 am

    #1955106

    Newbi - Sunday, August 13, 2017 8:47 PM

    By the way, mind explaining me why you Select TOP 20 when using cross apply, rather than just select?

    Paging. So that the app gets back only 20 rows, not possibly thousands. If you have client-side paging, or if there's not much data, you won't need that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass