@Jeffrey,

You are absolutely spot on with not relevant to max.days. Max.days is actually courtesy from DesNorton

https://www.sqlservercentral.com/forums/topic/question-on-last-valid-date-in-the-system

In this system I have used that function for multiple dates and as...

• This reply was modified 2 years, 6 months ago by  protocoder.

Hello @Johan

Sir, I remember your advice  you gave earlier. I am just another BA with no create access too.  This is the existing data I am migrating.

But thank you to...

Hey Sorry,

I got this sorted Thank you.

CASE

WHEN

WHEN d.CancelDate ='1900-01-01 00:00:00.000' AND d.ClosingDate = '1900-01-01 00:00:00.000' THEN '' --'NO Valid Closing Date'

ELSE DATEDIFF(day, d.ClosingDate, d.CancelDate)+1

END AS DateDiff

and it worked.

@ktflash

Thank you,  Yes earlier i had a filter earlier that eliminated nulls but i have so many conditions to prepare in one report, i have to Where filter...

@scottpletcher Thank you very much. This was boolean, I should have thought over it. Thanks a lot

Hello @Phill Parkin Thank you.

@KenMckelvey thank you. I was resolving it with random integer and your post have given given better response I am after.

@jeff Modem the Error is in the smaller...

Thank you @Phil Parkin @thom-2  you very much both of you. I have tested and able to get right avg for Data Type money and was able to...

@jeff Moden

Thanks a lot, I have almost finished and submitted. Firstly thank you for the NULLIF.. that is my learning.

2. Once I am done with this, I will...

Thank you @JohanBijnens, Great help, I will test this smart stuff.

@scottpletcher, wow for simple and great idea. I will remember this easy technique. To both of you thanks...

• This reply was modified 2 years, 7 months ago by  protocoder.

Hi @desnorton,

That is very smart stuff.

Thank you very much, I will try this.

I was using datediff (day,date1, date2) for each consecutive dates and prior to it, I was...

@sergiy and @thom-2 A

Thank you both very much.

I thought I typed my thanks to @sergiy, I tried to re-use the existing code with changes...

@pietlinden Thank you very much. I will work on this. Is my thought process correct that I understand the ERD before working on these database-related questions on joins,...

No I don't see them for the sample database I have restored or the built-in INFORMATION SCHEMA