6 Topics
|
|
hi i need to show employee attendance based on device logins with employess various information like department,designation,device_person_id,person_id,logid etc..... joining 3 tables i.e dbo.tempdevicelogs,dbo.employee_settings,dbo.persons_profile i tried this one Select Device_Person_id,personal_id,Date1,( cASE WHEN eXISTS( SELECT Device_Person_id FROM tempDeviceLogs AT WHERE T.personal_id=AT.Device_Person_id AND T.date1=AT.logDateTime ) then 'P' Else 'A' End )as Status FROM … |
|
I'm Meryl Martinez from Philippines. I'm a System Developer. It will be a great experience joining this community. :) |
|
I'm new to the community. it is really great to share and gain knowledge. Happy to joining here. |
|
So here's a bit about the details. I need to read the contents of file A, and B and store it in file C by joining the contents of A and B and also counting the number of letters/characters present in it. I've come up with this so far. Can … |
|
I am trying a query in mysql. I have 3 tables which are linked by the same foriegn key ... Table 1 = students (PKey - stdnt_rfid_tag) Table 2 = student_attendance ( FKey - s_id for stdnt_rfid_tag ) Table 3 = users ( Fkey - s_id for stdnt_rfid_tag) In the … |
|
Hi I have a webform to allow users to register this information is stored in a Clients tables but I would like some of the information to be stored in another table that will store the username, security question and answer. I tried using two separate insert commands but it … |
The End.