Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Total DECIMAL(10,5)
- DECLARE @product DECIMAL(10,5)
- DECLARE @B BIT
- SET @B='True'
- SELECT
- @Total =SUM(CASE WHEN TypZasobu!=1 AND TechnologiaCzynnosc=394 THEN Ilosc ELSE 0 END ),
- @product = SUM(CASE WHEN TypZasobu=1 AND TechnologiaCzynnosc=394 THEN Ilosc ELSE 0 END )
- FROM TechnologiaZasoby
- Print @Total
- Print @product
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement