RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row. First step towards the paradigm shift of writing Set Based code: ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!" Helpful Links: How to post code problems How to Post Performance Problems Create a Tally Function (fnTally)
Don't do it God! Sorry, just been trying to fix some legacy date time issues moving stuff around and I'm already thinking of the horrible date time code I'd be trawling through to get it working with the extra hours in the day.
This reminds me that there have been a few attempts to introduce decimal time. The first attempt was in the French Revolution. Also some years ago Swatch introduced a decimal watch but if I recall correctly they were all recalled!
That is a definite must-have feature enhancement. Longer days would be great on so many levels.
Jason...AKA CirqueDeSQLeil _______________________________________________ I have given a name to my pain...MCM SQL Server, MVP SQL RNNR Posting Performance Based Questions - Gail Shaw[/url] Learn Extended Events