James,

So you suggest having very hefty penalties for any data breach in order to solve the problem? Wouldn't that strongly encourage corporations experiencing such a breach to keep it secret,...

I believe that must be a Jeff Moden article, unless I'm...

Yeah, I've been thinking about it over the weekend, and had a flash monday evening in the shower that made me jump to my current version.

As of now, it works....

Garadin (10/16/2009)

---

I assumed there *were* reasons behind it, I was just noting that I didn't know what they were :hehe:. I tend to be a little frivolous in my...

First, Garadin, I'd like to thank you a lot for the effort you're putting in this problem. It looks like you went through a lot of trouble to make that...

The query is designed to be used by the front-end application to generate a data file. This part is the final portion, where I take the data I've compiled so...

Hi there,

An Identity column will indeed generate a new number, but by no means is it guaranteed to be unique. It is simply one higher than the last generated, and...

This is my own little system to make dynamic SQL more readable.

When you design the query, you put placeholders in the form of |@value| where some dynamic part will be...

Hi,

Here's a way I developed to create dynamic SQL while maintaining some level of readability in the code. My example will create a test table and populate it with test...

Hey there,

First a quick note : your example is actually 14 characters long. For 15 characters, it would be 'michael the gre'.

The idea is to look at the first space...

Glad I could help 🙂

Hi.

I'm not sure if I'm really answering your problem, but if you need a way to achieve the desired result, it's very simple to do so without any cursor. As...

Very good catch.

Hi Glenn,

I indeed expanded the data file without touching the log file. Since the particular query is using the "INSERT INTO ... SELECT" syntax, your solution looked very promising....

There are some things you might want to change on your last snippet, even before Jeff gives his code back.

First off, your temp table shouldn't have the key as varchar(50),...