DATEDIFF(mm,0,[Date]) calculates the number of month boundaries crossed (in effect, returns a count of months) since day "0", which is the 1st of January, 1900.  That means that each date...

Fill factor only comes into play when the index is NEW or REBUILT.  Basically, it is just telling SQL that the data is either changing frequently or the inserts...

Heh... Most people have a rule of "Normalize 'til it hurts then denomalize 'til it works".  I disagree with that.  My rule of thumb is "Normalize 'til it hurts... then...

Thanks for the feedback and you're welcome.  The key now is, since you're the one that has to support the code, do you understand how it works?  Especially the DATEDIFF/DATEADD...

I think either are acceptable, but I think one will have better performance.  I am pretty sure "NOT NULL" is not sargable so you may have a performance hit...

Generally, I try to avoid all "IsPresent", "IsCurrent", "IsActive", and, for sure "IsInactive" and "IsNotCurrent" columns, etc, etc.  The data tells it all.

Try this...

 SELECT  Name
        ,country
        ,avg_amount = AVG(amount)
    ...

Since your result set that shows what you want to display doesn't contain results that match with your sample data in the 3rd column, what are you looking for in...

Nothing like stating the obvious, Joe.

My solution was

select AllergyName,
MAX(CASE WHEN ScaleValue = 'Low' THEN ScaleStart else 0 end) AS [LowStart],
MAX(CASE WHEN ScaleValue = 'Low' THEN ScaleEnd else 0 end) AS [LowEnd],
MAX(CASE...

Lordy... there's a "bot" running with the handle of "Stanley" and it's posting spam every 5 minutes.  Between that and another bot that was active only for a while, I'll...

I played around with the query a little and added percentage columns.

The math works, but it seems to default to six decimal places.  100% - 100.000000. Is there a...

Mine is similar but I took advantage of IIF.  It still renders out as CASE expressions behind the scenes so no performance gain or anything like that.  I also think...

Your suggestion worked.  Thanks.  I am just getting the hang of this but will post the working formula even though there is probably a better way to do this.

CONVERT(DECIMAL...

Thank you both so much! I was trying to be cute and figure out how to use the PIVOT operation, but going back to the basics and using the...