Sql how to
-
I owe my new nickname to Jeff. I'll let him explain it
. -
The common meaning of "Ninja" is that above a black belt in whatever art is being practiced. In truth, Ninja's were professional assassins who were very good at what they did. I prefer the definition of "shinobi" which is the art of "to do so as not to be perceived by others".
Overall, the connotation pf "Ninja" is that of an expert that cannot be touched by others' comparatively miniscule knowledge of a given art.
--Jeff Moden
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.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Leave them their storage and create the right one in parallel.
Set up a trigger on their storage to syncronise both storages on every insert/update/delete.
Create a simple SELECT from right storage.
You need that right storage anyway to perform SELECT, either in permanent or in temporary tables. Permanent tables will just allow your query to perform better.
_____________
Code for TallyGenerator -
Ya I already implemented something like that. It wasn't because of bad design but more because of user needs. They needed to have a week displayed on a single row where they could select any of the seven days. Since I was using access I just made 2 sets of table, one denormalized for the users and single form. Then another version maintained only by triggers which I used for any other parts of the application. In the process it simplified and corrected a bunch of reports that needed a date ranged based on real dates and not "week date".
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply