the -n on...

What Adam said....:)

Time to change the bag on the caffeine infusion..... :blink:

This might very well suck performance-wise against your data, but here goes:

drop table overlap

drop table #mytable

go

create table overlap(rid int identity(1,1), st datetime, ed datetime,amt money)

go

insert overlap(st,ed,amt)

select '01/01/2008' ,'01/10/2008' ,'1.00'...

don't sort by the converted dates. Sort by the "raw" date:

Select Location,

CONVERT(CHAR(10), datetimestamp, 101) as "Date",

...

Also - you don't get an error, because your WHERE clause is throwing out the update.

If you want the CATCH to fire - take the WHERE clause out.

Better yet -...

Would this have anything to do with using Native format (as opposed to character format?)

Besides this being a double-post.... Isn't the Server and DB setting missing? (don't you have to tell it which server to talk to?)

..please don't forget to turn the Array into an XML data stream as the output....

or

...be sure to do all of your data conversions (to wide Char(400) strings of course) FIRST...

Sorry I'm showing up late to the party...:), but - you don't really need to use a function for this. You can simply flip the LIKE syntax on its...

By the way - there are commas missing in my original query (that's going to confuse the old parser).

That should actually be:

select

...

I'm not a BCP expert - but you're not specifying database and server to run this against. Assuming you do that - I'm thinking you'll be back to needing...

Well - without any specifics, it's going to be tough to know if this is applicable. However - assuming your table had an XML column called X, and X...

You're looking to filter on a grouped running count. Meaning - create a running count (which then "creates" the ranking for the TOP x concept), and then filter by...

Here's the Technet article on how to move system DB's:

http://technet.microsoft.com/en-us/library/ms345408.aspx

TOP xx entails an order (you have to establish a ranking of some kind in order to figure out which ones are "top"), so - you I'm thinking...