9,223,372,036,854,775,807...I could go cross-eyed just reading that darn thing and counting the # of digits...so I'll just wisely leave the knowledge of the quintillion #s to you....

FINALLY...something that even noeld admits to (maybe) not knowing!

btw - noeld - did you know that remi's hero - the great jc...

glad it worked!

what an eager beaver you are remi - just can't wait, can you?!?!

"n" implies unicode and will always use 2 bytes for each one of its' "non-n" counterpart...

???shouldn't count(*) return only one row??? - I'm confused...

however, if it was a "select * from..", I believe "Set Rowcount 0" before the query should be a possible fix (came...

If I understand you correctly, I think this should do it...unfortunately I cannot test this before posting...

select name from sysobjects

where name not in

(select...

I agree with brendthess...you need to post some sample data at the very least...

it seems to be that you don't need the sum() at all and just (afbc - afoc)...

Sorry but I HAVE to ask...was it running on candle power ?!

here're some links that could provide you with workarounds....

source 1

source 2

source 3

sql 7.0

I think you did...make the right interpretation ie..

when I read the post I thought - "of the zillions of things I don't know here's one I haven't even heard of..."...

Chris - hats off to your mastery in translation and interpretation - I would never have guessed this in a million years....

Here's one:

select convert(char(8), getdate(), 108)

Does the heart good to see the u back in colour!

Now if only aluminum could reclaim it's i!

could you please post your update sql...?