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

2191

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

931

What is openxml in sql server?

1126

Explain trigger and its types?

1021

What is auditing in sql server?

888

What is the difference between indexing and hashing?

1099

How each E-R model constructs can be mapped to the relational model?

938

Explain what is the difference between a local and a global temporary table?

951

What do you understand by integration services in sql server?

931

What is user-defined scalar function?

923

Can we perform backup restore operation on tempdb? : sql server database administration

955

Can we call stored procedure in view in sql server?

868

what is blocking? : Sql server database administration

986

What are the ways available in sql server to execute sql statements?

1058

What is log ldf?

940