ouch...without dynamic sql, and still trying to do it in SQL and not a programming language, I don't know how you'd be able to do it.

the headache is the max()...

4194840 = TORN_PAGE_DETECTION,OFFLINE,AUTOSHRINK

528 = TORN_PAGE_DETECTION,OFFLINE

my script from page one helps find the values, here's a snippet where i just plug in specific values:

declare @status...

jacob hit the nail on the head; chances are , if you can post the trigger here, we can show you how to re-write it so it handles multiple rows...

I've only got the Express Edition, but the logic to get the data out should be easily adaptible.

you want to use a CASE statemnt for each of the variables; "&",...

like Glen said, changing the Server collation does not affect any databases, nor the individual columns that exist int he database...you need to handle those seperately.

Server collation...

each database collation...

Each column...

found this specific citation; 2005 and 2008 have the same maxes for this

http://msdn.microsoft.com/en-us/library/ms143432.aspx

SQL Server Database Engine object ...

doh i didn't even see that CR might mean Carriage Return Line Feed...goodjob...

Like Hanshi said, you might want something like

REPLACE(TblC2.strAddr,'~~',CHAR(13) + CHAR(10)) as your expression

are you looking fto simply REPLACE of ~~ with CR? or is it more complex than that?

SELECT TblC1.Client AS Expr1, REPLACE(TblC2.strAddr,'~~','CR') AS Expr2

FROM ...

it depends on what you want to do, of course....say that if it's 7 characters, do you you do anything at all? do you only strip off the first character,...

the issue you are running into is the account SQL server is running under is not an account that has access to teh network. jobs run under the security context...

a combination of using substring and a where statement will do the job; you might need to tweak the WHERE statemtn...are you sure it's only items that are exactly 8...

i think the update is this:

UPDATE TableA

SET TableA.[Cap Code] = TableB.CapCode

FROM TableB

WHERE (((TableB.CapCode) Is Null) AND ((TableB.FromDate)

Between [Effect Date] And [Term Date]))

OR (((TableB.CapCode) Is...

your too fast for me...once a path gets too many levels deep, i like screenshots too.

yep it sure does: Tools>>Options

avoid doing anything in a trigger not realted DIRECTLY to the data...an activex object could cause the trigger to rollback, or lock the table as the trigger waits for the...