How would you define 'first match'? Is there a date column in your table2 that would tell us which row comes first? If not, is there an incrementing...

Yea, stinks huh. I ran into this same thing a while back. Do you have the IDENTITY property set on that column?

Here's a thread that may...

This really isn't a DTS issue. A global temporary table is a global temporary table no matter where you create it from. It still must follow the rules...

There are several different ways to do this. This is just one of the ways that would work, but for your scenario, it may be what you are looking...

Nevermind, I just saw the other threads for this question.

Let's end this thread and continue all responses to this thread:

http://www.sqlservercentral.com/Forums/Topic837454-148-1.aspx

sqlrunner is correct, you must cast it within the expression.

Just a question though, why would you not store using the date data type?

Ted Zatopek (12/21/2009)

---

I would break this up into several tasks. The first would do all the comparisons and inserts into Table X using whatever logic you need.

The next...

Doesn't that contradict your previous post? Before you said that the donation must meet all of the criteria and no more criteria

Any Donation having More than above Preferences are...

Atif Sheikh (12/21/2009)

---

Patient with Preference like

Male ( PrefID=1)

Location America (PrefID=5)

Religion Muslim (PrefID=8)

Age between 25 (PrefID=3)

Here is the explanation;

The above condition means All the DonationIDs are valid if...

Use the debugging components within BIDS to set a breakpoint on the task where you would like to evaluate the variable values. When your package execution reaches the breakpoint,...

Who designed the tables, the developer? If you post the table DDL, index definitions, sample data and your query, we can help more. Please reference this link to...

How is the data in these 2 tables related? How can you tell which code goes with which member? Based on your sample data, what would you want...

One point that warrents mentioning here is that the Query Optimizer is partition aware. If you use a date column as your partitioning key and your queries against that...

You can encorporate that into your SELECT as well.

SELECT varchar1,

varchar2,

varchar3,

...

Ah, I should have noticed that! The column list in the INSERT and SELECT should be matched up. The values will be inserted into the table and mapped...