Stored Procedure Help

[excalibur78]

I'm trying to get 2 selects to do simple math operations like add and subtract like:

SELECT Sum([DatatecConcentrators]) FROM [Inventory Tracking] -
SELECT Sum([Quantity]) FROM [Products] WHERE [Item Name] = 'Concentrators'

Where the top select return say 100 and the bottom returns 75 then it returns 25 as the result.

Thanks ahead of time.


David

 

[swampBoogie]

select
(SELECT Sum([DatatecConcentrators]) 
   FROM [Inventory Tracking] -
SELECT Sum([Quantity]) 
   FROM [Products] 
 WHERE [Item Name] = 'Concentrators') as suitableName

 

[swampBoogie]

select
(SELECT Sum([DatatecConcentrators]) 
   FROM [Inventory Tracking]) -
(SELECT Sum([Quantity]) 
   FROM [Products] 
 WHERE [Item Name] = 'Concentrators') as suitableName

 

[excalibur78]

Thanks that worked now 1 other thing fast.
How can I do a select top x from .... and use that result from the last select as x in this other select? Can't seem to figure out how to do it myself =(


Thanks a million.

 

[swampBoogie]

Neither can I. I don't understand your description.

 

[SQLBill]

Do you mean something like this (untested by me):

select
(SELECT Sum([DatatecConcentrators])
FROM [Inventory Tracking]) -
(SELECT Sum(select top 10 [Quantity] from [products] as prod)
FROM prod
WHERE [Item Name] = 'Concentrators') as suitableName

-SQLBill