You can use datepart to extract the month, and day, and then concatenate them together.

cast( datepart(mm, mydatecolumn) as char(2)) + '/' + cast( datepart(dd, mydatecolumn) as char(2))

For your discussion: https://medium.com/@sailorhg/coding-like-a-girl-595b90791cce

I didn't think we cached the forum pages, but perhaps we do. I'll ask someone to flip through the code and see.

I see it on this page: http://www.sqlservercentral.com/Forums/Forum391-1.aspx

eddy.b (3/18/2015)

---

It is quite odd to see your responses when working in Bioinformatics. Computational biology / bioinformatics started in the seventies, and statistics has always played a very important role...

Thanks, I'll take a look.

That's a fair statement and good suggestion. Part of the issue is having enough experience with an ORM (or multiples) to suggest things.

I'll see what I can do in terms...

I want to ask this as well. Specifically with...

Gary Varga (3/16/2015)

---

I am all in favour of bringing all options to the table but sincerely hope that we do not allow statistics to start to rule medical science. I...

Perhaps, but that's still just a storage design for the data. I bet there are some interesting queries written...

It was great to meet you, Gianluca, and sorry we didn't get to talk more. I'll have to get down to Italy at some point.

And yes, you are a giant...

Eric M Russell (3/13/2015)

---

My point earlier was that this form of comment is useless; it's basically just re-stating in engligh the functional operation of a single statement. But T-SQL is...

What Sean said, but also, if you need to move large amount, pregrow your log file so it doens't need to happen during the copy.

Yes, sorry, remake of Star Trek, the modern two versions.

http://www.sqlservercentral.com/Forums/Forum3665-1.aspx