Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RKD2005
  • Content: Threads
  • Order by date
  1. RKD2005

    Error in Query

    -- Error: A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations. DECLARE @x SMALLINT SELECT AL1.Type, AL3.Name, AL3.Guid, @x = (Sum (ISNULL(AL2."Quantity Added", 0)) - Sum (ISNULL(AL2."Quantity Taken",0))) FROM dbo.Inv_Details AL1...

Part and Inventory Search

Back
Top