Comments by Balaji 30111978

Balaji 30111978 24-Jan-13 4:27am View

Dear Mr.Vijay,
Thanks for your support , Can I have your contact no. Bcoz I need to explain it in detail. Bcoz the logfile I cannot able to do any changes in that as its receiving datas from the Swiping device. So I need based on those I told you earlier. Thanks for your understanding and support.

Balaji 30111978 22-Jan-13 1:33am View

Dear Mr.Vijay, Any updates , can you pls help me out on this.

Balaji 30111978 18-Jan-13 0:20am View

Thanks for your support , I can give u the Table Design of the Original table that is StuLog fields are
LogID bigInt,LogDate Datetime,CardNr CardNr(24),Name nvarchar(200). U can design the other tables as per your , and give me the procedure and scripts.

Balaji 30111978 11-Jan-13 6:07am View

Stu_Log is the table where the in and out time is getting downloaded from the swiping machine , how can i insert it to the table emplogin and also i dont want the same time to repeat in login or logout Ex (E6000 2012-12-12 17:32:32.000 2012-12-12 17:32:32.000 I) in this both in and out are same time.when there is 1 punch.Kindly advice. Other how can i automate the process to automatically insert values from stu_log to emplogin also can u pls suggest to generate the report for the entire month with 'P' and 'A' status. for the entire month and also need the list of ecode who are having status 'A' for Consecutive 'n' days which excludes Holdiays and Sundays (I will Create a table for Holdiays).If you suggest , it will be very helpful for me. Thanks in Advance for your valuable support.Pls help me out.

Balaji 30111978 10-Jan-13 23:48pm View

For 1 day the status is coming correctly if i run the query for more than 1 day the status is showing as I. Kindly suggest

Balaji 30111978 10-Jan-13 8:16am View

Thanks Mr.Vijay for your swift reply , If its in 3rd shift he will comes in day1 and goes out in day2 , how it can be mentioned and also i need to take consecutive 'P' for n days excludes holidays and Sundays. It will be very helpful for me, Thanks for your understanding and expecting your reply.Sorry for asking too many questions.

Balaji 30111978 10-Jan-13 7:02am View

Its Ok , But I need "P" When there is In and out and Invalid when there is 1 in or 1 Out , I need In and Out time also , If there is more than Two Punches it should consider the Min value as In and the Max value as Out. Thanks for your UnderStanding.

Balaji 30111978 10-Jan-13 6:53am View

Thanks for your quick reply.I need In and Out Time Separetely

Comments by Balaji 30111978 (Top 8 by date)