6 Topics

Member Avatar for
Member Avatar for Danuuu

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 …

Member Avatar for ChrisHunter
0
205
Member Avatar for meryl_1

I'm Meryl Martinez from Philippines. I'm a System Developer. It will be a great experience joining this community. :)

Member Avatar for happygeek
0
75
Member Avatar for Rebekahcorlin

I'm new to the community. it is really great to share and gain knowledge. Happy to joining here.

Member Avatar for JorgeM
0
88
Member Avatar for Gracious_1

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 …

Member Avatar for Gracious_1
0
301
Member Avatar for engrjd91

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 …

Member Avatar for diafol
0
210
Member Avatar for laura301019

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 …

Member Avatar for laura301019
0
249

The End.