Have a look at this, and take notice of what it says in the section towards the end. Your safest bet is to restart the instance.

John

Are you sure you want to make that a universal rule? Bear in mind that if you rename your database, or if you like your code so much you...

That's right, yes. You might want to test what happens if one command fails - does it abort the whole batch or does it move on to the next...

(1) Modify the code I posted so that it fits your environment

(2) Create a new job

(3) Copy and paste the code into the "Command" field

(4) Schedule the job to run...

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