So, when using the export wizard, I need to select the OLE Db provider and not the Native SQLCLient.

Yes, it was wrong for me to include that comment and I apologize.

I didn't think about the provider being the problem, I will take a look at it.

I am running...

case means nothing in this context...

budbeth (12/26/2008)

---

2) The parameters in the first vs...

Thanks guys..

I have another trigger for deleting the ptAppointment records when a ptSchedule record...

I didn't see where you deleted the old ptAppoinment record(s)

In an insert, the scheduleid is changing, in an update,it is not changing

ScheduleID is the primary key for ptSchedule.

ptAppointments primary key: PID + Date + Resource + Site

Here is ptSchedule->ptAppointments...

So, Seth, Jack, how would you rewrite this trigger? I am a rather newbie at them and this one was actually written by someone else that didn't understand them, either....

Yes, I copy/pasted the working code directly from Management Studio.

I would think that if it was trying to reference a SP that didn't exist, the

error would not have been that...

No one knows anything about this?

Steve Jones - Editor (12/16/2008)

---

You aren't joining the two items together.

A CTE behaves as a table. If you have 2, you've defined two tables to use in a query....

Forgot TOP 1

This works...

;WITH PracticeSettings (Category, [Name], [Value])

AS (SELECT Category, [Name], [Value]

FROM coPracticeSettings

WHERE Category =...

But they still exist in coApptResources and I need to show 0 if there are no appointments.

The group by all doesn't return all the rows. Here is the result:

10

26

30

42

50

70

85

945

1014

115

120

130

140

150

160

170

180

190

2014

214

220

And with the code we are currently using:

;WITH PC (ResourceID, RCount)

AS (SELECT ResourceID, COUNT(ScheduleId) AS RCount

...

Lynn Pettis (12/12/2008)

---

I am assuming that you want to drop the criteria of MRN is not null, correct? If so, try the following:

SELECT ResourceID, isnull(COUNT(ScheduleId), 0) AS Count

FROM ptSchedule

WHERE...

DECLARE @MRN1 int

DECLARE @DrID int

SELECT TOP 1 @DrID = c.ID, @MRN1 = MRN

FROM...