Hi Jeff,

It's not that the rules can't be programmatically described, it's more that the programming would be more in keeping with a separate module written and maintained by specialists. If...

Hmm,

I can see my question was not as clear as it could have been. The example given was just that, an example. I was more interested in which of...

Never Mind,

I found a workaround. It would still be good to hear if anyone has a more graceful solution, but this one works.

If(@brd = 'One')

Begin

Declare DetailCursor Cursor For (Select One...

You could always put this in your Stored Procedure, once you are sure that you have Day, Month, Year format dates

SET DATEFORMAT DMY

As a Uk Sql User, I fall foul...

Hi,

I have had a chance to try this out and see what it is doing. It does much the same as my current VbScript, insofar as it checks for the...

Thankyou William,

I will try to understand what what you have written and test it. I am not sure about the "Simply" though, it looks quite complex to me.

I am currently...