I'm sure this question maybe overlooked by those who don't know the "all–at–once operations" property of SQL.

L' Eomot Inversé (2/14/2013)

---

Nice question. However, the explanation would have been better if it had pointed out that filters like this can be placed in the when matche/not matched...

I learned from question on 2/11, I read the question carefully this time. : )

So many back to basics in such a short question. 🙂

Hi,

Example: a user has permission to insert, but denied on delete for tableA.

When user inserts a row into tableA > insert triggers fire.

When user deletes a row from tableA...

Hi...

Hi Lynn,

I like the solution you provided. Didn't thought of that.

Hi,

This solution is similar like other posts. this one is not very efficient but it's enough to solve the problem.

--goal: Output CombYr = 3/4/5

--Input: BegYr int, EndYr int

--assume inputs are...

Hi,

Here's one of the possible solution.

-- # of guests the hotel served on each day in December 2012

SELECT g.checkin AS [date], COUNT(*) AS [#of_guests_served]

FROM dbo.guests g

WHERE g.checkin BETWEEN CAST('20120101' AS...

Hi,

the trigger is missing a begin catch & end catch block.

tough one for my midnight snack. : )

1. No

2. Yes

I would love to attend a DBA boot camp. However, I think most of people wouldn't have the time or the resource to do so. Does anyone know...

totally got burned by this one. : )

I totally didn't know the answer for this one. I thought the answer is the same as the answer for mirroring question last month.

Good one!

It's good to know a bit of history. : )