forsqlserver (8/24/2011)

---

Thanks TOM

But I am asking about the if else condition:

Suppose in one row at one time one startdate is coming but other termination date and officiatingstartdate is...

forsqlserver (8/24/2011)

---

Tom please help one more thing

Use HRMS

Go

Create TRIGGER SteagingAfterInserttest ON [dbo].[staging]

FOR INSERT,UPDATE

AS

Update Staging set Startdate=Startdate+'T00:00:00.000' where EmpId in (Select EmpId from inserted);

Update Staging set Terminationdate=Terminationdate+'T00:00:00.000' where EmpId...

Good question.

Isn't the inability to apply the loop hint to a right join a bit bizarre though? Although it seems pretty obvious why this happens, there is in fact...

Instead of

create...

Could it be that people are trying to use sys.sp_ms_marksystemobject in a later version of SQL Server than the one it worked in? That would account for its not working...

Fal (8/23/2011)

---

Er, do sports...

Yes, same trigger will work for both update and insert provided you include...

It's better to write a trigger that doesn't declare local varaibles, just in case at some time in the future...

Good question, but:

Although the later BoL versions (SQL 2005, 2008,2008 R2, and Denali) are better, and make it clear that they are talking about the names of system stored procedures...

Sarah Orange (8/22/2011)

---

wouldn't that then restrict the use of the link to people in that group? at the moment we have a service account using it too which works...

ChrisM@Work (8/22/2011)

---

Some employment agencies offer a pre-testing service. I can see us reaching a point very soon when only pre-tested candidates will be worth interviewing for all bar the most...

Have you tried switching to use "using this security context" and specify the domain and group?

A nice easy one for Monday morning.

I was somewhat surprised to see it before 0100 BST on Sunday, though.

EDIT: Why are there two of this? Is it a consequence...

A nice easy one for Monday morning.

I was somewhat surprised to see it before 0100 BST on Sunday, though.

Eugene Elutin (8/20/2011)

---

You are just very lucky man that J.Celko is not your 'mon papa'. Otherwise you would be caned badly for behaving coding like that :hehe:

I'm lucky same...