Amit,

Nice function - I think one small change could also speed it up - since weeks are a predictable format, when you encounter a Monday skip ahead the next 6...

Mathew,

Most of the accounts deal with a particular currency type - but there are a few that do not - for those that do, we want to be sure...

Thanks Happy - I appreciate the confirmation......

Here's a script I wrote to standardize the names of the PKs - you can probably modify it to pull any other info you want from the system table

select 'EXECUTE...

Jeff,

Nicely done - thanks for putting in the time to make the UDF more versatile!

Regards,

Harley

Here's a udf I put together that takes a date input and returns a selected date - since our system only uses dates in the mmddyyy or yyyymmdd format, it...

First, I would just like to say thanks to all the great people who donate their time to answering questions - your help is invaluable.

Jeff,

Clever solution to the first...