steveb (11/13/2008)

---

I also have to solve a lot of problems with our out-sourced projects and it shows that out-sourcing may seem like a cheaper option but can end up costing...

Jim Russell (11/13/2008)

---

You are right as usual, Jeff. I was mainly thinking of the cases where a CTE is referenced multiple times, and had always assumed that the results...

Bob Hovious (11/13/2008)

---

Doh! :w00t:

I knew there had to be a better way. What I really like about this approach is that you could use...

Thanks for the feedback. 🙂

Lynn Pettis (11/12/2008)

---

Jeff Moden (11/11/2008)

---

Lynn Pettis (11/11/2008)

---

Jeff Moden (11/11/2008)

---

Oh my... I just remembered where the heck such a requirement for all positive numbers may have come from... PeopleSoft software. ...

Oh dear... I blew it... :blush: I normally try to write in a gender-agnostic fashion especially when I don't really know someone. My appologies. Perhaps a first...

I don't know for sure, but I don't believe so. VM has come a long way from it's inception.

So far as fast recovery of databases go, some SAN types...

doss.tychicus (11/10/2008)

---

I'm trying to get the data from the table

between two dates and for the List of Doctors

select * from tbl_test

where convert(char(10),createdate,121) between '2008-01-01'

and '2008-12-31' and id_doctor in (1,2,3,4,5)

I...

krayknot (11/10/2008)

---

doss.tychicus (11/10/2008)

---

I'm trying to get the data from the table

between two dates and for the List of Doctors

select * from tbl_test

where convert(char(10),createdate,121) between '2008-01-01'

and '2008-12-31' and id_doctor in...

Pretty nice, Gaby... your article and some of the comments above gave me a couple of ideas for an article with just a pot-wad of tricks in it... Ok if...

Oh, be careful, Jim... while I'll admit to using...

prabhu.rangan (11/12/2008)

---

Hi Members,

I have two tables named 'result' and 'status' for which i have 'status_key_id' in my result table with default 'null'. I have to update the 'key_id' of 'status'...

... thanks for the leg up, Lynn. 😛

If you put all your stuff to create the result set in a temp table with no other output, not even rowcounts, and do a final SELECT from the TempTable...

I can't go. I've got tickets and everything but something came up today and I can't go. :crying: Somebody take pictures for me.