Thanks a lot, guys. It 's working now (Group By Id was missed either). More important, I hope I understood how it works. Thanks

Unfortunately, there is an error in your query and I can't fix it as, frankly, I didn't get the logic in  "WHERE" part, i.e. 1=Case, etc. It shoul be in this...

You are right- I just checked for one of my table- results are different.

Thanks

Remi, but if EM uses sysindexes for counting number of rows it should initially do reindex (update statistics) for table where cluster index was created to get correct results? Is...

At the min you should use System Monitor and Sql Profiler (there is a lot of info in BOL and this site).

Good Luck

Chris, thanks a lot for your explanations. But I am just curios. From EM=> Taskpad =>TableInfo we can get number of rows in each database table pretty quickly. I have a...

Thanks, guys. It makes sense now. The reason that I started to dig into sysindexes table is, as I read somewhere, query

SELECT rows FROM sysindexes WHERE id...

From BOL I found that indid=1 points to cluster index and indid=0- to table. When I've got number of table records (rowcnt) using indid=0 it always correct. But there is...

Thanks. That means I need pretty often update statustics to keep this data correct?!

Thanks a lot, guys.

Probably we will move this culture specific conversion to application. Developers just asked me to add extra field "Culture Name" and will use probably "CultureInfo" class...

Sorry, probably I wasn’t clear in my initial post. Data (Amount) for every user is in numeric format (i.e. like 12.34 regardless where, I mean country, every user is)....

I didn’t have any problem with default parameters after deployment. It’s pretty challenging to figure out what is wrong as you didn’t provide any info how you supply default...

Thank you- makes complete sense!

Thanks, Brian. Just to confirm that I've got you right- Sql Server will check every permission User has (all roles, etc) and aggregates them regardless what User is using- QA,...

Thanks, Remi, I definately post a solution in case I'll find it.