Want to know the latest news and articles posted on SQLTeam.com Forums - Latest posts?
Then subscribe to their feed now! You can receive their updates by email, via mobile or on your personal news page on this website.
See what they recently published below.
Website title: SQLTeam.com Forums
Is this your feed? Claim it!
The big thing to avoid if possible is anything like this, because it could have bad performance consequences:
WHERE YEAR(f.birthdate) = 2012hi mateen
solved it in a couple of seconds in "PYTHON"
not like t-sql ... so many functions logics exists not exists ... so confusing .. only with a lots of experience or learning very very quickly .. you can do it in t-sql
Actually not an issue. You could use just a year to generate the birthdate range, since that’s better for you.
AND f.birthdate BETWEEN CAST(year_param AS char(4)) + ‘-01-01’ AND CAST(year_param AS char(4)) + ‘-12-31’