I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2296

Why I can not enter 0.001 second in date and time literals in ms sql server?

1113

How to transfer data from a cursor to variables with a "fetch" statement?

1148

Scalability, Availability, Integration with internet, etc.)?

2940

What is autocommit mode in sql server?

1271

What are drilldown reports?

160

When I run the sql server 2000 setup, it just hangs. What do I do?

1129

Tell me what is de-normalization and what are some of the examples of it?

1100

How to encrypt Strored Procedure in SQL SERVER?

1233

What are the steps you can take to avoid “deadlocks”?

1026

Tell me what is normalization? Explain different forms of normalization?

1075

Why use triggers?

1072

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2169

Do you know what guidelines should be followed to help minimize deadlocks?

1018

What is CTE in SQL

997