Sean,

Thank you so much for your help. It definitely headed me in the right direction. I did need to tweak it as implementing that way would break requirement...

You'll shoot your eye out...

Is there any way to dedupe this posting in the same way? 😀

Are there any additional "gotchas" to be mindful of if the server you need to downgrade is being replicated to? In the 10 step process above, it just talks...

That is good to know as well. That was a big factor limiting me on what I could do trying to work with a table with nothing other than...

The most I have seen at one time is a couple of hundred records so we should be OK. I will begin testing with it and getting approval from...

Lutz,

We are actually required to post data into some of their tables for processing. The problem I am now trying to resolve is that the person who...

There are also 3rd party tools you can look at for this. I have used both Red-Gate SQL Multi-Script as well as Idera Multi Query and am pleased with...

Here is the same code without the special characters.

--Create the tables

CREATE TABLE [dbo].[dim_Date](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Date]...

It is amazing the little simple things that you can't think of after a very long day. :doze:

They can only request the days that fall into a pay period which...

Andrew,

Thank you for your help with this. I was stuck on trying to figure out the hours until you sent your last code. It helps to see someone...

Well I didn't make it as far with this as I wanted by now and leave on vacation tomorrow. I don't have a problem excluding the dates (either Sat/Sun)...

I could actually see it going either way. I know the Front-end system currently does not do anything special for holidays that fall in a date range but that...

Thanks for your quick reply! Your code works great based off what I asked for. After I posted it I also thought about the truncation of hours but have...

Steve,

There is a CU1 for SQL 2005 SP3 that has the same items as CU10 and CU11 had in them. So you will not lose anything by not installing...