Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarathkumartata
Starting Member
1 Post |
 Posted - 2010-07-14 : 12:18:59
|
| HelloCan any one help getting this one.I have two columns 1)date of birth 2)starsign(ex:tarus, gemini, sagittarius)like these.My question isif 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 itthanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-14 : 14:31:04
|
You need a table with the starsigns too.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2010-07-15 : 11:18:59
|
| ...and the begin and end dates for each star sign.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-15 : 11:32:28
|
| Doesn't the "cusp" move? And what about leap years? (I'm no astrology, so I have no idea if those are real issues, or not) - mind you, a calendar-table could take care of that of course |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-15 : 18:50:08
|
Yeah ... but you said (over there):"you are lucky that you don't have to account for leap years (I am thinking of February 29th) because Pisces stretches over that day."and the linked site says (as I thought): "the above dates are a only for guidelines, because of leap years, time zone differences and other factors, the exact dates and time when the sun changes signs varies each year" so its fine for an approximation, but using a computer could be SO much more accurate ...  |
|
|
|
|
|
|
|
|
How to calculate starsign(ex:sagittarius,tarus)