Here: DateOnly function

you may find UDF dbo.DateOnly.

If @DateTime = dbo.DateOnly(@DateTime) then there is no time portion.

As I said, I eventually...

Jeff Moden (9/16/2008)

---

Could re-export what you think is good and reimport letting the split occur. Only other way I can think of to do it all in T-SQL would...

I've already shown you once.

You should just avoid implicit conversions...

WHERE dbo.Transportation_ServiceSchedules.OId = ' + CONVERT(VARCHAR(10), @id) + ' + ')'

Wrap your query into derived table and select FOR XML from there.

I believe consistent deadlock statistics will add to my info something even more useful as soon as you've got 2 or more users start to do updates on the "table...

If I was you I'd create small and effective trigger on that table updating another, properly formatted table(s) when the value is updated.

Then I'd gradually move selects from old to...

Jim Russell (9/16/2008)

---

FWIW - I noted a reference to @today (or something) earlier in your comments. I have been bit big time by T-SQL deciding that a time variable...

You'd better split it for data storage purposes.

And (if needed) concatenate for display purposes.

It would save you from a lot of problems.

Google "Normalization Rules" - sometimes it's useful to know...

I don't deal with updates on tables with a ton of column.

It would compromise my professional reputation.

I don't do crap.

It "eats" the comma from the last value.

I explained why it's not an option.

Even worse - those REPLACEs don't work.

For another string :

'"Pick-up",,"",1234,"2008-08-24", "2008-08-24","17"", unknown brand"'

it fails.

BCP is too vulnerable to format errors.

And...

If I try to import file with wrong formatting (broken rows, unquoted delimiters in strings, missing header or header row where it not supposes to be, etc.) I'll end up...