Do you have DAC enabled on the server? If not, you may want to enable it; if you do, good. If this happens again, you may want to...

Could you post the DDL for your DDL triggers? Maybe we'll see something you missed.

Florian Reischl (6/29/2009)

---

SET FUN ON

Or, a UNION ALL if you generally don't like functions in your SELECT clause.

SELECT ZIP + isnull('-' + PlusFour, '') AS FullZIP

FROM [Address]

...

Nuts (6/29/2009)

---

Table A

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[DrugA]

AS

SELECT year1, month1, Quarter,[Patient No.]

FROM MainTable AS a

WHERE ...

:hehe:

Or, if you aren't concerned about using only Standard SQL:

SELECT ZIP + isnull('-' + PlusFour, '') AS FullZIP

FROM...

Can you provide the DDL for the table (original, not temporary), sample data (in a readily consummable format that can be cut/paste/run in SSMS), expected results based on the sample...

When using the quote button anymore, I do two things. First, I refresh the page prior to clicking on the quote button. Second, reading the quote to be...

Alvin Ramard (6/29/2009)

---

That's ok. It's just the usual behind the...

Just a side conversation between colleagues, please feel free to join in. 😉

Nope, Books Online is the...

GilaMonster (6/29/2009)

---

Alvin Ramard (6/29/2009)

---

Yep. I'm ready to guess the solution to his update problem is, but we can't say without knowing more about...

GilaMonster (6/29/2009)

---

Except that there's no condition in the where clause that joins the two tables...

GilaMonster (6/29/2009)

---

I'm sorry, I thought you might like a hint where...

ddicecca (6/29/2009)

---

Lynn Pettis (6/29/2009)

---

ddicecca (6/29/2009)

---

Seriously...? That's your help? I have Googled this for a good hour...