...What Gsquared said....:D

Actually...ALMOST what GSquared said....

SELECT

GolferID, t1.CourseID --<--t2 doesn't have courseID, so use either event or t1

, t2.Hole1 - t1.Hole1

...

You need to use the Inserted virtual table to only affect the rows that were just inserted.

as in

[font="Courier New"]

CREATE TRIGGER timetransfer ON db.tbl1

            FOR

INSERT

                AS

    INSERT INTO db..tbl2

    SELECT dispatch_number,stop_number,e_datime,

    CASE WHEN...

yup! Looks like the issue is well in hand...It's one of those...

Gsquared - you're still only converting one branch of the CASE statement.

As in -

select

case

when len(datepart(mm, getdate())) = 1

...

So how does scorecard relate to CoursePar? The table description you posted earlier is apparently not accurate. The error implies that scorecard does NOT have a courseID field.

I'm thinking it has to do with the fact that one branch of your case yields a Char(2), and the other, an integer. In order to remain consistent, the...

Phil Factor also apparently customized one just for here....:

http://extras.sqlservercentral.com/prettifier/prettifier.aspx

Use the IFCodes version (that's how to format stuff for SSC).

Try each of these statements by themselves - which one gives you the error?

select courseID from ScoreCard

or

select courseID from CoursePar

select personID

from mytable

where

(infotype='add1' and infovalue='555')

OR (infotype='City' and infovalue='Edison')

...

gtan018 (4/16/2008)

---

rbarryyoung thank you for your help.

I copied the query statement and received the following error message.

An expression of non-boolean type specified in a context where a condition is expected,...

Derek Dongray (4/16/2008)

---

Matt Miller (4/16/2008)

---

For what it's worth - the update method for forcing order will fall apart with a parallel plan, so don't change the MAXDOP on the test...

Are you talking about this?

select Tot1 - Tot2 as Diff

from

(select sum(field1) Tot1 from Table1) t1

CROSS JOIN

...

Agreed - it's kind of...

SQLZ (4/16/2008)

---

Matt Miller (4/16/2008)

It will help substantially if you are comparing it to not having an index. however, a non-clustered index (covering) could give it a run for its...

If you like "pretty" - make sure to download the Performance Dashboard reports from MS' download site. Has a very nice databases summary report (sizes and more)