Sergiy (3/29/2010)

---

It's a bug in SQL Server.

Instead of applying ORDER BY condition to the outcome of OUTER join (as it should be according to...

Java may be free, and a Java Developer may be a career path, but I don't know...

Did somebody say Free Beer?

DUH! f I would have read the title...

Still looking into the "WHY" but remove the Order by from the second query and that gives you the expected results.

I was thinking about that after my post.

One thought is to EXEC the altered script. Then the under the hood actions are View created or altered by application, trigger fires...

Well, I don't have the exact code, but here's a trigger I've used to track...

I still say DDL. You can "catch" the CREATE or ALTER view statement and strip away the WHERE from there before the view gets created/altered.

But that's just my 2 cents

Actually,...

And Psion, don't take my comments ........{edited}........ as attacking.

I/we encourage you to use this site to help in your learning. It can be an invaluable resource, just don't abuse it....

Psion (3/25/2010)

---

Thanks for the quick reply. Even though this query ran without any errors, I need the data to be pulled from my table, Answer. I don't know...

Psion (3/25/2010)

---

I have a table, Answer, with the following columns

ID int PK Identity

Q1 int null,

Q2 int null,

Q3 int null

the data inside the columns range from 1 to 7

example

Answer

---------

Q1 Q2 Q3

---------

1...

A DDL Trigger would be one possible approach.

Matthew Lehn (3/25/2010)

---

Don't use the UPDATETEXT method. I recall people saying they were having trouble with that method. Refer to sample SQL given on page 5 and at http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html for...

Depending on how you want to group....

1. if you want to group all of the 5 o'clocks for an entire timespan together then use:

SELECT DATEPART(hh,'3/23/2010 3:00 PM')

2. if you want...