Or use Michael's TRY-CATCH technique but write a row to a log file instead of sending an email. I know some DBAs frown on using the email function.

Is sales.Dis ever NULL?

What about dynamic SQL? Something like this where you build the statement, changing the @computername variable each time.

Lowell beat me into print

That might work for you.

Why don't you post the query and let us see it too?

patrickmcginnis59 10839 (1/28/2015)

---

One of my favorite stories about decisions based on data!

Wald applied his statistical skills in World War II to the problem of bomber losses to enemy fire. A...

I was in one of my first programming jobs and we had one of those 'company retreats' that can sometimes waste a day and provide nothing new. For a...

@Celko,

Did you have something constructive to say that would help the OP? Or do you just like to put other people down to show off how much you know?...

You're going to have to do it in stages, build some temp tables, and start plowing through it. As you get individual rows sorted, place them into a holding...

First of all, good luck. You have some really filthy data to deal with.

Read up on PATINDEX. It may give you some ideas about parsing these strings. ...

I'm not sure how I would do this without using a CTE or a query.

One question I have is why you need to create the strings since the rootid values...

Right, but you want an output column of 'value' that isn't in your input table, just 'rootid.' Are you looking for a way to generate that field 'value'...

Was there a question in there? I don't really get what you're asking for. (?)

I've had good situations and bad ones. To me, the difference usually comes down to the level of respect flowing from the top down. Where management has shown...

Sorry, was reading too fast! But I've learned a little more about SQL Server so I'm repaid for looking stupid. 😛

PARSEONLY sounds like it ought to work. ...

Up on the toolbar there is a button with a checkmark on it, three buttons to the right of the !Execute button. Click that and it will parse...