SUM(CASE WHEN dob_age ­­>= 80 THEN 1 ELSE 0 END) * WhateverHere AS X80

That's how I'd do it server side... maybe that can be applied is SSRS :

SUM(CASE WHEN dob_age ­­>= 80 THEN 1 ELSE 0 END) AS X80

SUM(CASE WHEN dob_age ­­<...

Here's one question.  Why are you doing this server side?  I know you can find some trick or tweak, but this seems to be a problem more suited for excel...

In my case that NN table had a key about an access object.  From that table, I was drilling down all the way from Form to the form's object's properties.  The...

Sounds more like you need bi-directional replication.

I'm saying that without having done anything in replication, but it think it's worth a look for you.

Can't wait to see what others have to say about this one.

I think you're alright in this case. 

I've used the identity option in a few cases.  IIRC, it was...

Wasn't it that once said that it's better to ask for forgiveness than to ask for permissions (sometimes).

Good point Steve.

But there are advantages when consulting for a small shop .

Sure, run at 6 AM

First line of code :

WAITFOR DELAY 02:00:00

 .

I'd do that if reasoning with the person doesn't work.

What's the full reasoning behind this?

Triggers are a great tool when used to do the right job.  I'm not too sure in this case, but then again I don't have...

openquery / openrowset will offer 1 more option (one of them requires the link, but I forgot which one).

The other option is to use ssis or whatever else to get...

Thanks for the info.

Now let's see how I can do this in 2 weeks .

Thanks for the information.  Things are a little clearer now .

This is already going to be intergrated to some point.  You will be able to dbl-click on any id field to drill down one level and see that info (assuming...

Keep in mind that this solution doesn't work (is not 100% reliable) if the stats are not up to date.

Also keep in mind that no rows in the table does not...