Sign in
|
Join
Home
Blogs
Ask
Just Learned
Interview Questions
Puzzles
Tutorials
Quiz
Modules
Getting Started with Adobe After Effects - Part 6:
Motion Blur
Liked
TSQL Beginners Challenges
Upload Image
Close it
Select File
This challenge is to find the date based on year, month, day of the week and weekday number. Say for example, if the question is to find the date of 2nd Sunday of January 2010, the answer should be '2010-01-10'.
Like
Invite Friends
TSQL Beginner's Challenge 2 - Fight Your Fear for Date Calculations
Home
·
Challenge Details
·
Comments
·
Solutions
·
Fans (46)
·
Preferences
0
Liked
Wheeww! Never having really messed around with this type of date manipulation, this took me a few days of work!
Found this quite the challenge, as I've never handled this type of date manipulation. I returned null instead of invalid date as I don't like to save dates as characters....
Sheldon
Posted on Apr 9 2013 12:00AM
Profile
1
Liked
Solution: TSQL Beginers Challenge 2 Date Calculations
This includes couple of iterations....
Bhakti
Posted on Apr 3 2013 12:00AM
Profile
0
Liked
TSQL Beginers Challenge 2 Date Calculations
This includes lot of iterations....
Bhakti
Posted on Apr 3 2013 12:00AM
Profile
0
Liked
Beginner Challenge 2 Solution
There is a lot of repetition that could be avoided by using functions. ...
djdenton
Posted on Nov 14 2012 12:00AM
Profile
·
Facebook
0
Liked
Solution
...
pilipala
Posted on Jan 10 2012 9:16PM
Profile
0
Liked
Solution
...
pilipala
Posted on Jan 10 2012 9:15PM
Profile
0
Liked
Solution
Uses a recursive CTE and several nested CTEs, test built in....
ThatGuyDuncan
Posted on Dec 28 2011 3:28PM
Profile
0
Liked
Solution for tsql beginner's challenge 2
not the most efficient, but works...
vlraks
Posted on Nov 10 2011 2:48AM
Profile
0
Liked
1
Comments
Solution to TSQL Beginners Challenge 2
Solution to TSQL Beginners Challenge 1...
pammy107
Posted on Oct 17 2011 12:33PM
Profile
0
Liked
Solution to TSQL Beginners Challenge 2
Solution to TSQL Beginners Challenge 1...
cgeach
Posted on Oct 11 2011 6:04AM
Profile
Previous
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
...
Next
Copyright © Rivera Informatic Private Ltd
Contact us
Privacy Policy
Terms of use
Report Abuse
Advertising
[ZULU1097]