Is there a congrats in order?

mmm Bacon Cheeseburger...not hungry anymore 🙂

mmm bacon.....now I'm hungrier.

Hungry

Well, that doesn't sound good for you. If all user interaction is being done through the application and they say they can't spend DEV hours to change the app,...

I'd monitor your SQL instance w/ profiler when you run your package and see if it is taking that long to execute the query against the DB engine or if...

How are you getting a sum of 1000 for that? I think it would help if you gave an example of your table DDL, and a few sample rows...

How are the users querying the data now? SSMS?

What about the second column value of 625, how did you pick this one out of the possible values from within the ref 595 group? Do you want the...

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName VARCHAR(256) -- filename for backup

SET @path = 'C:\Backups\'

SET @name = 'Your DB...

You could use views that limit the data and only grant your users access to those views.

Another option would be to expose the data to your users via SSAS. ...

I'm a bit confused as to the nature of the question. Outside of homework, I can't see where this would ever come up. What is your thoughts on...

What about the obvious answer of changing the query to use the clustered index by removing the IN clause? The IN clause is treated just like a series of...

Agreed. I would stay far away from using a script task for this. Use a data flow, compare the inputs as described by Strick.

cold.....and snowy

Yes, Brandie, it's now cold here! 24 degrees w/ 20+ mph winds....14 degrees with wind chill.