Advertisement
Guest User

Untitled

a guest
May 9th, 2018
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.36 KB | None | 0 0
  1.    DECLARE @Total DECIMAL(10,5)
  2.     DECLARE @product DECIMAL(10,5)
  3.     DECLARE @B BIT
  4.     SET @B='True'
  5. SELECT
  6.  
  7.     @Total =SUM(CASE WHEN TypZasobu!=1 AND TechnologiaCzynnosc=394 THEN Ilosc  ELSE 0 END ),
  8.     @product = SUM(CASE WHEN TypZasobu=1 AND TechnologiaCzynnosc=394 THEN  Ilosc ELSE 0 END )
  9.    
  10. FROM TechnologiaZasoby
  11. Print @Total
  12. Print @product
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement