I need definitions for the source tables and a clear explanation of what end result you're trying to get.

Here's part of what you posted as a sample result:

Why would you...

Koen Verbeeck (2/28/2011)

---

TravisDBA (2/28/2011)

---

Any question in an interview where your first gut feeling is "That is none of your business." Go with your gut, that is not a good question,...

amenjonathan (2/28/2011)

---

So it boils down to semantics. I worded my question wrong. lol The intent is still the same. You know what I am getting at. That's the real debate...

In your sub-query, use "inserted" instead of "EncoreCompanyT.dbo.LotTransactions". In triggers, you have two "tables" called "inserted" and "deleted". "deleted" has the "before" data, "inserted" has the "after" data....

What happens if, instead of a message box, you log the message to a file or table?

Kiara (2/28/2011)

---

jcrawf02 (2/28/2011)

---

Stefan Krzywicki (2/28/2011)

---

jcrawf02 (2/28/2011)

---

I'm just growing tired of having to explain Microsoft's commercials to my wife. Some idiot on the screen says "To the Cloud..." and I have...

James Goodwin (2/28/2011)

---

I think this is the point of the dispute with GSquared. The question as normally asked is not...

From what I can see of your table, you have essentially a full cartesian join of three tables: Program, Year, Major. That means you have a number of rows...

I just tried this on an SQL 2005 server:

USE ProofOfConcept;

GO

SET ANSI_NULLS ON

GO

SET ARITHABORT ON

GO

SET ANSI_WARNINGS ON

go

SET CONCAT_NULL_YIELDS_NULL ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [DB_DDL_LogDDLEvents_TrgWD] ON DATABASE

FOR DDL_DATABASE_LEVEL_EVENTS

AS

SET NOCOUNT ON;

...

You'll need to search for "IMEX" online, with regard to Excel data import. Try that, it'll get you what you need.

Which...

Exactly.

The whole point of the question is to see if the individual:

1. Can admit shortcomings

2....

Koen Verbeeck (2/28/2011)

---

GSquared (2/28/2011)

---

Koen Verbeeck (2/28/2011)

---

Ugh. The "cloud". Management buzzword of the past few years.

I have already been working with a cloud based email and messaging system.

It is called Hotmail......

amenjonathan (2/28/2011)

---

I would say you're an intelligent guy who has no sense of humility. Bad for business. You're going to ostrisize yourself with the entire team; therefore, if I hire...

Koen Verbeeck (2/28/2011)

---

Stefan Krzywicki (2/28/2011)

---

Brandie Tarvin (2/28/2011)

---

GSquared (2/28/2011)

---

I think that's one of the reasons some companies are interested in "cloud computing", because then their code is on their server, and...