here's an example i put together for a different post;

it's getting inserted items, putting them into a comma delimited string(because of course the trigger could have multiple rows!)

for your trigger,...

capn.hector (4/6/2012)

---

ok first thing is i would move your conversion factor to your unit table, makes for easier changes with out haveing to make sure you update every conversion factor...

are you storing just the xml in the database, or processing the xml?

if you are processing the xml, don't you stick the data into a Product Sold Table somewhere? then...

also, save the script as a txt / sql file, not a word doc; depending on your settings for autocorrect, some words could get changed from the actual script in...

yeah my dog...

sure, something like this will give you all the spids that are coming from a given hostname...

if i have 8 SSMS windows open, i will have 8 spids, so it's...

looks like you already have it there, Welsh Corgi;

you are using the object_schema_name() function, so just add it to your WHERE staetment :

AND OBJECT_SCHEMA_NAME(ep.major_id) = 'CTL'

great...working as expected

disabling a user...

jshahan (4/5/2012)

---

Thanks much, Lowell. We may have not been aware of how easily this can be accomplished and I'm really glad I asked. I'll run it by my...

just my two cents:

if you've created a CLR assemby on one of your servers, it is trivial to script the assembly as a binary string, which can then be executed...

small world, i'm playing with the exact same thing, and it is working beautifully.

YAddress has posted a nice CLR on codeplex for US addresses , and it hits a free...

ok...help us help you;

what would you like to do to the data? for example, if you KNOW the datetime string is always at the front, and always has the GMT...

then just change the join condition to

ON (target.ITEM = source.ITEM)

AND (target.DESCRIPTION= source.DESCRIPTION)

something like this passes the syntax check:

MERGE INTO dbo.tableA AS Target

USING(

SELECT ITEM, DESCRIPTION FROM dbo.tableB

) AS source

ON (target.ITEM...

just a basic logic error;

a trigger uses the virtual INSERTED and DELETED tables, not the whole table itself.

using the INSERTED table will update only the items that were affected, and...