Ronald San Juan (10/15/2007)

---

Yep... as I said, no need for the trigger.

Also, if I get it correctly, there may also be no need for the EmailOut table. The EmailOut Table...

SECOND, when is the trigger fired? On every update. But look closely, Sergiy. The email sending part filters

BINGO Ronald. The table actually has around 25 columns, but I...

I think that is where I am heading Sergiy. Instead of populating the temp table in the trigger I will only use the trigger to populate a permanent queue...

Thanks again Lowell. That is a lot to chew on, especially for my home pc and SQL express. I will have to wait until I get back to...

Thanks everyone for the suggestions. Lowell, I think I can wrap my head around what you are suggesting. I guess I had reservations about making a table just...

You could also try something like this

INSERT INTO Upload

SELECT

t1.first_name,

t1.last_name,

t1.people_code_id

FROM

...

Thanks Jeff, that's good stuff there.

Personally I think the easiest way is to save the excel file as a tab delimited .txt file somewhere on your server. Then use BCP with a format file...

How long does it take without the indexes?

Jeff, I kind of remember that one from...

Just a thought...If that works for you, and assuming there is some kind of identity field on dbo.Resources, then using a derived table for building the date might make it...

Matt, that is quite a simple and nifty trick, thank you. There needs to be one more ) at the end though.

I think you are going to get into a situation where you have way too many variables than are user friendly. Trying to keep track of what variable corresponds...

Mitch, keep in mind that Access puts its own spin on things. You can not always necessarily copy and paste SQL from Access into QA, or vice versa.

Megan, two things to note here. First, I am pretty sure you will have to convert to date format to use between in the where clause, unless you...