General thoughts, not entirely related to one another <s>:

1. Are any of the cells or values null?  I'm thinking (based on some stuff that RS does when assigning XSD data...

Any VB .NET DLL should be able to have a "Settings" file, not just a asp.net application.  They look similar to web.config.

I don't know what environment you're developing in, but...

I forgot the outer CAST back to INT but you knew that, right <G>? Anyway, works fine.

SELECT

   CAST(REPLACE(

OH!!! You said "remove the trailing 0".  If you meant "remove the trailing 0s" why didn't you say so <s>?

Try this:

REPLACE(RTRIM(

Not sure why you would want to do this ... but how about

SELECT CASE @TheNumber % 10

WHEN...

"However"?

I think that is exactly what the poster wanted??

>L<

>>Would you know if SQL Server can generate XML messages and post them to an EAI tool?

It sounds as if you're stuck on the "publishing" side in SQL Server (you...

I think there might be an easier way than adding references to Excel ...

Try something like this: 

x = 37.234

? ABS(INT(x * -1))

(Note: I don't use Access, but couldn't believe...

Hold the phone.

>> is QA using OLE DB provider when connect to DB?

I don't know, somebody else can probably answer this in a second.  I do know that...

Yes, it is interesting, except that I wrote a sproc based on yours with a temp table and it did *not* crash <sigh>.

I just did it again.  Using a different...

>> is QA using OLE DB provider when connect to DB?

I don't know, somebody else can probably answer this in a second.  I do know that QA in Enterprise Mgr...

>>The most common reason I've had to do restrict the number of rows has been when doing operations against millions of records.

Here's another really common one: "paging" data for web...

Sorry, KC, I didn't mean to imply that you should leave out the condition as something that was significant to your issues.  I did it because I didn't have the...

Some additional information for you: this is really starting to bug me <g>, so I decided to try to repro your conditions.

1) Here is my sproc.  It is simpler than...

OK, look, KC, I am *far* from an expert on the subject of cursors, but there are two things I would consider here that might be different when you run...