how can i select consecutive records for an employee?
so if there are 5 entries for emp1, i only want to select the ones where the dates are consecutive.
eg.
date empname
10/08/0...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20175493.html
Zones:
Visual BasicDate Answered: 08/31/2001 Grade: A Views: 0
Greetings all. Been a bit since I have visited. Here is a question that I am wrangling with.
I have a table that has an entry for each period (which is really defined as a month). Each entry ha...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20413200.html
I am trying to calculate a time difference over two consecutive dates in MS Access. (I have included the query in SQL view at the end.) I understand that Access converts it to numbers, but I don't ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20474351.html
Zones:
MS AccessDate Answered: 01/28/2003 Grade: A Views: 0
I have a table that is ordered by id and tax_period with the following structure:
id varchar2
,tax_period date
,related_period date
My question is how can I select the related_period value f...
http://www.experts-exchange.com/Database/Oracle/Q_21177722.html
Zones:
OracleDate Answered: 11/02/2004 Grade: A Views: 0
Hi all,
I've written a Macro to perform some formatting by looping through the data. But I want the macro to stop after I have had five consecutive blank cells in column E. For example:
'Tr...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/17/2005 Grade: B Views: 0
Anybody know of an improved SPLIT function that will treat consecutive delimiters as one?
Thank you.
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20468617.html
Zones:
Visual BasicDate Answered: 01/21/2003 Grade: B Views: 0
Hi,
I have a table which is something like this :
ID VAL
---------- ----------
1 24
2 24
3 25
4 25
...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20863003.html
Zones:
DatabasesDate Answered: 05/03/2004 Grade: A Views: 0
At the click of a button, I am trying to play one movie clip, immediately followed by another movie clip. For some reason, I only ever see the second movie clip.
If I take out the second movie ...
http://www.experts-exchange.com/Software/Photos_Graphics/Web_Graphics/Macromedia_Flash/Q_2...
I need to build a query that compares current to previous values of fields in the query.
To accomplish this, I'll need to number the rows in the query. I've seen solutions for this using imbedde...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21019066.html
Zones:
MS AccessDate Answered: 06/15/2004 Grade: B Views: 0
Hello!
I am trying to add seating to a ticket purchase application. Seats are assigned according to Section, Row and Seat Number. So for example, a sample ticket would have a Section: A, Row: 2...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21502726.html
