Please post sample data and required output.

'' or empty date = 1900-01-01

dateadd 16 = 1900-01-17

I'd try convert(date, nullif(str_datecol, ''))

Here's my emergency ready made script to shrink a db.

Change the correct log size for your needs.

Comment out the backup script start if you don't want it, but I would...

Google & LEARN events.

You need to become self-teaching. You can't depend on someone else to do that for you.

In vba the code will look like

me.text1 =...

Add the 2 columns in the select that fills the combo, change the # of columns property in the combo. Set the witdh for those colums to 0;

So it...

Happy to help.

I'm sure I've seen those maps documented in the past. I just can't find them anymore. Granted it's almost 3 fulls versions back now....

Can't find it either on google.

This is the only thing I found that may help you out.

http://www.sqlservercentral.com/Forums/FindPost387744.aspx

I don't have access to my 2k5 machine so I can't open the trace.

Go in master and open up that proc.

Copy the code out to QA and run one statement at a time untill you find the query that does the...

Close EM, start profile, open the GUI to see ignore_dup_key on.

Save the trace and send it over here (edit attachements).

start profiler and open the property window. It must be hidden in a status column or something like that.

Yes but ignore dup key is not one of the options for that function.

I've spent a few minutes looking all over the place and I can't find that info anywhere....

SELECT VISIT_DATE

, SUM(CASE WHEN CLINIC <> 'Inpatient' THEN 1 ELSE 0 END) AS OutPatients

, SUM(CASE WHEN CLINIC = 'Inpatient' THEN 1 ELSE 0 END) AS Inpatient

, SUM(CASE WHEN CLINIC...

I don't understand the way you get the outpatients value. This is the closest I can get you without more info.

SELECT VISIT_DATE

, COUNT(*) AS OutPatients

, SUM(CASE WHEN CLINIC...

Revenant (12/16/2011)

GilaMonster (12/16/2011)

It's not a Denali bug. It's been reproduced in everything from SQL 2000 right up to...