Don't understand the question, mainly because you haven't given us any information!

I've done some test data, but obviously didn't know what you're using. . .

DECLARE @ClientXAttributeText AS TABLE(

clientid...

Try a TRANSACTION

I generally write a VBScript that takes in variables from user input, then generates batch scripts that execute the SQL required.

You could always declare a variable, then change it at "fail" to whatever task had failed.

[/URL]

Uploaded with ImageShack.us

I figured you could,...

nfs_john (6/9/2010)

---

Hopefully I am explaining this in the correct way. What I am expecting is for my CTE to recurse through all three tables returning hierarchical data that I can...

Please write out your expected outcome, it's difficult to help from what you've displayed.

Glad I could help :w00t:

No problem. The reason it was returning blanks before is because the NULL was passed in, then the function was running: -

SELECT @Reset =...

How about just doing this: -

USE [TestingDB]

GO

IF EXISTS (SELECT *

FROM sys.objects

...

This should do what you want: -

DECLARE @old_string VARCHAR(35)

DECLARE @count INT

DECLARE @new_string VARCHAR(35)

SET @count=1

SET @old_string = 'test'

WHILE ( @count <= 35 )

BEGIN

IF...

Jeff Moden (6/8/2010)

---

skcadavre (6/8/2010)

---

Anyone understand what is being asked here? I've spent as long as I want to trying to figure out what he actually wants. We now have...

Please don't message me about specific problems, I get a notification for threads...

Anyone understand what is being asked here? I've spent as long as I want to trying to figure out what he actually wants. We now have sample data and...

OK, first I've fixed the data insert...