Vicki Peters (4/17/2008)

---

SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)

I actually had coded that way initially, to just bring back the first day of the month. But the problem I'm having is...

Are they reporting performance issues? If so - what?

what is the usage pattern for the table? inserts vs updates vs deletes?

how do they mostly pull data? are...

Already answered over here:

http://www.sqlservercentral.com/Forums/Topic486502-8-1.aspx#bm486513

It might be better to send excel the date itself, and let it display it whichever way it likes. If you want to group things together by month, then...

It is a shame that they're all centralized up in Redmond. I can kind of understand why, but still - it seems like it could use having multiple dev...

Well - whichever way you decide to go - it sounds like you should hang on to this thread in case something changes. Given that each method seems to...

Given that a common mantra in SQL Server you might hear is "physical order has no meaning during inserts", I'm not sure that you will EVER be able to maintain...

Ben Sullins (4/16/2008)

---

Can you post an example of where that works? The example Tung provided produces the following error for me...

SET NOCOUNT...

Quick ruling here - do middle managers who...

Primary key violation means that you are trying to insert duplicates of existing values already in table1 (or that table2 has multiple instances of the same field1/field2 combination).

Are you SURE...

With all due respect - it seems that you can. It certainly works for me...

You have to use the grouping scope parameters.

Assuming your grouping looks like:

GroupA

Group B

...

Correct. For all intents and purposes - it exists only within the confines of that create trigger statement.

Inserted (the new values) and deleted (the old values) are "virtual...

wait a second.... The ON clause must link a field from one table to a field from the OTHER table, not to itself (that wouldn't do anything...).

The ON clause...

Every place you see T2.courseID, replace with T1.courseID (there's a second one in the ON clause)....