My turn to appologize... I though you were talking about unpivoting. What you did with the pivot is just fine. You can also do something similar with dynamic...

Heh... you still used dynamic sql... not so bad as RBAR, but post the spreadsheet you're trying to resolove... lemme take a whack at it.

Post what you did for the problem... attach the spreadsheet you used if nothing private is in it.. let's give 'er a whirl. 😀

Any links I would be using at...

You didn't listen if you ended up using RBAR and hardcoded names... you didn't read the articles that were suggested well enough.

I can't duplicate the error. In other words, I get no error unless certain rows are being used by foreign keys.

The problem is that designers and PM's write the same kind of mistake.

Crud... I just realised this is for integration services... hope what I wrote for you still works...

Kind of... if both datatypes, 1 for the function and 1 for the column, are datetime, why not use that to your advantage?

DECLARE @Today DATETIME

DECLARE @Tomorrow DATETIME

...

Please read the article at the URL in my signature before you post again. You're post should have looked like the following...

--===== Setup the test table

...

Of course, you also realize how dangerous this is? If you were to change the price on an item list, you would change all orders that referenced it ......

You can have a computed column that automatically does this. A computed column really doesn't like to refer to other tables or even other rows. Certainly, they don't...

I don't believe you need the "@" sign. Also, what datatype does the function return? If one or both are datetime datatypes (like GETDATE() is), then you can...

Use bulk insert to import the file into a table and join to it as you normally would.

As an alternative, you could Create a Linked Sever or OPENROWSET and read...

The formula in the following article will calculate weekdays without a loop. There is, however, no consideration for holidays...

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

Yep... make sure that nothing under spid 50 is affected in this manner. System would hate it...