Jesper (3/7/2006)

I assume you mean an initial value of 100 Try this:

declare @a table(ID varchar(10))

declare @b-2 table(PID varchar(10), ID varchar(10))

insert @a select...

Hi,

Thanks to both of you for the information, it has given me a better idea of how I can achieve what I am trying to do.

Regards

David

Hi Michael,

That's great, I am now able to skip the task!

Thanks

David

Hi Michael,

I thought I was roughly doing what you suggested in your earlier post. If my task fails the Failure precedence constraint skips the next task and is attached to...

Hi,

I've tried a variation on Michael's suggestion by using a Script Task and a variable. The code for the script task is:

Dim blnResetData As Boolean = System.Convert.ToBoolean(Dts.Variables("blnReset").Value)

...

Hi,

Did you control the constraints using a similar method to the one suggested by Michael in the earlier post?

Hi Andras,

I have an ASP.NET form that when submitted will execute a stored procedure which in turn creates a job. The job deletes and populates data from the database but...

That sounds like the way forward! I'll give this a go and let you know if there are any problems.

Thanks

Hi Andras,

The jobs are all other data related; I am distinguishing them from all other jobs by giving them a specific job category type. I did have a very, very...

Hi,

I managed to get the single column by creating a temp table and inserting all current jobs into the table. I then simply queried over the temp table:

INSERT INTO #xp_results

EXEC...

Hi Colin/Markus,

Thanks for your replies. I'm not really sure what to do because I have a partition of about 40Gb that is supposed to hold the backup file plus TLog...

Hi CJ,

Dynamic SQL sorted the problem. In case you haven't had a chance to look yet the basics are as follows:

1. Create a variable to hold the statement (I used...

Jeff, thanks for the advice

I've set all backups for a single user db to backup to a device i.e. log/diff and full all go to the same device. My idea was that when the...

Hi Crispin,

I get it now! Thanks for your help, much appreciated.

David