Luis Cazares (9/3/2014)

---

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to...

Luis Cazares (9/2/2014)

---

TomThomson (9/2/2014)

---

Sean Lange (9/2/2014)

---

In my experience nearly 95% of the people in...

Sean Lange (9/2/2014)

---

In my experience nearly 95% of the people in this business actually...

Lynn Pettis (9/2/2014)

---

Am I missing something? Doesn't this error mean that the table or view doesn't exist, not that there is a problem with the WHERE clause?

OLE DB provider...

And if you go by RFC 822 you are...

There are cases where every access has to be audited (legal requirement). It's impossible to do this auditing by using triggers, since we don't have ON SELECT triggers....

That requirement would mean that a table can...

Luis Cazares (9/1/2014)

---

Eirikur Eiriksson (9/1/2014)

---

Now he has put the bat aside and instead taken...

michielbijnen (9/1/2014)

---

.... What can I say? I have read it 10 times now and it sounds like THE MASTER is severely correcting one of his students.

Thanks for your reply anyhow!...

I am finding the requirement hard to understand because the results don't appear to match the description, and teh code which you said works refers to columns whci aren't shown...

well, a first step towards that is

SELECT A.LOCATN_K, A.STRT_D, A,XXCHG_OUT_D FROM TBL1 as A...

Eirikur Eiriksson (8/30/2014)

---

sharonsql2013 (8/30/2014)

---

I am trying to do an average with the following case statement

Select

AVG(Case when TotalHours < = 60 And TotalHours > 0 then TotalHours else 0...

Does this do what you need?

SELECT A.LOCATN_K FROM TBL1 as A WHERE not exists (

select 1 from TBL2 as C where

C.LOCATN_K...

Fun question.

Very nice function - easy to read and see what it does and how it does it without the documentation.

That's...