Viewing 15 posts - 31 through 45 (of 136 total)
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.
February 24, 2015 at 2:25 pm
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.
February 19, 2015 at 1:33 pm
Why don't you post the query and let us see it too?
February 12, 2015 at 2:15 pm
patrickmcginnis59 10839 (1/28/2015)
Wald applied his statistical skills in World War II to the problem of bomber losses to enemy fire. A...
January 29, 2015 at 9:59 am
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...
January 16, 2015 at 10:52 am
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...
January 14, 2015 at 9:56 am
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...
January 13, 2015 at 4:05 pm
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. ...
January 13, 2015 at 2:37 pm
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...
January 12, 2015 at 12:05 pm
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'...
January 12, 2015 at 11:33 am
Was there a question in there? I don't really get what you're asking for. (?)
January 12, 2015 at 11:11 am
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...
January 6, 2015 at 6:38 am
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. ...
December 31, 2014 at 10:42 am
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...
December 31, 2014 at 9:53 am
Viewing 15 posts - 31 through 45 (of 136 total)