Because it is the last table.

Would help to see the complete query.

Frances L (10/29/2008)

---

I have table in MS ACCESS:

has hire_date, rehired_Date, Termination_Date.

I want to

select rehired_date as hire_date when terminate_date

How to write this statement ?

ig:

hired_date as 10/1/07

termination...

Tommy, don't think that is what (MERGE in SQL 2008) the OP is looking for. Original post indicated 4 tables with 100 records each, into one table with 400...

Sounds like a Running Totals type query. Please read this article written by Jeff Moden, it should help you.

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

Just a little more info. Are all four tables completely identical, or are there only 4 fields that are identical? If there are other fields that aren't, do...

Write a query using a CROSS JOIN or two against you biggest tables. That may slow your query down enough.

David Reed (10/29/2008)

---

Humorous? Maybe. Looking at this from the perspective of the men and women in uniform who actually guard the wall for us 24/7/365, not so much.

:sick:

Laugh if ye...

So, to paraphrase your spreadseet, Fiscal Year 2009 starts the first day after the last Saturday in February (2/24/2008) and ends the on the last Saturday of February in the...

Got to ask, what is the fiscal year? Also, what do you consider a fiscal month?

Any differences in execution plans between dev and prod?

I've been working with SQL Server for about 12 years now. I use BOL regularly. I also have a portable library in my car with about 8 SQL...

In your data flow, yes, add a lookup. If successful, do an update. If it fails, do an insert.

Just like you would have to if creating a permanent table. Base the column types off the data you are going to load from your queries.

To be safe, I'd disable the job while deploying a fully tested update to the SSIS package.