I believe that is it, Carl. 

Thank you!!

Not sure what you are looking to see, but try these two things in Query Analyzer: 

sp_who -- you can add a user name to this function 'user' to...

When I test a portion of the function: 

SELECT CONVERT( varchar, COALESCE( tb_intl.country_code, '')) + ' ' +

             COALESCE( Countries.country_name, '') + '  ' +

             CONVERT( varchar, COALESCE(...

Agree wholeheartedly with you Steve!  FEMA does push the envelope of the "Health and general welfare" clause...  Federal Gov't re-building is NOT Constitutional! 

Did you know that Gifts to Help...

Glad to help. 

I agree with you AJ.  It is not elegant, (I like bulldozer anyway ), but it is a one time shot and that...

DECLARE @OriginalTable TABLE( COL1 varchar(5),

                                                   COL2 integer,

                                                   COL3 integer)

INSERT INTO @OriginalTable

SELECT 'A', 1, 1          UNION ALL

SELECT 'B', 1, 2          UNION ALL

SELECT 'C', 1, 3         ...

I would recommend using Vladan's approach and add an

IF LEN( @parse_string) = 1

BEGIN

     SET @parse_string = @parse_string + 'h'

END

(or something along those lines). 

I would...

Sounds like an intense CASE statement. 

Why do you only want to UPDATE certain fields rather than the entire record?  (Obviously, the INSERT will take care of itself...). 

@@ERROR changes with each successive action.  Create another @Variable and capture @ERROR for display. 

Excellent!  I have recently gotten a copy to install at home, (I am currently using the free MySQL - so this will be nice to have a real version). 

I...

The easiest way I know of is to use flow control: 

IF EXIST( SELECT PK FROM MyTable)

     UPDATE

ELSE

     INSERT

I have seen postings like this before on this site.  Maybe you could do a search and see if you can find how people resolved it?  There should be multiple...

You got it!  I missed that one as well...

Those two tables "inserted" and "deleted" contain the information about the records that have been changed. 

Try making another Trigger that takes all records from "inserted" and dumps them into...