Home Forums SQL Server 7,2000 SQL Server Newbies SELECT TOP into variable RE: SELECT TOP into variable

  • May 7, 2008 at 2:06 am

    #811620

    The top's in the wrong place

    SELECT TOP 1 @ID = OrderVal FROM qryCust

    WHERE OrderNo = '000663' AND DiscountGroup = 'XXND' AND CustID = 3

    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