Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is the use of DBCC commands?

4 Answers   NA,


What are different types of replication in sql server?

0 Answers  


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  


Explain important index characteristics?

0 Answers  


What is the use of RDBMS?

0 Answers   Wipro,


How to find index size for each index on table?

0 Answers  


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  


Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers  


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

0 Answers  


What is the difference function and stored procedure?

0 Answers  


What is indexed view?

0 Answers  


Explain go command in sql server?

0 Answers  


Categories