Have you verified that the data in the variable is changing as you expect in the loop? You can use a script component with a MEssageBox to show the...

Lynn provided that code as an EXAMPLE. You replace the #temptable reference in the select query with YOUR table name (tblPersonnel).

I'm not sure what you are asking now. The code Lynn provided could be used to create a view or within a stored procedure that you would call whenever...

Check out this article: http://www.sqlservercentral.com/articles/tamestrings6/263/

Do you mean your users or you? SSRS will give them the data in a easier to read...

Have you looked a SSRS (it is part of the SQL Server license)? You can schedule reports to be sent via email.

I'd do something like this in T-SQL:

SELECT DISTINCT...

The best way to run is using 2005, but if you have old code that is not supported in 2005 you don't have much choice. I am currently running...

What are you using to render the report? Normally that kind of detail/sum reporting would be best handled by using grouping in the reporting solution you use whether it...

How do you want to handle null/invalid values in the average? Do you want to ignore them or count them as 0? If you have the following 3...

Lowell,

Thanks for fixing my code too! I always forget that one because I always think it changes the context, but it doesn't.

Okay this is similar to Lowell's solution, but I'll put it out there anyway:

sp_msforeachdb @command1 = 'Select

''?'' as db,

S.name as schemaname,

T.name as tablename,

P.rows

from

sys.partitions P Join

sys.tables T On

P.object_Id =...

There may be a users group that is not an official PASS chapter. I'd try to find my area's MS Evangelist to find out about user groups in your...

I am talking aout the user domain account used to run the SQL Server services. Do I just need to create a domain user account with password and no more...

Can you post what your desired outcome looks like? Also post some test data so we can see exactly what you are working with and trying to do. ...

There are a couple of things you should do.

1. Make sure your statistics are up to date

2. View your execution plan to verify that you have appropriate...