The xp_dirtree function was only added in SQL2005 so it’s not likely to disappear and will probably be around for quite a while.

Hi All

I was also a little concerned about turning on cmdshell so I have made the following changes to the original script which shows backup file data but does not...

Hi Ritesh

I forgot to say in my pervious post, thanks for this script. It was exactly what I was looking for and saved me quite a bit of work.

Many thanks!!!!

Nick.

Hi Mike D

run drop table #jobs_status

The re run the procedure. That should sort out your issue.

There is a solution to the "An INSERT EXEC statement cannot be nested" problem in a previous post. Just read up a few posts.

Hi All

I had a quick look into the "An INSERT EXEC statement cannot be nested" error.

Yes this error does not stop the report from running but if you schedule a...

Any ideas anyone?

Hi All

Thanks again for all the replies.

I'm going to try both solutions mentioned above.

rbarryyoung: The upper bounds for Total_Cases is not know but I am going to limit it to...

Hi All

Many thanks for all the replies.

The table I'm after should look like the following with the data provided:

No of...

Hi

thanks for the reply.

below is a sample of data from the tables.

Orders table.

Order_Number, Total_Cases

1,4

2,6

3,3

4,2

5,5

OrderLines table.

Order_Number, Line_No, No_Of_Cases

1,1,1

1,2,2

1,3,1

2,1,3

2,2,3

3,1,1

3,2,1

3,3,1

4,1,1

4,2,1

5,1,2

5,2,3

I hope this helps.

Many thanks.

Nick.

Many thanks for the reply’s.

MentalWhiteNoise and Peso:

I have used both these methods to get the data that I require.

What I was after in this post was to try and work...

Hi

Thanks for the reply.

The Formula is supposed to produce a date and time of how long the job took to run using the run_date, run_time and duration fields.

So anyone have any thoughts on the above post?

Hi Greg

Many thanks for the reply.

I've managed to find the GUI option to delete DTS package versions.

The "Delete" option on right clicking the DTS package takes you into the place...

Hi Ed

Many thanks for the quick reply.

I'll try your solution.

Once again many thanks!!!

Nick.