Not only can you do it one single job, you can do it in one single job step, in the way I suggested above.

John

I didn't go anywhere. What is your question?

John

(1) This information is already stored in sysjobhistory in msdb.

(2) Use the COUNT agrregrate function.

If you need more detailed help than that, please specify your exact requirement, including table DDL,...

If the WHERE clause includes a condition on the outer table, as your example does, then yes, the outer join is turned into an inner join. Try making the...

Something like this?

EXEC DB1.dbo.MySP

EXEC DB2.dbo.MySP

EXEC DB3.dbo.MySP

EXEC DB4.dbo.MySP

EXEC DB5.dbo.MySP

EXEC DB6.dbo.MySP

EXEC DB7.dbo.MySP

EXEC DB8.dbo.MySP

EXEC DB9.dbo.MySP

EXEC DB10.dbo.MySP

EXEC DB11.dbo.MySP

EXEC DB12.dbo.MySP

EXEC DB13.dbo.MySP

EXEC DB14.dbo.MySP

EXEC...

Don't use a script task. It's more complicated and it means you have to edit the package every time you want to change the value of the variable. ...

It may be that your websweeper blocks certain keywords. I've had that happen to me before. Try attaching a .txt file instead.

Please make sure that your provide enough...

Table DDL, sample data in the form of INSERT statements, and expected results would have been helpful. In their absence, this is untested:

SELECT

AID

FROM

Table1 t1

LEFT JOIN

Table2 t2 IN t1.AID =...

How is the value of the Customer_ID variable assigned? If it isn't set by any logic within the package then it will use at runtime the value of the...

OK, I'm guessing here, since I can't work out why you group the MONEYREQUESTs where you do in your expected results, nor what the Comission and fee columns signify.

WITH Transactions...

Or use logarithms:

CREATE TABLE #john (ID int, Factor decimal(5,3))

INSERT INTO #john VALUES

(1,1.1),

(2,1.1),

(1,1.1),

(2,1.2)

SELECT * FROM #john

DECLARE @x decimal(5,3)

SET @x = 12

SELECT

ID

,EXP(SUM(LOG(Factor))) * @x AS Answer

FROM

#john

GROUP BY

ID

John

It's probably just a question of semantics. As I understand it, a high availability server can form part of a DR strategy. I don't think it matters whether...

If you want to copy the whole database, backup and restore is much cleaner. I'd only recommend snapshot replication if there are only certain tables that you want to...

We need a bit more information, please. Which database(s) will your DR strategy cover? I assume your Staging database is updated from the external sources and then your...

Inserts, etc are still logged in Simple mode. They're just removed more quickly. Have you tried switching to Full recovery mode and comparing the time taken?

John