I wouldn't worry as much about values to the right of the decimal, it should round in. It's the ones to the left that'll cause the error. Somehow...

idea 1: Does the proc return multiple rows when the report does?

Need to see the proc code for any others.

Run a WHERE LEN(col) > 4 against the one you're converting to Numeric(4,2). If you don't find anything, Try WHERE CHARINDEX( '.', col) > 3, to see if you...

MyStoredProc(

@SearchContains VARCHAR(20)=NULL,

@SearchStartsWith VARCHAR(20)=NULL)

NOTE: Field 'OrderName' is a VARCHAR field

SELECT OrderID, OrderName, OrderValue FROM <table>

WHERE OrderName like '%' + @SearchContains + '%'

or

SELECT OrderID, OrderName FROM <table>

WHERE OrderName like @SearchStartsWith...

Where, or how, in this proc is the user actually going to be able to respond to 'liking' the new calculated value?

Transactions that require a user-initiated action to continue to...

Yeah, that link above walks you through that as the first step. My...

Off a couple of google hits I briefly checked before deciding this one seemed sound:

SSIS: http://www.mssqltips.com/tutorial.asp?tutorial=200

Linked Servers: I'd recommend just using Books Online. They're not that...

You're on the right track in both cases. For non real time/overnight updates, you'd build an SSIS job and then schedule it with SQL Agent.

If you need real-time access,...

Well, the inner joins are limiting the results. There are custnmbr/docnumber combos existing in RM20101 that aren't in CN20100, and noteindx in RM20101 that don't exist in CN00300.

My first...

bkmooney (9/2/2010)

---

That helped clarify things - and I think I really only need to be working with a full backup (which can be stored offsite on a portable HD), and...

SELECT SUBSTRING( @field, CHARINDEX( '~', @field)+1, LEN( @Field) - CHARINDEX('~', @field, charindex('~', @field)+1) -1)

Quite possible. Here's the rule:

If you remove the alias in the FROM clause (it looks like [Sheet$1] AS xl or just [Sheet$1] xl) then you need to reference the...

WHERE T.Value > 0 OR T.Value IS NULL

Or:

WHERE ISNULL( T.Value, 1) > 0

Near the end:

WHERE TestTable.ID IS NULL;

Should be:

WHERE survey.ID IS NULL;

Heh, just borrow Wayne's Avatar?