Date sorting using MS SQL

[Ddave]

So we were tasked to sort birthday records by month and date, then year.

 

Here's my solution:

SELECT userbirthdayFROM usertableORDER BY DATEPART(DY, userbirthday) ASC, YEAR(userbirthday) ASC;

While you can just sort it by userbirthday, it is not what the requirements state.

We were given a tip that at the minimum, we should use ORDER BY twice.

 

What do you think of my solution guys ?

[alex75871]

I can't test this as I don't have a local SQL server to test on at home but you could try this?

 

orderby datepart(dd, bday), datepart(mm, bday), datepart(yy, bday) asc;

 

this will order by day then month then year.

 

you only need to specify the direction (asc, desc) once at the end of the statement.

[Ddave]

orderby datepart(dd, bday), datepart(mm, bday), datepart(yy, bday) asc;

 

 This was the first solution I came up with. Then we were told that we should use order by twice.

[alex75871]

 This was the first solution I came up with. Then we were told that we should use order by twice.

 

They tell you to order by 3 criteria and say you can only use orderby twice?  :huh:

[Ddave]

They tell you to order by 3 criteria and say you can only use orderby twice?  :huh:

 

There are only two criterias:

1. Month and Date

2. Year

 

Since I don't know of any functions that get's Month and Date at the same time, I decided to use DY Datepart.

[alex75871]

There are only two criterias:

1. Month and Date

2. Year

 

Since I don't know of any functions that get's Month and Date at the same time, I decided to use DY Datepart.

 

Month and Date doesn't make any sense, they should really clarify this. I think DY is a safe bet from what you're saying.