Looks about right, except for the "smileys" that the forum software appears to be adding into our :'d expressions occasionally...

I don't have anything in front of me to check.  But...

>>Have you worked in the SSIS designer in VS05?

Unfortunately somebody else will have to give you advice there, not my area at all.  I'm kind of interested and would...

I just wrote you a *long* reply with examples and this (*&&!!!#@*(& forum lost it... not the first time <sigh>. I'm overseas in a hotel on a borrowed connection, so...

I'm not sure what you mean by "all the tools" and where you're coming from on this. (I imagine other people are in the same boat, reading your message.)  IAC...

I'm not sure exactly what you're doing wrong, but I can tell you that it *is* possible to do what you want to do <s>.

Post your full URL.  It looks...

>>Try using it to grant access to 25 tables to the same user... YUCK !

It would have been nice if there was an option to "apply script" in the...

>> I am having some trouble programming against the web service.

More background would help.

What have you tried, and what didn't work (what results did you expect, and...

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...