Steve, what about PeopleSoft?  Their documentation says their app needs SA privs to the database.

To help we will need more information.  If you could post the code for your query and the DDL for the table(s)/view(s) used and perhaps some sample data would go...

Sounds like you are adding requirments to your original request.  Can you provide more details as to what you are asking?  It also sounds like you need to expand you...

How about we form a company so we all can benefit.

 I think you need to post what you have, the DDL for the tables, some sample data, and what the results of the query should return.  with that, there are...

Took a minute, but that little change makes sense.  Something I can add to my little tool box.

Thanks Sergiy!

Notice it is always the shortimers who seem to jump right in and help?

For about 20 weeks out of the year (10 weeks in fall and 10 weeks in spring) I get out of the office and do something totally different, I am...

I am assuming (bad habit) that the data in this case is numeric.  This actually sounds like a good use for using CLR integration and write some procedures/functions in VB.NET...

Had this problem with maintenance plans at my previous employer.  We had to delete and recreate the maintenance plans to get it to work properly.  If we had to make...

Unfortunately, we also had other issues to deal with as a result of the upgrade from SQL Server 2000 to SQL Server 2005 besides this particular query running slower on...

From what I can tell, the mirrored backups isn't supposed to protect from a failure during the backup, but from the media failing after the backup is completed.  I am...

Based on that, would you say it is worth learning more about statistics?  I am just curious how much time and effort I should put into some of this or...

Hard to say anymore.  Having created new indexes and statistics, I don't have the origianl plan available to compare it to.  All I can say is that based on the...

I am more than willing to help, but I am not the only one who is start to question helping you.  I have yet to see you put anything up...