Gut feel is that this is a case of parameter sniffing, and if the user can enter anywhere between 1-10 parameters its most likely that the engine isnt chosing an...

Like Dwain enjoying the discussion, so following it with interest.

In regards to the ACID I frequently get asked what it means in interviews and I always go blank on what...

Its a good solution by BriPan,

although you can get away without doing the lookup of the max ItemCategoryId, as long as you can be sure that the Identity column...

To My knowledge the only way to do it is using xp_sendmail, the only other way would be to run an xp_cmdshell to call an external SMTP program, or write...

You might want to check the retention period (Retention Period Units) to and see what its set to, se this as a guide http://msdn.microsoft.com/en-us/library/bb895205.aspx

Definately looks like a job for a recursive CTE in order to build the Path then a simple update after, this is a simple test rig for a select, but...

This looks like you're trying to build a hierachy list using a while loop.

Can you provide some sample data for #HirNodes, as I think you're using a sledgehammer to crack...

You could set the MaxErrorCount property on the For...Each Loop to be a large number, this would then carry on until it reached error limit.

Though you also probably want to...

Using the Floor/Ceiling with an accounting fudge (*100)/100.00 get it to work.

(

Policy char(1)

,Claim Int

,Job Char(1)

,Excess Decimal (19,2)

)

INSERT into #PolClaim

Values ('A',1,'E',50.00)

,('A',1,'F',50.00)

,('A',2,'X',50.00)

,('A',2,'Y',50.00)

,('A',2,'Z',50.00)

;

With PolicyClaimLines

AS

(

Select Policy,Claim,count(*) LineCount

From #PolClaim

Group by Policy,Claim

)

Select

Pol.Policy

,Pol.Claim

,Job

,Excess

,Excess/LineCount

,Row_Number() OVER (Partition...

ChrisM@Work (10/31/2012)

---

There’s your problem. You’re only updating a maximum of a few tens of thousands of rows in the target table, but the source – now rejigged as a SELECT...

Its practiacally the same as doing : Select...

True, UK postal codes are a nightmare to handle, thats why most people will try and push it up into the UI layer and rely on specialised Reg-ex validation procedure...

Mark Dalley (10/31/2012)

---

I can't get hold of our IT people at the minute so will cap the size of the tempdb log at 10 GB and re-run. Don't expect it...

GilaMonster (10/31/2012)

---

As long as whatever that is is intended for US only, now and always. I...

same here I'm using SSMS Tools in 2008 and SSMSBoost on the SSMS 2012 both allow...