Viewing 3 posts - 421 through 423 (of 423 total)
All your problems stem from using the wrong unit of measure (day). Radically simplify the solution by defining a "relative" work week for each shift. Create a table with the following...
October 17, 2005 at 3:06 pm
The best programmers use almost no variables. I think it can be simplified down to something like this:
set @minutes = 29
set @incr = 10 --1,3,10
select round(((@minutes / @incr)...
October 14, 2005 at 2:35 pm
After decades of maintaining stored procedures, I have evolved into always using aliases for less typing and higher maintainability and readability and faster, easier editing. Since foreign key columns virtually always match the primary...
October 7, 2005 at 9:49 am