Are we assuming that the date ranges in table B are non overlapping? if that is the case then soln above suffices, otherwise you will need another condition.

Update

i would strongly recommend replication, looking at your requirement you don't want to mess about with them triggers

try like '*java*'

the only other way is to do the sorting in your application otherwise there is no other way to do it than by [if...else]or [select case]

you could try the m$ website

http://msdn2.microsoft.com/en-us/library/ms131035.aspx

but it might help if you post your vb6 code,

i think the purpose for the clr is to blur the divide between the database and the application program.

if you want to use the return status programatically you might have to use the above suggested solutions, but if you want to see it when you run the stored...

Please do write a tutorial about it, and submit to Steve if possible to include on the website

did u manage to get anyone to chat with you? which client do you want to use, i will see if i can help

http://www.sqlservercentral.com/forums/messages.aspx?forumid=150

Why not just get the 2005 Enterprise edition for a better developer experience and everything else that come with it.

But probably the best advice for your question will come from...

I have never seen this option but if its there its is probably in the Enterprise Edition.

For interests sake how is it done on Sybase

can the user login using enterprise manager or the QA?

so.. do you still need any help. i was about to look into this

CHAR seems to exist in .net