That worked, thanks

Jennifer, any luck, I am having a similar problem. When I initialize to another Database in the same SQL Server instance, it's very fast. But I have an...

SOLVED - apparently my existing uniqueidentifier field did NOT already have newid() set as the default value. I set that and recreated the Publication, and all is good now.

Thanks Ray, I was looking to avoid a cursor, works great.

Thanks Sergiy, this works and is a different and more efficient approach than I had been thinking of.

Imagine buying a seat on an airplane for travel on 6/1/2007.  If you purchase your seat between 1/1/2006 and 6/30/2006 the price is $100, and if you purchase between 7/1/2006...

The idea is that a user would be using a data admin program.  There could be several different scenarios I would need to handle, depending on the changes the user...

Thanks John, worked perfectly!

Now I get it, thanks Ken, works great!

My point is do I have to manually type in these statements or can I write some code that will do it?  If I have to manually type them in...

Thanks for the suggestions.  You are right, the pattern is the changing price.  Ken, if I have a year, or 2 years worth of pricing records, I'm not sure I...

Thanks for the replies from you both.  John, port 1433 is open so that was not the problem ( though it was part of it a few days ago before...