Almost, Barry... Given the methodology involved here, @ROW1 is ALWAYS going to be 1, and @ROW2 is ALWAYS going to be 2, so some of this can be...

I'm talking about ALL the service accounts that can be assigned during the installation process. I'd like to follow best practices for a server environment, despite the...

Thanks Gail. If you could, though, can you at least point me to the other posts about what priveleges one should be granting the accounts to be used...

I know from a prior post that this has been posted to death, but for whatever reason, I can't seem to find any of those posts in a reasonably short...

I'm thinking that there could be a potential problem with this scenario, because there may be more than one record that satisfies a search for 123456, as one could have...

Ummm... I don't agree. You can calculate any sum you want in a T-SQL query that produces your dataset.

However, as I have no information from you on...

Somehow I get the feeling you don't have NI as a field in your dataset, and are instead calculating it in the report. Anyway, in that case, you...

=SUM(Fields!NI)

That's assuming that NI is the name of the field in your dataset.

Steve

(aka smunson)

:):):)

It appears that this formula is being used as a subtotal for the "NI" column. On the basis of that assumption, it appears you may have forgotten that...

If the sole qualification to do this was based entirely on one's experience with this forum, then that would completely ignore the last 30 years I've spent with information technology,...

I'll put my bid in at $75/hr, on the basis of doing it remotely and during night and weekend hours. It's not looking like it's as complex as...

Because set order is not guaranteed prior to your ORDER BY, and a RAND() or NEWID() scalar is going to be different with every execution thereof, we appear to end...

Can't help much with the internal workings, but I'm pretty sure you can't access the those internal results, and you can also be sure you don't need to worry about...

RS is VERY PICKY about what it can handle and what it can't. My limited experience suggest that if the SP contains a DELETE anywhere within, that there...

I suspect that the optimizer is seeing you ask for a value for a scalar, and providing exactly that, a scalar, and I'm coming to that conlusion based on that...