Viewing 15 posts - 811 through 825 (of 3,232 total)
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...
January 4, 2010 at 3:09 pm
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...
January 4, 2010 at 2:05 pm
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...
January 4, 2010 at 12:18 pm
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...
December 22, 2009 at 3:02 pm
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
December 21, 2009 at 2:56 pm
sqlrunner is correct, you must cast it within the expression.
Just a question though, why would you not store using the date data type?
December 21, 2009 at 2:52 pm
Ted Zatopek (12/21/2009)
The next...
December 21, 2009 at 2:49 pm
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...
December 21, 2009 at 10:56 am
Atif Sheikh (12/21/2009)
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...
December 21, 2009 at 10:35 am
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,...
December 21, 2009 at 9:50 am
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...
December 18, 2009 at 10:35 am
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...
December 18, 2009 at 10:32 am
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...
December 18, 2009 at 10:27 am
You can encorporate that into your SELECT as well.
SELECT varchar1,
varchar2,
varchar3,
...
December 15, 2009 at 9:31 am
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...
December 14, 2009 at 5:04 pm
Viewing 15 posts - 811 through 825 (of 3,232 total)