select

[Date of Birth] = dateadd(month,(12*BirthYear)-22801+BirthMonth,BirthDay-1)

from

(

-- Test data

select

BirthYear= 1975,

BirthMonth= 12,

BirthDay= 30

) a

Results:

Date of Birth

------------------------

1975-12-30 00:00:00.000

(1 row(s) affected)

Unfortunately, the costs spent do matter, because if they declare the project a failure, then all the costs of the project will have to be written off immediately, instead of...

mhaskins (5/27/2008)

---

Michael Valentine Jones (5/27/2008)

---

I give people I interview a test of SQL questions, four that I expect that anyone worth hiring can solve, and one that I expect most...

Why do you think a max body size of nvarchar(max) limits your email content to 4000 characters?

Have you run a test to see if it is actually limited to 4000...

I give people I interview a test of SQL questions, four that I expect that anyone worth hiring can solve, and one that I expect most people will not be...

Unfortunately, it is much more likely that management will look at the mounting costs of a long overdue project and set an ultimatum for the project manager like “If it...

I don't think you can use a local temp table with sp_send_dbmail.

Create a global temp table using newid() to generate the table name, and use that.

declare @temp_table_name sysname

set @temp_table_name =...

Following a consistent style is an important part of any system for several reasons:

1. It makes it easier to figure out what the last person was doing.

2. You don’t have...

You should avoid using global temp tables (##tablename), use local temp tables (#tablename).

This should a better way to check for a temp table. The other methods will have a...

The real fun will start when you do a large batch update that escalates to a table lock. When it finally completes after 4 hours, everyone can go back...

You might consider modifying the transaction table to include the balance at the end of the transaction. Then you will only have inserts to worry about. Add a...

I think that the support cycle fro SQL Server is too short for an enterprise level application. I think that 10 years of support after that next major software...

michael.welcome (5/9/2008)

---

Well I could post the company name, embarasing them in a public forum could be grounds for firing, so I will not. I have payments on my 2003...

I think these are a good reference for the usual relationship between DBAs and senior management.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46783

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63071

This is usually called an EAV (Entity, Attribute, Value) design.

Simply put, this approach is always a disaster. The disadvantages are so overwhelming that the small benefit they think they...