Hi ,

The below code was unable to take correct chars which is required for the calculation.

DROP TABLE IF EXISTS #DataTab;
DROP TABLE IF EXISTS #DataTabNew;

CREATE TABLE #DataTab
(
 ...

Please be informed that there will not be any raw data or any inclusion of data for weekno column it will be in same format W52-2021 , W1-2022 etc..

I guess...

Jeff,

The above is the i/p which i receive my client which may having missing weeks data, so i need to populate 0 for missing weeks.

Also, actually it has two requirements,...

How to get the missing weeks!

Emp | Week       |  Rnge
110 | W18-2022   |  110   ...

• This reply was modified 2 years, 5 months ago by  LearnSQL.

Hi Steve Collins, The below code again gives the "A TOP N or FETCH rowcount value may not be negative. " error, since the weekno column was not trimmed properly...

Thanks for your correct and suggestion!

With the following i was able to get data for non missing rows, here for Emp 111 there is a missing week for w3-2022 and...

Getting the below error.

Msg 127, Level 15, State 1, Line 62

A TOP N or FETCH rowcount value may not be negative.

Yes Phil you are correct it should be 22 . Also How to take from last year last week data to this year first week data.

DROP TABLE...

Thanks Phils!

But i really forgot to add an important point here what if the same emp for month 1 and month 3. Here 210 in M1 and M3.