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, 3 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...

Jeff, thanks for taking the time for that educated explanation.  I learned a lot from it.  I had to look up "corpuscles", for a moment I thought it was...

Sorry, duplicated post.

Sorry, duplicated post.

Thank you for the feedback, Phil.  I figured I'd make it "production" worthy because this isn't the first time we've seen this request.

Just a caution...

The WEEK (ww) datepart is ALWAYS based on Sunday for DATEDIFF.  MS did that to ensure that the DATEDIFF(wk) functionality will be "Deterministic" so that it can be...

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...

Hi

We have an stored procedure which runs frequently and  it contain logic in which data are first dumped in temproray table and then moved to physical table .due to...