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?

Rack,

If you need a SQL 2000 solution you should post in SQL 2000 forum. Many posters, like myself, will base our answers on the forum we are in.

Here you...

Never having had the pleasure of working with Oracle, could explain what PERCENTILE_CONT does? Then even a neophyte like myself might be able to help.