Just call it "P-cubed" or "P3" for "Proper Programming Practices" instead of all this Dev-this and Ops-that stuff.

Heh... I was having too much fun with this post and thought that someone might take it too negatively, and so I deleted it.

You should post your solution so that we can check it for you... a lot of people make a pretty bad error for things like this.

I'll also add that what looks to be the "3rd INSERT" is the only one that has non-sargable criteria in the Joins ...

    ...

You...

• This reply was modified 2 years, 11 months ago by Jeff Moden. Reason: Changed my mind

Based on your example this query uses the 'id' column to define the sort ordering of the running total.  Generally it's not a good practice to order by an...

It isn't the ASCII function that's causing your error:

Try these statements:

SELECT ASCII('.');
SELECT ASCII(NULL);
SELECT ASCII(42);

All of them return a valid value.

But these all cause the same error...

Surely, someone has already done this (although I've not actually looked for such a thing).  Wouldn't it be easier to find something that already works and buy it?

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries...

Thanks for the Response!

I will implement your suggestions.

https://www.mssqltips.com/sqlservertip/5279/sql-server-error-query-processor-ran-out-of-internal-resources-and-could-not-produce-a-query-plan/

after Upgradation we got above error (PREV Post)  is below solutions will help us to resolve  error.

Please Guide me on this.

If you...

You appear to be missing "Product" for your sample data.

Ah, crud.  My apologies.  I didn't scroll down enough.  You have a few rows with data in the "Product" column.  I'm...

@alex (or anyone else that may be interested), since we're on the subject of "Week of the Month", here's some information and another function that might be of interest.

https://www.sqlservercentral.com/articles/how-to-find-the-start-and-end-dates-for-the-current-week-and-more

Note that...

Yes thanks Jeff Moden I love it when I can tune into a forum and actually learn something new. Your expertise and your willingness to give it to others...

SET DATEFIRST 6 ; -- Set first Day of Week to Saturday SELECT [CreateDateTime],DATEPART(WEEK,[CreateDateTime]) - DATEPART(WEEK,CAST(CAST(YEAR([CreateDateTime]) AS VARCHAR(4))+'-' + CAST(MONTH([CreateDateTime]) AS VARCHAR(2)) + '-01' AS DATETIME))+1 AS WeekNo FROM...

• This reply was modified 2 years, 11 months ago by Jeff Moden. Reason: Added an appropriate meme

I had to look up "corpuscles", for a moment I thought it was a new drink at starbucks.

Thank you all for taking the time and giving me your...