...better alternative!!!

first guess I'd venture is "legacy database"....

If those are the only 3 columns you need to query, you could always do an "if statement"...

IF (SELECT COUNT(*) FROM myTable WHERE code_1 = '404') >= 1
 ...

Kate - please follow this link to read about how another member faced the same problem and resolved it!

Don't know about Sears but I want the "records to show" that of all the companies I've ever had to deal with SYMANTEC HAS GOT TO BE THE VERY WORST!!!

...or...

select * from myTable where datediff(day, getdate(), dateColumn) > 0

For my money I'd go with Sergiy - why bother to count # of rows - just sum(rmstranamt) should be adequate...

If the amount column is to be accurate only upto 2 decimals wouldn't it be easier to just alter the column for precision ?!?!

Another...

Thanks Mike - and 192nd out of 20,000 does make me feel better!

Went back for a last dekko at Santa and saw a top score of 1900 - tell me...

Also forgot to add that today is my b'day - which started becoming really depressing after I turned ## - - so thanks...

WOW!!! - what a nice way to start the new year - splly. since I'd forgotten all about Santa and kicking him across rooftops - I did give him a...

When I finished college (in India) my father gave me 3 choices - study further, get a job or get married - "but your mooching days are over"!!! I got...

"Work is the curse of the drinking classes!"

"The only way to get rid of a temptation is to yield to it!"

"Success is the ability to go from one failure to...

This what you want..?!

select max(id) as id, max(type) as type, grouping_id, max(urn) as urn
from @x where type = 'A' group by grouping_id 

ps:what's an "urn" - is it the...

Maybe I'm looking at this at the end of a long day so don't really understand what you want to do...I could give you some "concepts" to mull on and...