If I use just this ASV.[1st_NA] in the query then from the results in the example attachement you can see that it doesnt show same results as when we use...

I've been looking over the (CTE) Common Table Expressions sites on google. I understand some of it, but struggling to see stuff about using it within CASE Statements...

Anyway I have...

From looking at the CASE my main problem I dont understand is how I can use a field that I have built using a previous CASE Statement in my new...

No worries, I'll have a go myself and comeback to you when I get stuck

Thanks.

Ok brilliant, now I have created the Appointment picture 😀

Thanks for the help in doing that!!

This below is now the query I have, I now need to understand how I...

If your date is not null, but is actually an empty string - the empty string is evaluated as a 0 which is 19000101. Not sure that is the problem...

I've been looking at this and when I run the query looking at the NA1's I get 19000101 as a result when the NA dates are actually less than the...

Sorry its complex 🙂

Well then, the question becomes:

If NA1 date is less than booking date - what do you want for Appt1?

If NA1 date is greater than booking date -...

Yes the NA dates could be...

am sorry, but I am not following the logic here. What happens if your NA column is not the same as appt1? What if the booking_date is less than...

I am looking at another database now and trying to put together something similar to what was done earlier in this thread, the only problem is that this database is...

Thanks for this 😀

Sorry for the delay in reply, only just had chance to look at this.

I'm going to read and understand what it does now.

Thanks again 😀

I have tried the CASE Statment and this is what I come up with for part of it, but have an error I cant get around....

Error :

Msg 156, Level...

Thanks for that, I'll give it a go 🙂