I thought that it was only Binary data.  It has been a while since I had to work with it and without going back and finding the code I wrote...

I am curious why in some cases an adjacent date range is merged but in others they aren't.  What I mean is the enddate for one range is the day...

And if I remember correctly, you may have to uninstall and reinstall to get to standard edition.

Okay, which is it a table with 500 rows of data that you want to delete 300 to 400 rows of data or a table with 300 rows of data...

Data dictionary?  Is this the...

Do you have SQL Browser running and port 1434 open?

Edit: Sorry, should have gone down further, would have seen Sue already said this.

You should look at using a stored procedure instead of a function as you are going to need to use dynamic SQL to accomplish this task.  You can't use dynamic...

Of course you could also do this (will need some changes if you have null columns, but those could be excluded in the query):

CREATE TABLE MyTable...

My fault, read things backwards when I was writing the code.