We ARE using SharePoint (SP) lists, but what we are trying to do is fire off a SSIS package from a stored procedure that will post an html document to...

No, not yet. We've been focusing on other things. However, I will probably get back to it this week. I'm going to try dropping all the indexed views then updating...

No computed columns.

Yes, indexed views.

Everything has worked fine (with our entire load/update process) until this one single value fell into the specified range. The other fields with MONEY data types...

David, yes I just dropped the .0000 for convenience sake. Both columns (source and destination) are MONEY data types. All values above and below do not throw an error.

Oh,...

.5. WayneS, love the avatar. LOL!!!

1. Yes, I can do math on it in a SELECT statement. But, if I try to do an update using math putting the value...

Update:

1. I disabled the trigger then ran the UPDATE statement, same error.

2. I also ran a SELECT CONVERT(VARCHAR(1000), Total_Loan_Amount) FROM Master_Bidder_Listing for that record and didn't get an error.

3....

Here's the abbreviated DDL for the tables:

1.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Master_Bidder_Listing](

[Cert] [int] NOT NULL,

[Total_Deposit_Amount] [money] NULL,

[Total_Loan_Amount] [money] NULL,

[Consolidated_Asset_Amount] [money] NULL,

[Total_Asset_Amount] [money] NULL,

CONSTRAINT [Master_Bidder_Listing$Cert] PRIMARY...

I knew there was a reason why I love SSC so much. Thanks PSA for the code, and thanks Steve for the advice.

We don't have the mail client hooked up to this server, that's why I'm having to use a VB Script.

PaVeRa22, your example worked perfectly. This is a whole new world....

I've never done this before. I currently have a .vbs file I'd like to run at the end of a SSIS package. Do I just drag an ActiveX Script Task...

I'd like to hear some feedback from robblot (the original poster) and see A) what is he actually trying to do? and B) what did he decide to go with...

I respect all of your views about keys, indexes and the like. It's great to hear different views on the same topics and let my mind try to wrap around...

Tim: I know the setup/environment is strange, I'm not part of an IT team, but I am pretty fluent in SQLServer2005. I'm more of an IS guy. I'm not a...

No, I've never seen/heard that before. But my best guess would be that it was machine specific since you can print it on different machines, but I'm sure you've already...

Tim - I was using WITH (KEEPIDENTITY) on my INSERT INTO statement after my TRUNCATE to keep my keys.

Lynn - in my current environment, I don't have access to...