Can't see an easy way of fixing that. Seems that the Excel code does not allow you to specify the delimiter and instead picks whatever you have in Regional Settings.

The...

I think you've been a forum member long enough to know that "it didn't work" doesn't cut it as a technical reply.

Change the delimiter from a comma to a pipe to avoid that issue.

Use square brackets:

CREATE USER [DT-SERVICES-TEST] WITHOUT LOGIN;

As Jonathan AC Roberts mentioned, this is difficult without knowing more....

OK, what I was angling towards is this: can your process be re-engineered to process all currently unprocessed rows in the queue, rather than picking them off one by one?

Do you execute one or more procs for every row hitting the queue?

It might be helpful if you would elaborate on the 'performance issues'. Are we talking CPU, disk access, locking/concurrency, parallelism ...?

What makes you think that the cursor is causing the...

The query you have provided contains both a subquery and a ranking function, so I don't understand what you are asking for.

Alternatives are described by Adi Cohn. An SSIS solution sounds plausible.

• This reply was modified 4 years, 6 months ago by Phil Parkin. Reason: Fix typo

There is no easy way. As far as I know, it is not possible to select which objects should be restored from a SQL backup.

You can, of course, restore the...

Oh I want some of that. When 64 bits just isn't quite enough!

Are they both in YYYYMMDD format?

There is no such thing as an 'Execute SQL Script Task component'. I think you mean an ExecuteSQL task, is that correct?

Why not something like this?

IIF(LEN(Col1) <2, Col1, LEFT(Col1, LEN(Col1) - 2))

where t.col5 is not null

Hah! I thought of this too, but assumed that the values in Col3 and Col4 for the NULL date were required to be included somewhere in...

• This reply was modified 4 years, 6 months ago by Phil Parkin.