Ross McMicken (8/13/2010)

---

Grant Fritchey (11/10/2008)

---

Not unless I've missed it to. If the value of a number is -3, it's -3, not 3 with some negative sign kept elsewhere that may...

To the poster who mentioned Excel 2010...please share your observations. We're about to move up to this "because it's there". :/

Good point, we have many table triggers. I'm glad the vendor took ownership of this.

Thanks!

The software vendor supplied a fixed version of their SP, which runs from my calling SP. The moral of the story is if it runs by itself, that's no guarantee...

Thank you for your suggestion. I ran it from SSMS like this - is that what you intended me to do?

Begin Transaction

--exec MyCallingProcName @Param ="Whatever"

EXEC [dbo].[MyCallingProcName]

ABCD, --@Whse ...

Have you

This is something I probably need to learn how to do! I've never used (never had to use) transactions.

Here's...

Thank you for your interest!

Yes, I can execute it from SSMS, provide parameters, and get data back. I can also run it from the application form using the same parms...

It does, but I don't know if I'm legally allowed to post the code. It's part of a big system we "Purchased" but we don't "own" the code and can't...

I think the rules of the game are changing so fast that our current plans may be meaningless in a scenario where IT is no longer an employment opportunity. If...

I think these politicians are so uninformed about the details of the issues that they depend on staff to summarize the information for them. That leaves the window open for...

Same here. I was a nurse aide in college,...

I looked in the place in Excel you suggested to find where Excel is storing connections.

C:\Program Files\Common Files\ODBC\Data Sources

There I find dsn files that I can't edit. One of...

Eric, I just went back and re-read that post of yours. The day you posted it, it was totally over my head. Today, I get it. So I searched my...

I got it working, thanks!

Funny thing, in the previous spreadsheet that I created and blew past the place where you indicate where teh input values for the parms should...

This...