Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Procudtion standard rate query
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...- mp2admin
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Sql order structure?
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...- mp2admin
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Group SQL QRY
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...- mp2admin
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
Autoclose alert pop up
Could someone lead me in the right direction on how to auto close an alert pop up? Thanks- mp2admin
- Thread
- Replies: 2
- Forum: Javascript
-
badge swipe system issues.
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...
