I'm with you on this one... at 3 mb a piece...

Yup, here's where to start and be done in 1-2 hours TOPS :

http://www.simple-talk.com/author/gail-shaw/

Gianluca Sartori (10/15/2010)

---

:hehe::hehe::hehe::hehe: This is defintely the case with...

SELECT * FROM (

SELECT 1 AS a UNION ALL

SELECT 2 UNION ALL

SELECT NULL) dt

ORDER BY a DESC

SELECT * FROM (

SELECT 1 AS a UNION ALL

SELECT 2 UNION ALL

SELECT NULL) dt

ORDER...

Because null will be at then end of that sort which seems to be what you want to do.

The question is simply : "In the Pry column, is there any...

Then I would suggest that someone sucks at optimizing :hehe:

I'm glad you got this figured out.

david_wendelken (10/14/2010)

---

Toby Harman (10/13/2010)

---

...

I think we should trust our co-workers in this wonderful game that is IT not to do the stupidest thing that we can think of, and maybe...

Nice read. Always something more to [re]learn I guess :w00t:.

This assumes that both column are not nullable and that patid and facid and indexed in the same index in pat..patients

SELECT

patid + facid

FROM

...

Have you compared with left join query and not exists to see which one works better?

I personnally preffer to use not exists because in my mind it's clearer what the...

I would always add performance testing / tuning as #1 priority beyond "does it work as required?".

That MUST include not breaking anything else that was working before. A good...

Gianluca Sartori (10/13/2010)

---

Ninja's_RGR'us (10/13/2010)

---

Am I reading this right??

SET @RND = (SELECT CAST(RAND() * 60 AS INT))

...

...

Am I reading this right??

SET @RND = (SELECT CAST(RAND() * 60 AS INT))

...

...

I'm sure that's not your final query because I've always had to present this in a calendar form to the final user but that gives you an idea :

create...

Start from a calendar table and filter between start date and end date

Left join that to your "days off" table based on the date only.

Group by date

having count(*) > 1

Now...