Unfortunately I have no control over the text file format.

I'll ask him to have a look at his regional settings, but I'd expect them to be EN UK -...

Hi Howard,

Im using dd-mmm-yyyy. I've also tried set dateformat dmy without any joy.

Thanks, Iain

You need to aggregate the data down before running the update. Given that your case statements are additive, then if you always have positive values in t2 you can use...

How about a cross join?

Using Bitbucket's test tables above:

select bs.Id, bs.Something, ss.SFOR

from #BeingSearched bs

cross join #SString ss

where charindex(ss.SFOR, bs.Something) <> 0

Note this returns multiple hits per searched row due...

Could this be the first ever 'we recommend a cursor' post on SSC?

Think I might print this page and frame it 🙂

Exactly 😀

Thankfully it's also a one off job, with a fixed data volume. The brief explicitly states "Performance is not an issue".

Until someone decides it isn't fast enough that...

Hi Jeff,

Interesting point, not something that had even entered my mind. Definitely interested in seeing how I can root these out.

I've taken a look at your article on triangular joins,...

Hey all,

Sorry to post in an old topic, but I figured out a solution that works for my situation and thought I'd share.

First, a bit of background:

I'm allocating 'payments' to...

Hi,

Sorry for the slow reply - been beavering away.

Just a short note to say that J-F's method of embedding the case statment within the cte definition worked a treat. Thanks,...

Hi ajitgadge,

Batch sizing is another of my vexing questions at the minute. Is there a way other than trial and error to decide the optimum batch size?

Thanks, Iain

Thanks Ed, am underway with a planning memo, detailing all of the assumptions, limitations and issues I can come up with.

Have been burnt before on that one... 🙂

I've also...

Hi Ed,

Interesting. I'm in situation b.

I'd thought about CLR as a possible solution, but being honest, my VB/C# isn't up to the job. So, I'm prepared to take a...

Hi Flo, thanks for the reply.

I initially thought about a simple while loop structure as you've suggested but think that using the SQL Agent gives me a couple of advantages:

I...