Thank you both for your help, i do appreciate that. i have finally managed to crack it and all seems to be working now. In the end i was able...

Thank you for the response, but basically I just need it to run that code 3 times, each time it will look at the table, find the lastest year add...

Sorry which part....as i have tried that and i can't seem to get it to work

Yeah, thanks John i appreciate its hard to know exactly what i'm talking about, because in truth i don't know myself. I'm gonna try a couple of alternative suggestions i've...

Hi,

When i creat a ne table and insert sample dat into it it still returns all the values, but when i do a join to that table it limits them...

Well i've cracked the number of arguement issue, i was being so dumb.

UNFORTUNATELY, though the query now just returns everything and ignores the search parameters completely....what am i missing?, it...

Nope still beat....sorry i thoght i had included all the arguements required, it looks right to me what i've done 🙁

Sorry about this

Hi, firstly thank you very much for your help on this. But, i'm afraid not...now i get the following;

Msg 313, Level 16, State 3, Line 10

An insufficient number of arguments...

Thanks,

Yeha i ran the function first, refreshed the DB to be sure and added the closing parameter and still i get the same error ?

Thanks for this it seems there is a way. However, I can't seem to get it to work, i just get the following error message

Msg 4121, Level 16, State 1,...