woohoo! I won!!!!! 😀

:cool::w00t:;):P:D:):hehe:

Just kidding around. It's good to have to defend your positions from time to time: makes you have to remember why you now assume a...

If it were simply a matter of "more elegant" - I wouldn't even argue. I'm however talking performance. It saves you a scan of the table altogether. ...

I think your key is - it's not exporting assuming Excel 2007. From what i remember - the documentation stated "for export into Excel 2000 or later" - meaning,...

meaning:

insert into dbo.PayerContracts (PUID, ContractID, PyrContractUID,

...

Just skip mentioning the timestamp column in both the INSERT and the embedded OPENQUERY. I'm thinking that will fix the issue.

I had to do a double-take on that one as well. If...

Fair enough. It took me a little staring at it to see an issue and make a guess that that was it.

glad I "got it right"....

antonio.collins (3/11/2008)

---

i see you point, but the script that performs the action can collect the contents of inserted/deleted by "select ... from ... where {criteria used to perform the action}"...

From some testing - looks like yes. even using a varchar(8000) vs varchar(max) shows some rather marked differences.

Or - you could just read the results from sp_helpdb....

antonio.collins (3/11/2008)

---

ah... DEFAULT VALUES. i figured there had to be some way to do it, but never had the need before so i was unaware.

however, why use...

I wasn't very specific before. You need to move the

rollback tran a1

to be your first statement in the catch. everything prior to that is part of Tran a1,...

My first question would be - how are you sure that the second catch is firing?

According to the way you've got it written, the second TRY/CATCH express is enclosed inside...

Bob Fazio (3/11/2008)

---

Huh? This is a pretty big thread. What are you answering?

If you are saying that if your table is...

In order to get the days you want, even days with no data, you'd have to join your sales data to a dates table. Meaning a table with an...