SHARE
TWEET

Untitled

a guest Apr 24th, 2019 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE PROCEDURE Horoskopy22 (@datum DATE)
  2. AS
  3.     DECLARE @datump DATE
  4.     SET @datump = @datum
  5.     IF((MONTH(@datump) = 03 AND DAY(@datump) >=21) OR (MONTH(@datump)=04 AND DAY(@datump)<=20) )
  6.     BEGIN
  7.     PRINT 'Ovan' ;
  8.     END
  9.     IF((MONTH(@datump) = 04 AND DAY(@datump) >=21) OR (MONTH(@datump)=05 AND DAY(@datump)<=20) )
  10.     BEGIN
  11.     PRINT 'Bik' ;
  12.     END
  13.     IF((MONTH(@datump) = 05 AND DAY(@datump) >=21) OR (MONTH(@datump)=06 AND DAY(@datump)<=20) )
  14.     BEGIN
  15.     PRINT 'Blizanac' ;
  16.     END
  17.     IF((MONTH(@datump) = 06 AND DAY(@datump) >=21) OR (MONTH(@datump)=07 AND DAY(@datump)<=20) )
  18.     BEGIN
  19.     PRINT 'Rak' ;
  20.     END
  21.     IF((MONTH(@datump) = 07 AND DAY(@datump) >=21) OR (MONTH(@datump)=08 AND DAY(@datump)<=21) )
  22.     BEGIN
  23.     PRINT 'Lav' ;
  24.     END
  25.     IF((MONTH(@datump) = 08 AND DAY(@datump) >=22) OR (MONTH(@datump)=09 AND DAY(@datump)<=22) )
  26.     BEGIN
  27.     PRINT 'Djevica' ;
  28.     END
  29.     IF((MONTH(@datump) = 09 AND DAY(@datump) >=23) OR (MONTH(@datump)=10 AND DAY(@datump)<=22) )
  30.     BEGIN
  31.     PRINT 'Vaga' ;
  32.     END
  33.     IF((MONTH(@datump) = 10 AND DAY(@datump) >=23) OR (MONTH(@datump)=11 AND DAY(@datump)<=22) )
  34.     BEGIN
  35.     PRINT '�korpion' ;
  36.     END
  37.     IF((MONTH(@datump) = 11 AND DAY(@datump) >=23) OR (MONTH(@datump)=12 AND DAY(@datump)<=21) )
  38.     BEGIN
  39.     PRINT 'Strijelac' ;
  40.     END
  41.     IF((MONTH(@datump) = 12 AND DAY(@datump) >=22) OR (MONTH(@datump)=01 AND DAY(@datump)<=22) )
  42.     BEGIN
  43.     PRINT 'Jarac' ;
  44.     END
  45.     IF((MONTH(@datump) = 01 AND DAY(@datump) >=21) OR (MONTH(@datump)=02 AND DAY(@datump)<=19) )
  46.     BEGIN
  47.     PRINT 'Vodenjak' ;
  48.     END
  49.     IF((MONTH(@datump) = 02 AND DAY(@datump) >=20) OR (MONTH(@datump)=03 AND DAY(@datump)<=20) )
  50.     BEGIN
  51.     PRINT 'Ribe' ;
  52.     END
  53.        
  54. exec Horoskopy22 '2017-6-11';
  55.        
  56. RETURN (0)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top