SQL Server Forums - How to calculate starsign(ex:sagittarius,tarus)

Question

Hello

Can any one help getting this one.

I have two columns 1)date of birth 2)starsign(ex:tarus, gemini, sagittarius)like these.

My question is

if i enter the date of birth in the date of birth column. depending on that starsign column should be filled.

can any one send me the sqlserver query for this.

how can i solve it

thanks

Answer 1

0

I'm not going to do all of these for you, but here is how I would basically handle that:

DECLARE @DOB datetime

set @DOB = '02/20/2010'

SELECT 
@DOB DOB, 
CASE WHEN (MONTH(@DOB) = 1 AND DAY(@DOB) >= 21)
         OR (MONTH(@DOB) = 2 AND DAY(@DOB) <= 19) 
         THEN 'Aquarius'
     WHEN (MONTH(@DOB) = 2 AND DAY(@DOB) >= 20) 
         OR (MONTH(@DOB) = 3 AND DAY(@DOB) <= 20) 
         THEN 'Pisces'
END

answered Jul 14 '10 at 10:57 AM

Mark
2.6k ● 20 ● 23 ● 27

+1 but you won't see it becuase I used up my alotment today. +1 in spirit.

Jul 14 '10 at 10:58 AM Grant Fritchey ♦♦

Thank you Grant. We're only alloted 5 a day?

Jul 14 '10 at 11:03 AM Mark

(comments are locked)

SQL Server Forums - How to calculate starsign(ex:sagittarius,tarus)

Follow this question

Related Questions