I was working on this when you posted your solution and had also tried the ROW_NUMBER, RANK and DENSE_RANK, but it wasn't returning what I thought were the results you...

I'm running Win7 32-bit. The 32-bit part is not my choice. :crazy: I didn't see anything in the designer options at all to control this.

I just tried using the...

Thank you, Gail. I hadn't even considered side effects of what's done in the OPENROWSET. Yet another reason not to use it to get around the built-in limitations....

Thank you, Alan. I hadn't looked into that and it is good to know.

Truth be told, I would do it using SQL's regular expressions like Chris did. I've done...

I'd like to echo what Sean said about the view designer. It's pretty famous for creating SQL that's completely and totally inefficient. The performance of your applications will...

There are plenty of articles out there on getting started doing it .NET. Here's one: http://msdn.microsoft.com/en-us/magazine/cc163473.aspx.

Depending on how you write it, this approach can be very efficient.

After you get...

SQL Server does support regular expressions: http://msdn.microsoft.com/en-us/library/ms174214.aspx.

The syntax is pretty straightforward.

You could also do it in .NET, create an assembly in SQL Server that points to the .NET DLL and...

I apologize if I got on a soap box there. I've been burned by that in the past and don't want others to have to suffer the same misery...

Personally, I hate using OPENROWSET in production. Any time a username and password has to be hard coded means that you're screwed if you ever change the password. ...

In order to have any chance at helping you out here, I'm going to you to post the DDL, some DML to populate some data and your expected results. ...

To performance tune your procedure to update statistics, I would start by looking at your execution plan. This will tell you what's going on and where.

You can also run...

So what do you want the fields in #Temp to be from #Para? If you're looking for a simple update, just use UPDATE FROM and match on Type.

I've had databases in Suspect mode only a couple of times, but I've never gotten them usable again. I've had to restore from the most recent full backup and...

You know, I can say I've seen a lot worse. Yes, there are problems with it, but it isn't even close to the biggest offender I've seen. There...

We don't see a BEGIN TRANSACTION anywhere, so we can't tell where it is in the procedure.

When you begin a transaction, other sessions cannot query the table and retrieve those...