this doesn't work in SSIS 🙁

DATEADD( "hh", [TimeZone] ,[DockDepartureTime] )

LokeshV I ran this on an empty db and get ambiguous column productsalespopularityid

I modded the query a bit taking the decimal cast out and just get what I had before...

Henry Treftz (3/12/2012)

---

It depends....

Are you going to need to take different downtimes depending on counrty?

Is the database going to get really, really huge if you include all countries in one...

Each country will ONLY see their data. If I log in as Spanish, I will not see any of the English data no matter where I go in the application.

When...

Not in my databases.

I think I understand now what is meant by client machine.

The application servers acts as a client, we could do some stuff there.

Changing hostname doesn't do much because it is...

I don't understand what you mean by "client machine".

I want the connection string that my applications (30+) use currently to stay the same, and the named server instance to accept...

I handled it by using a cursor.

I just thought there was a better way.

Yes that's what I need, but I don't like cross joins either.

I guess thats what I gotta do tho

Well of course, unless your Craig Farrell

get a masters degree in Information systems

what I am looking to do is to get 3 rows for each part (6 rows total)

This is the total problem

USE [GamitOlap]

GO

/****** Object: Table [dbo].[testSales] Script Date: 12/07/2010 13:32:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[testSales](

[yrm] [int] NOT NULL,

[part] [varchar](50)...

Give up and use SSIS, it's much easier.

why can't you just insert the data in the history table? i.e.

Insert into History (all your fields go here) select column1,col2,.... from OldHistory where @DCS is not null

that should work.