Comments by P.S Vijay

P.S Vijay 27-Feb-13 1:17am View

thanks

P.S Vijay 27-Feb-13 1:17am View

Thanks

P.S Vijay 27-Feb-13 1:17am View

Thanks for your support .... It is working fine .... :)

P.S Vijay 6-Feb-13 4:05am View

My Mob No is 9388365646

P.S Vijay 22-Jan-13 23:49pm View

ohhhh.... I am so sorry.... I was so busy last 3-4 days, So I didn't log in code project.

As per you requirement, I create a table for u ... plz have a look ..

Table Name : GMLogData
------------------------------------------------
FieldsName Datatype
------------------------------------------------
TransID bigInt Not Null
CardNo nvarchar(24)Not Null
LogIn_ID Int NotNull
LogOut_ID Int Null
Remarks ntext Null
------------------------------------------------
Business workflow
------------------
System shall find out in GMLogData(New Table) using CardNo wether LogOut_ID is null or not
If Logout_ID is null then System will be update Logout_Id.
Other wise insert a new row and update TransID ,Login_ID (LogOut_Id will be null).

User Workflow
------------
When Employee comes in, then the TransID and LogIn_ID will be insert and when Employee leave from the office at that time, LogOut_ID will be update for the same row.
Remarks : In the case of Manual (If employee forgot his access card). So you can put a manual entry and write the remark.

P.S Vijay 13-Jan-13 23:27pm View

can u send me the table design for both table ....

P.S Vijay 28-Dec-12 5:13am View

Ohhh ...It is little bit challenging.. Give me some time, I will get back to you.

P.S Vijay 28-Dec-12 2:30am View

As per my understanding, you want to compare row with a previous one, and fetch all dates which having 30 sec or more than that.... Right ?

But your mentioned output is not like that. Please look at below difference is shown in second .
D_Date Sec
----------------------- -----------
2012-05-26 10:03:11.000 43
2012-05-26 10:03:54.000 21
2012-05-26 10:04:15.000 18
2012-05-26 10:04:33.000 24
2012-05-26 10:04:57.000 37
2012-05-26 10:05:34.000 12
2012-05-26 10:05:46.000 38
2012-05-26 10:06:24.000 10

Please check and update me ... I am here.

P.S Vijay 26-Dec-12 2:32am View

Hi Mehdi,
I can view that, But I need to read that content of the .log file and update it to SQL Server from using my local machine.
As I mentioned , There is no way to copy things due to security policy issues.

P.S Vijay 26-Dec-12 2:11am View

Deleted

hi
Just go with this ...
http://blog.sqlauthority.com/2011/05/23/sql-server-running-ssis-package-in-scheduled-job/
and use the previous link.
Regards,
Vijay

P.S Vijay 2-Aug-12 5:09am View

Hi Santhosh Kumar

I am Vijay, Good work but dear I working in SQL 2000, ROW_NUMBER/PARTITION ect is not there. rest is the table structure keep it as it is no problem for that.

Thanks & regards
Vijay

P.S Vijay 13-Apr-12 7:57am View

It is not working

P.S Vijay 20-Mar-12 3:37am View

I am using Sql 2000

and I am getting 7.1428571428571397E-2 please help me and take me out
from here

Comments by P.S Vijay (Top 13 by date)