I'm pretty sure a solution is possible, but you have to give us table definitions. You can make up the sample data but it needs to have all fields.

Also, are...

kmdavisjr (3/14/2014)

---

Yes, it is bad. I am pulling the data from MySQL database. I do have a submission ID so I can tell who's who, but the...

Ok, that is really bad. Do you get only one person's record...

PiMané (3/10/2014)

---

Hi,

The LIKE operator is also very slow with 3.000.000 records... It's even slower than the LEFT in the tests I made.

Right now I'm trying to do an INNER JOIN...

That wasn't what I was suggesting.

What were you going to put in the calculated Parent ID column for Sean's solution? Surely you weren't going to refer to other...

If that is a problem, you could do a indexed view on accounts with the calculation for...

What is the maximum account number length, practically speaking. Its a varchar(10), do you get account numbers that long?

edit: nm

The debug setting for 64 bit is only for when you are running in debug mode (in visual studio) afaik.

Do you have the 32 bit tools installed on the...

I think this conversation might best start with WHY you want to do this.

Updating all records but locked ones is a weird requirement. You'll have to update the locked...

Are you looking for a solution to this specific problem, or are you looking specifically to use recursion? And do you need all the output words in a table,...

So ... was this a job interview question, or was it a test?

Koen Verbeeck (3/5/2014)

---

Interesting question, but I do not agree entirely with the answer.

Setting the commit size to a lower value will commit batches before the entire load is done. What...

Sanjeev Jha-475652 (2/28/2014)

---

Hello,

I have the following code and the result set is coming out as nvarchar. So, when I create a report in SSRS, it is not formatting as a...

Ironically, I was about to create a package to do just this, and was thinking I'd need a script task to find all the csv's in a directory, and then...