Open a connection to the server, fetch the data and do whatever you have to do to it.

Check http://www.Connectionstrings.com

BTW I haven't found anything that is NOT possible to...

Can't answer this one... But it's not something I've been able to do with Access ADPS (sql server back end). I'll see what I can dig up tomorrow (pls...

This is not an actual column in the database, and therefore cannot be updated in the db.

update C set C.status = I.status from inserted I inner join CacheTable C where C.machineid = I.Machineid

This will handle any number of rows, and will also update as little rows...

Looks like you're gonna have to go with the jobs option. Because there's no way to have them added automatically, unless again, you save a default script and then...

BTW I agree that it would be faster to convert the right part of the expression to the column's type. But if I remember correctly, the server has the...

Is there a reason that this number is kept as a (var)char(9)?

I know that there must be some ssn that start with a 0, but it's still easy to correct...

Text is just a longuer version of Varchar... the only question is the max expected size of the data, on which we have no information. So this is effectivly...

This is way more complexe than I expected... Will talk to you again on Monday (when I have access to a server).

Are you sure this is related to this post?

That's exactly why I didn't want him to pen 5 threads for this problem.

IIRC, he wanted to be able to show the print messages (probabely for debuging) client side, in...

Do you have text columns (just a hunch)?

Can you describe what's this supposed to do...

I'll check your answer before I got to bed (6-7 hours)

That's why I was using max(Right(id, 2)) in a new column

Then you can reconcatenate it further down the lane .

But that's just a...

Send her in .