HI,
I am trying to write a query that would display the current rate at the minute based on which meeting time is occuring. I could have up to 3 meetings scheduled per shift.
My goal was trying to have a qry that shows the current production gaol based on current minute in shift and based on...
Hi.. I am try to take the following data and order the structure as seen below. But do not know enough SQL to accomplish this. Can someone lead me in the right direction? If I can supply more information I can try.
Thank You
Header datetime Value
capack4_Dat 11/1/2013...
Thanks for the reply. I cleaned up the code (see below) this is original code from the sheepit plugin. I am looking to use the plugin but am unable to reference the cloned div.. I added a test select but need to access each select when cloned. I am "very" new to jquery any help would be...
I'll try the new one..
Just a thought if i add a value to your qry I get back the following.
Badge Value Start End
pack5_Dat_badge 26805 10/6/2010 11:15 NULL
pack5_Dat_badge 26805 10/6/2010 8:14 10/6/2010 11:45
pack5_Dat_badge 26805 NULL 10/6/2010 8:46
pack5_Dat_badge 27223 NULL 10/6/2010 9:45...
Hi I have the following qry...
select tagname, start_swipe, end_swipe
from
(
select id, tagname, badge, CASE WHEn (ID % 2) <> 0
THEN datetime END as start_swipe,CASE WHEN (ID % 2) = 0
THEN datetime END as end_swipe
from badge_swipe_temp
) a
and it returns the following data...
badge...
Hi I have a badge swipe application where an operator swipes their badge and the number gets stored in the database. I am tring to distinguish when they swipe in and swipe out and display the data to an end user.
Its been awhile since I've been here, could someone lend their expertize.
Here...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.