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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- RKD2005
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
