How to filter out duplications in the returning rows in ms sql server?

0 Answers  

---

What are data files?

0 Answers  

---

Explain the properties of the relational tables?

0 Answers  

---

What is DAC? what is the use of it?

1 Answers   Wipro,

---

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

0 Answers  

---

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

---

What does this statement do @@rowcount?

0 Answers  

---

How to write a query with a right outer join in ms sql server?

0 Answers  

---

can a table be moved to different filegroup? : Sql server administration

0 Answers  

---

What is application role in sql server database security? : sql server security

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

What is a job?

3 Answers  

---