Viewing 15 posts - 586 through 600 (of 621 total)
Ronald San Juan (10/15/2007)
Also, if I get it correctly, there may also be no need for the EmailOut table. The EmailOut Table...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 16, 2007 at 9:16 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 15, 2007 at 9:29 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 15, 2007 at 7:26 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 15, 2007 at 7:19 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 15, 2007 at 6:34 pm
You could also try something like this
INSERT INTO Upload
SELECT
t1.first_name,
t1.last_name,
t1.people_code_id
FROM
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 12, 2007 at 9:25 am
Thanks Jeff, that's good stuff there.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 12, 2007 at 8:53 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 11, 2007 at 12:47 pm
How long does it take without the indexes?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 11, 2007 at 11:54 am
Jeff Moden (9/27/2007)
... I've got a nasty fast "find missing ID's" script that gives the missing numbers as ranges rather than individual numbers....
Jeff, I kind of remember that one from...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 11, 2007 at 11:34 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 10, 2007 at 1:03 pm
Matt, that is quite a simple and nifty trick, thank you. There needs to be one more ) at the end though.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 10, 2007 at 11:07 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 10, 2007 at 10:34 am
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.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 10, 2007 at 9:51 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 10, 2007 at 9:46 am
Viewing 15 posts - 586 through 600 (of 621 total)