@chrism-2 definitely, that makes more sense. Although, I'm curious about the execution plans; IIRC, for UNION structures like this, I think I've seen the optimizer choose to do...

I'm not quite certain what you want to do; GROUP BY implies aggregation, but you have no aggregate functions (MIN, MAX, COUNT, etc.) present. I'm also not sure if UNION...

How much data is likely to change over the course of an hour? Is data being inserted/updated/deleted frequently during the day, or is it fairly static? How many insert/update/delete operations...

Here's a (very likely) scenario to think about: the user remotes onto the SQL server and launches SSMS. They then issue a query that SELECTs a few million rows or...

No problem. If you want to provide a script to create the table structures and populate with sample data, I can take another stab at it. My suspicion is that...

LOLCatLady (11/2/2011)

---

I'm sorry, but that didn't limit the data - it returned the same data as before. The section of code I changed to this:

(SELECT giftid, SUM(giftdeduct) AS cumGift

FROM...

elkucho (11/2/2011)

---

Thanks for the reply.

So if the records doesn't exist it will do to a OLD DB Destination, right ?

But if it does exist, what is the next component after...

..and John Mitchell wins today's quick-draw contest... 😀

Views, like tables, are considered to be unordered sets. Take a look at this MSDN article: http://msdn.microsoft.com/en-us/library/ms188723.aspx From the article:

Although the view definition contains an ORDER BY clause, that ORDER...

You actually mean "restore the most recent full backup, then restore the subsequent transaction log backups in order" right? That's how a restore works...you can't just "apply a log backup"...

I wonder if comments.commentText (or less likely, one of the other fields) contains some values with CR/LF sequences...I've run into that before. You could try something like this to replace...

If you had auditing of successful logins enabled, and if the login was created recently enough that all such events are still present in your error logs, yes...

This may be a good point to start looking for a good third-party address cleansing tool. This particular rabbit hole can be very very deep... :crazy:

Actually, sp_change_users_login is deprecated in 2008. It has been replaced by the ALTER USER statement.

ALTER USER [username] WITH LOGIN = [login name]

What version of SQL Server is this?

Who is set as the owner of the SQL Agent job that is failing?

Check this KB article: http://support.microsoft.com/kb/241643