As far as I can tell no, but I couldn't find any official documentation. I could find that SQL Server 2005 SP3 is the oldest version supported on Windows Server...

I figured that you probably want when the value on the next day is less than or equal to 50%, and to account for small differences rounded. If that is...

Using ROW_NUMBER:

WITH CTE AS (SELECT

Symbol,

...

Depends on what you are trying to do. DISTINCT is just an automatic GROUP BY on every column in the SELECT clause, so if that is what you want DISTINCT...

I'm taking a guess here, but I suspect you are using the wrong columns in the ON clause to join the two tables. What columns link the two tables?

Can you at least share the query you were running that gave you the error?

You might want to review the article that I linked to in my previous post. With...

Your welcome, thanks for letting me know that it helped.

What edition of SQL Server are you using?

If you aren't using Developer, Enterprise, or a higher edition I believe that you have to add the WITH (NOEXPAND) hint to...

Question deleted, as I had mis-read the post.

Sure, it is possible you just have to JOIN the two tables in the FROM clause.

Not having the table structures makes it so I can't actually write it for you....

That sounds like it should work as long as nobody else INSERTs rows while your package is running.

Actually that isn't a bad description of your problem, though it sounds a little bit like homework. Here is an article that can help you submit better questions that would...

I'm...

Jeff,

You may want to edit your signature, your link to how to ask about T-SQL appears to...

I would look at the execution plans from both queries and compare them. 2008 may be creating a more efficient plan.