I'll take any ideas you aren't motivated enough to use!

A couple of things:

1. Autoupdate stats should probably be on, especially since you do not mentioning manually updating stats. If you have a highly transactional system then out...

For all those who have posted that they don't write due to fear of being wrong. The one article I have written did not have anything "wrong", but after...

I have to be honest, I don't really like to write. I have submitted and had 1 article published here on SSC and have a blog, but I really...

All right. Does it matter which one of the records with duplicate ModifiedUTC, you keep? Here's an idea:

[font="Courier New"];WITH cteDuplicateValidRecords AS -- get all the records with more...

You could use top 1 or you could try something like this:

[font="Courier New"]SELECT DISTINCT  

     RT.IndexId,

     ISNULL(dbo.ufn_GetBestIdentifier(RT.IndexId),

     dbo.ufn_GetBestVirtualIdentifier(RT.IndexId)),

     dbo.ufn_GetEntitySystemName(RT.IndexId),

     RT.Status,

     CONVERT(VARCHAR, RT.DateCreated, 106) AS DateCreated,

     RT.CreatedBy,      

     RT.DataTag,

     MH.MergedDate

FROM  

   @resulttable AS...

You need to change the function in the data row of the matrix to AVG() from SUM() if you want the subtotals/totals to be Avg()

I basically agree with Grant. Select -> From->Where->Order By are real easy to understand and comprehend. The key is that good database design requires that you understand joins...

Check the owner of the job.

I don't think you can set it up so they can just see the security section, but you can put them in the fixed server role of securityadmin id you...

As far as I am concerned there is no reason for anyone to be a member of the db_owner role in a production database. The DBA should create roles...

Your where clause looks fine to me now, except that if p21_invoice_amt_remaining_view.amt_remaining_frominv is numeric you do not need the quotes .

When you say it did not like it, did you...

Because your query is within a string you need to use 2 single-quotes in order to have one show in your string. So you need something like this:

@query =...

G's explanation is right on. I have used Float in the past, but it does not give precision and you had specifically mentioned Decimal(3,2) in your original post which...

What error are you getting? It could be the blank values are causing the issue. Convert blanks to null before converting to currency.