Is your differential backup appending to the same backup file, or is it overwriting, or is it creating a new file each time it is run?

Gag/Choke/Chuckle

Puddin' Cup

Thanks for the question

then try a different precision/scale for the decimal or try using float in the cast operations.

sorry take off the "as CountofLeads"

Try this

DECLARE @CampaignId int

,@LeadsinCampaignInt

SET @CampaignId=95

SELECT @LeadsinCampaign = COUNT(dbo.Leads.LeadID) AS CountOfLeads

FROM dbo.Leads INNER...

Sector/Allocation Unit size?

Year of the Pig no more - it shall always be the...

Thomas Abraham (10/14/2011)

I had forgotten about this question. So,...

Secondary my dear Holmes.

Omega, but since Rassilon is viewed as the founder, I guess I'd have to say I lived through the Rassilon monarchy as well.

Dude63 (10/13/2011)

SQLRNNR (10/13/2011)

Brandie Tarvin (10/13/2011)

Dude63 (10/13/2011)

Brandie Tarvin (10/13/2011)

Revenant (10/13/2011)

crookj (10/13/2011)

Dude63 (10/13/2011)

Was off yesterday so I'm a...

with steely resolve

Brandie Tarvin (10/13/2011)

Dude63 (10/13/2011)

Brandie Tarvin (10/13/2011)

Revenant (10/13/2011)

crookj (10/13/2011)

Dude63 (10/13/2011)

Was off yesterday so I'm a day behind...