Yes... short answer would be to use a calendar table to get the smallest non-holiday, non-weekend date that is >= 15 days out.

I swear I've done this problem on this forum before... :hehe:

Dan, in the GIF file example, please tell me why RowID 10 is NOT considered to be a dupe of...

Oh yeah... I forgot to mention that, Matt. Thanks for the reminder,

Shifting gears a bit here... What a PITA.... I hate it when they do stuff like that... In...

You're welcome and thanks for the feedback. Just to be clear, it's a view... not a table. 🙂

I think it's because you've not identified the database where the table is at in your query. Try using a 3 part name for the table in th Query.

Dunno if it is... 🙂

Heh... Why not change to 2k5 or 2k8?

FreeHansje (10/21/2008)

---

Something funny is going on, I have to go deeper into this.

Jeff, the statement is as given in my first post. I get about 13000 1-row-effected messages in my...

See? What a rich man I am to have such good friends as Barry. We've had more darned fun on these forums.

Thanks for the laugh, Barry. 🙂

rbarryyoung (10/20/2008)

---

Jeff Moden (10/20/2008)

---

Heh... which definition of "diatribe" do you mean here? 😛

1 archaic : a prolonged discourse

2: a bitter and abusive speech or writing

3: ironic or satirical criticism

... ...

SELECT * FROM Information_Schema.Columns

Nikhil Shikarkhane (10/20/2008)

---

I dont know what are you using the file for but you can also use sp_send_dbmail to query output into a flatfile

and have it comma separated cause using...

Nicely done, Greg. And, if you want the date/time to change no matter which column is updated, just remove the IF...

CREATE TRIGGER tr_your_trigger_name

ON [YourTable]

FOR INSERT,UPDATE

AS

IF @@ROWCOUNT = 0 RETURN

...

FreeHansje (10/20/2008)

---

I'm not sure how many actual updates have been done, since I get an update result for each individual update; a guestimate makes me believe there are about 13000...

Heh... I'm not a religious man, but what ever happened to following the original 10 laws? They're well written and cover, quite literally, a wealth of sins. 😉