You would use an Execute SQL Task, but it sounds like you could do this in a simple SQL Server Agent Job, unless you need the parameters to be set...

You can use nested IIF's or a Switch in the expression for background color on the control. Switch would work like this:

=Switch((colA*colB)/colA =25, "Yellow")

Of course I believe that...

Are you using RS 2000 or 2005?

I have tried your solution in 2005 and it is working for me. Try trimming the string, maybe there is whitespace at the...

What control(s) are you using?

In a table you could add this to your a group (the details row has a group as well):

=RowNumber(Nothing) Mod 100 = 0

If you...

There are no DMC's for SQL 2000. Another option is the SQL Health and History Tool (SQLH2) available from MS for free. I have not used it in...

Hey Jeff, good article. It's funny I have answered several forum questions recently using a Case embedded in an aggregate. They weren't crosstabs exactly, but similar. So,...

Arjun,

Thanks fro confirming what i had posted.

I can only recall having seen it once and that was in an index so you can drop and recreate the index to repair it.

One of the rules I learned early was to limit round trips. Think about it this way. If I use 2 datasets that each return 1000 rows and...

The issue is now making 2 round trips to the database, caching 2 execution plans. If you can avoid round trips your report will scale better. I have...

Do you mean what permissions you should grant on his server or on the one he wants to connect to using a linked server?

In order to create a linked server...

You need to include the user accessing the view across the linked server rights to the database and the view. A basic user does not have access to INFORMATION_SCHEMA.

I don't think Chris was suggesting you use a temporary table, I think he was just using a temporary table to hold the test data so he could give a...

Looks like the data is the number of seconds since 1/1/1970 so using the DateAdd function should work. Look up DateAdd on BOL for details.

Why not have the function pass it back as a correctly formatted string? Are you doing more math with the result?