I will DEFINITELY be back in the future as I feebly attempt to get more proficient at T-SQL and end up putting the vibration sensors mettle to the test! 😉

Kevin

Thanks Dwain that worked great. Now on to the next thing to bang my head against the wall for! 😀

Kevin

Thanks much dwain, I'll give that a try! I agree with proper formatting and try to do the same. Right now I just need to get it working properly (deadline...

Well, that's a good question. I'm still relatively new to sql server and all it's nuances, especially dynamic stuff. So I'm not sure how to make this work using 2...

Dwain,

Thanks much for the response! I actually solved it by cheating a little in a select statement:

select *

from callflow_data.tmp_available_contacts

where ${tmp_dow} = 'true' ;tmp_dow contains the current DOW, 3 chars, named...