Which table are you trying to update, tableA or TableB. It is really hard to tell from the code you posted.

This:

SELECT

t1.col,

t2.col,

etc..

FROM

T1

LEFT JOIN T2

...

I'm not really sure what your problem may be here. It would help to see the full error message and the code that you are having problems with.

I have 2000 on my system at...

How many rows are returned with the following query?

select

mt1.*

from

DBO.MyTable01 mt1

where

mt1.Type IN (10,810)

and exists (select...

FYI, not everyone has Office 2007 (or Word 2007) and as I have more than enough things installed on...

andrewd.smith (8/3/2009)

---

Sorry! - that'll teach me to submit an answer without testing it.

However, a minor change fixes the problem I think.

WHERE (a.START_DATE = DATEADD(day, -14, GETDATE()))

Here's a variation that removes...

Not sure if the above actually works. I got an empty result set with this WHERE clause

WHERE

a.START_DATE >= dateadd(dd,-14,getdate()) and

a.END_DATE <=...

Luke L (8/3/2009)

---

Lynn Pettis (8/2/2009)

---

Thought I'd bring this to the water cooler. We talked to Kassondra again today, and she leaves reception tomorrow to actually start Basic Training. ...

It would help if you would please provide the DDL for the table, sample data in a readily consummable format, expected results based on the sample data.

For help providing this,...

CrazyMan (8/3/2009)

---

Hi All

This might sound crazy, but just wanted to know what is the background process when we write a...

naginderp (8/3/2009)

---

Thanks for ur reply,

My Situation is that data in table is reduntant or duplicate . So We Need to maintain the Identity Column in Table to maintain...

Not sure why you would limit yourself to only out of the box components? SSIS is designed to be extensible, allowing you to develop or purchase custom components to...

Yep. That is the answer that was provided earlier in the thread.

Jeff Moden (8/2/2009)

---

Lynn Pettis (8/2/2009)

---

Thought I'd bring this to the water cooler. We talked to Kassondra again today, and she leaves reception tomorrow to actually start Basic Training. ...