Viewing 3 posts - 1 through 3 (of 3 total)
I do not understand the explanation as the sub query only returns the departmentid, not the empid.
July 1, 2013 at 7:04 am
#1628690
No sample data, no attempts to solve so far. This is still at the theoretical stage - essentially how do you calculate a moving (sliding) period aggregate !
May 12, 2010 at 3:15 am
#1166035
arup_kc (8/9/2009)Comments posted to this topic are about the item Twenty tips to write a good stored procedure
arup_kc (8/9/2009)
I understand that 'where lower(fieldname)' will not use the index on fieldname...
August 10, 2009 at 4:21 am
#1036667