As far as I know there is no way to do that nicely inside SQL.

If doing it inside SQL is a requirement, you could modify the code you are running...

Easiest way - change the division to handle when 0 may be the result.  How you handle that is up to you, but my approach would be to set it...

It includes them becuase the Prod Line is different.

Your original requirement (original post) says:

" I only want to include ME# where there are 2 different Prod Lines associated with single ME"

So...

I must be misunderstanding.  When I run the example you gave above, I get the expected output you gave above minus the Total and Grand Total values.

When I run the...

Can you provide some sample data where this happens?

Giving the text explanation  that you did, I am not able to reproduce the problem.

If I had to guess, I would say...

My understanding of the error - the particular database file has no room to shrink.  If there is 0 bytes free in that database file (or near 0), then it...

I agree with Scott and I have a question for you Ram too - how often do these jobs run?

This is relevant because if you run the jobs nightly (for...

I am pretty sure you cannot do this with UNION.  UNION is for combining 2 data sets, not for filtering or reducing a data set.  Using your query, you would...

I could be mistaken, but a value of ".247888" is going to be interpreted as a string as it doesn't start with a numeric value.  What I mean is in...

As a thought (probably not the most efficient resolution), but toss the above query into a CTE (or nested select) and add a WHERE clause onto the final select where...

Your query will give you the channel, MEID and the sum of the charges, which is half the battle.  But I would take the approach I suggested with windowing functions...

That was a code formatting error...  I have corrected the code.

Looking at the code and just spitballing an idea, if you order the data by Name first and by ID second, you can use lead to see if the length...

• This reply was modified 4 years, 7 months ago by Mr. Brian Gale. Reason: added some code
• This reply was modified 4 years, 7 months ago by Mr. Brian Gale.

First question - what have you tried?

To me, unless I am misunderstanding it, this sounds pretty easy using windowing functions to handle the first 1/2 and then the total becomes...

This is actually pretty easy to do based on what you put there.  Step 1, set Saturday as your start date by running:

SET DATEFIRST 6

Next, you are...