As it happens, a  lookup table is precisely what I am creating.

The descriptions are supposed to be unique. If the originating organisation puts in duplicates because they cannot decide on...

Ha, I thought that the answer might involve window functions. I have seen them used but hardly used them myself.

After posting this question I came across Kathi Kellenberger's article

Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the lifetimes of...

Hi Smit

There seems to be a problem with the website page for your article a couple of lines down from the "Using Python's re Module" heading (I am using the...

Heartily agree with the sentiments you express, Louis.

A big issue with New Year's resolutions is often that they tend to be too grandiose/too vague/not SMART.

I'm not making any NYRs this...

Yes, great article and great comments, and a neat quote from Jeff. When recognition and praise is given where it is due, everyone benefits.

And getting upset when others do well is...

Thanks Ken, fixed.

MarkD

Queen Elizabeth II was a big part of the "Great" in Great Britain. Often and often she reminded us of what we aspired to be, and what we ought to...

There's actually no need for messy calculations with pi and so on. Think of it this way:

If we assume that the pizzas (5" and 9") have the same thickness, the...

Ha, yes, great idea. As an antipodean myself, I can definitely...

"My word is my bond". Great motto, that. No goalpost-shifting allowed.

MarkD

Hello sipi41

Sorry you have had to wait for your question to be bumped, and hopefully you are still interested in getting an answer!

Bulk insert goes like a rocket, if you...

Ha, sorted it.

The critical setting was Tools > Options > SQL Server Object Explorer > Scripting > Check for object existence. The option was set to True.

When I reverted it...

Nice summary, Ginger, and good analogy about the grocery bag. Helps to bring home the point that shrinking the log file might be a really bad idea.

Personally, I think the...

• This reply was modified 2 years, 9 months ago by  Mark Dalley.
• This reply was modified 2 years, 9 months ago by  Mark Dalley. Reason: Improve layout

Thanks Michael, fair enough.

I'm going to put the extra fields in to start with, but I may rip them out if testing indicates it. At this early stage I can't...