Lynn Pettis (3/30/2009)

---

You know,...

Why don't you tell us what features you already have. And also tell us what your architecture and design is. Then I am sure that we can answer...

Nice example, JohnG. Mind if I quote it in my Blog sometime?

swmsan (3/31/2009)

---

Now in my report i need to find total blood tests done by the doctors

Select Doctor_ID, Patient_ID, Count(*) as [Count]

From Table1 as t1

Inner Join Table2 as t2...

Like this:

Select Doctor_ID, Patient_ID, Count(*) as [Count]

From Table1 as t1

Inner Join Table2 as t2 ON t1.Doctor_ID = t2.Doctor_ID

And t1.Patient_ID = t2.Patient_ID

Where t2.Diabetes = 'No'

...

Tony Davis (3/30/2009)

---

Don't worry, Jeff. I'll offer you as much help as...

Hey, Lynn got to use HAVING! Wohoo! 😛

I think that we ought to award a prize anytime someone gets to use HAVING legitimately. 😀

I think that you just need to install Jet. Check Microsoft, there should be a free download & install.

I can't see the procedure from here. Could you please show it to us?

justanewone (3/30/2009)

---

Hi All,

I have been asked to generate some code which will produce a list of employee activity by day and create a rota from it... Please bear in mind...

OK, this is straight from Remus Rusanu himself:

You must enable broker before the mirroring session is enabled. You should

first check if the broker is enabled in the first place

(sys.databases.is_broker_enabled). If...

Lutz: XML datatype is SQL Server 2005. You'll need to use OPENXML instead.

Agreed. I am in the process of switching over to it myself...

longobardia (3/30/2009)

---

To prevent dupes also you could wrap your insert in "if not exists" t-sql statement with Begin/End.

ie:

if not exists ( select * from xxxx where stageid = @stageID and...

Here's what I have so far that works:

[ code ] for SQL,

[ code="csharp" ] for C#

[ code="vb" ] for VB.net

[ code="xml" ] for XML

bit i still have to use "&...