Thanks PW,

The link to the google search was the confirmation I was looking for.  Not what I hoped to hear, but the results clearly put the question firmly to rest.

Thanks for the...

G'day

As shown, the technical ability to do what you requested is not particularly difficult.  However, with 25+ years of logistics software development behind me, I have to ask: Are you...

Have you considered replication?  Replication has its own set of challenges, but may work in your situation.

Hope this helps

Wayne

hmmmmmm.

Restated, ALL rows in table two are related to ONE of a subset of the rows in table one.  Is there a column on table one that identifies whether or not it...

G'day,

Strictly as a matter of personal preference, I prefer to check first then either update or insert as appropriate.  Why?  Because tyring the update and handling a failure is essentially...

Hello,

Try the following:

declare @TableCreateStr VARCHAR(8000)

SET @TableCreateStr = 'CREATE TABLE TmpTbl (Col1 Int NULL)'

exec (@TableCreateStr)

Your only task now is to read the external file into the variable @TableCreateStr.  I would probably...

Hi there,

If we can make a working assumption that most of the script is identical for both systems, then you might consider the following code snippet.  In my case, I have...

Hi there,

I'm not sure I understand exactly what your table looks like.  Is the blob implemented as a "text" datatype?  If so then you might look in BOL for UPDATETEXT...

G'day,

It will help all of us to provide a better answer if you can simplify the problem to a smaller test case.  Once quick observation I can offer is that...

Thanks John,

I never assume that I know everyting, and sometimes I don't even know anything.  I was looking for confirmation that I wasn't missing something really obvious.  If gurus such...

search around this site.  There are several different variations on a split function.  Here is mine:

CREATE FUNCTION FN_Split (@InDelimitedString varchar(8000),

                          @InDelimiter       varchar(10) )

RETURNS @tblArray TABLE (ElementID  smallint        IDENTITY(1,1),

                         Element    varchar(1000)               ...

If the email you are sending can contain html tags, you can certainly generate those as part of the query.

Just a random thought

/Wayne

Take a look at scope_identity in books online.  It may meet your needs.

"SCOPE_IDENTITY Returns the last IDENTITY value inserted into an IDENTITY column in the same scope. A scope is...

Great idea.  However it was tried and failed. 

The problem constraints are that the solution needs to be implemnted as a UDF, and has to accept an expression such as...

G'day all,

Thanks for all of the suggestions.  Everyone confirmed that there was no easy way to achieve what I was trying with the current versions of Sql Server.  Once we...