I just tried that and it errored if I did not put a value in for the datatype that is an INT. If % is the wildacrd for text, what...

Ahh, Thanks for that. I will put that in my code.

Another day another snippit of useful information

Thank  You

Currently my WHERE statements look like this;

FROM         src_terrier INNER JOIN

                      src_centre_list ON src_terrier.siteref = src_centre_list.Site_Ref AND src_terrier.Areacode = src_centre_list.Division INNER JOIN

                      src_div_mgr ON src_centre_list.Division = src_div_mgr.division INNER JOIN

                     ...

OK, I will look at that to begin with. I think it was outer join because I wanted all data from terrier and only budget data where it existed in the...

Hi Jeff

Please find the code as requested

ALTER

FUNCTION [dbo].[fnWTRalldata]

(

@dt_src_date

datetime,

@chr_div

char

Not sure what is going on here but it is now returning src_rental info for dates that do not exist within it

The data in the src_terrier table now contains data...

Are OK, yeah that makes sense. Thank you for that peice of information

Regards

Hi Pam/Jeff

I have used Pam's suggested code in my function now and I think it works. Certainly data is being returned. However what I do not understand is how it works....

Thank you for that.

Regards

Fantastic, thank you for your detailed post. I shall apply that with immediate effect and see how I go.

Your effort is much appreciated.

Regards

i shall inwardly digest your post and see what I can come up with. Thank you for taking the time for me

Regards

OK, I hear what you are saying, but if I were to use the checksum across say three or four columns then would that not reduce the likely hood? Bearing...

They are stored as DateTime in both tables

Regards

Admin, please delete, posted in wrong section

Apologies and Regards

Tonic

Admin, please delete this post, I put it in the wrong section

Apologies and Regards