Yea, I guess that's right.

I was hoping I could retire before having to learn...

You might want to consider database mail as a way of sending faxes. You have a lot of flexibility, even passing a query to the senddbmail method. It is very...

Wouldn't an SSIS package require xp_cmdshell to run dtexec?

Thanks for the info. I've been doing this for some time and never thought to kill connections as I'm doing it at 1am. Guess I've been lucky. ...

Keith,

You are correct, it doesn't make a whole lot of sense. This is a vendor system and many secondary case participants stored by their "role". For example, I...

Its a SQL2000 system. Yes, any number of columns or indexes can be added to the temp table. That's what I did in my cursor example so that...

I can do this with a cursor, I just thought there must be a better way.

create table #temp_surg_res(caseid int not null, res varchar(25) not null)

create clustered index ix_caseid on #temp_surg_res(caseid)

insertinto...

Well no wonder I couldn't get it to work, I had it backwards! Your answer works perfectly.

Thanks for all the help.

Doesn't anwser my concerns. Provide sample data showing the beginning state of the data. Sample data for the UPSERT. Then what the data should look like when the UPSERT is...

My table is compiled year-to-date payroll information and is the source for several reports. The cpp column is the pay period. I gave sample data for pay period...

And here's my upsert query where the insert is beating me badly:

declare @cpp int, @ppy int

select@cpp = 9, @ppy = 2010

if exists

(

selectr.cpp, r.ppy, r.cost_center, r.nat_acct, r.emp_number, r.emp_name

fromemp_labor_ytd r join emp_labor_ytd...

Here's a small sample:

CREATE TABLE emp_labor_ytd(

cpp int NOT NULL,

ppy int NOT NULL,

cost_center char(5) NOT NULL,

nat_acct char(3) NOT NULL,

type char(5) NULL ,

emp_number int NOT NULL,

emp_name varchar(50) NOT NULL,

hrs_reg decimal(12,2) NULL CONSTRAINT...

I used to backup log files using append with the Date built into the filename. That way I had one file per day and could programtically figure out the...

That was it! Run the package with the 32 bit dtexec.exe. Thank you very very much.

So it sounds like Client Tools are not cluster aware and got missed when SQL Server was installed on the virtual server. Excellent! Its always better when there's...