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.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉 Helpful Links: How to post code 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