OK, I will admit I didn't do the 431 training. Did do all of the SQL developer training...

Have you tried them?

Run them both with the execution plan enabled and see which SQL says has the higher cost. See which (if either) runs faster, and see which (if...

I haven't seen a course that...

In doesn't work with a variable that contains a comma-delimited field. Your best option would be to split up the string with a table-valued function then use IN (SELECT ......

🙂 Thanks.

The inserted and deleted tables are only available inside triggers. In a trigger, you can select from them just like any other table.

Double post. Please continue thread here

Forgive me for again directing you elsewhere, but I wrote on this just a couple days ago

http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/%5B/url%5D

Again, if you have more questions, I'll be very happy to answer them.

Don't. A resume should be short and to the point. If I'm looking at a resume, there are three things I'm looking for.

1) Your...

And your QA environment (at the least) should have close to the same amount of data as the production. This is so that you don't get queries that run fine...

http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/%5B/url%5D

If you still have any questions, post them and I'll be happy to help.

Just before the MM_editCmd.Execute, could you add

response.write MM_editQuery

and post here the query that is written out?

A recursive CTE is perfect for this. This may not be 100%, but should give you the idea.

;WITH RecursiveEmployees (Emp, Supervisor, Dept) AS

(

SELECT Emp, Supervisor, Dept FROM Employees WHERE...

I will strongly agree with your last point. I've seen that over and over again, often with complaints about favouritism from those who don't focus on their careers.

It is possible to mark a procedure as a system procedure. It requires updating the system tables.

Modifying the system tables is not a good idea. It is a very...