Japie i personally use CLR functions all the time, so it's probably how you are using it in an update, rather than the CLR being a problem all by itself.

can...

well, it seems to me the NTILE() funtion could group your data into groups, but your expected results looks like a simple GROUP BY results.

does something like this help? note...

you cannot...

add a where statement which will explicitly exclude non numeric data;do that for every table that is in your union all.

this , for example would allow integers only.(no decimal)

...AND...

yeah i see that now;

a simple test harness for others to use:

;With MySampleData([Name],[DecimalValue],[NumericValue])

AS

(

SELECT 'Number2_4', 0x14E20100000000000000000000000200, 1234.12 UNION ALL

SELECT 'Number1', 0xCF040000000000000000000000000100, 123.1 UNION ALL

SELECT 'Number5', 0xD9299549000000000000000000000500, 12345.12345 UNION ALL

SELECT 'Number4', 0xF24FBC00000000000000000000000400,...

in other programming situations, I've used a Regular Expression to strip html tags out of a field, leaving just the content; would that be a possibility?

then you could do Field=StripHtml(SomeValue)

Public...

you usually solve this by creating a Tally or Numbers table that has all possilbe values, and then joining that agaisnt your data.

this is doing what you asked for, based...

i prefer to use aliases for my updates, because the format for SQL makes it easy to include a SELECT statement very easily, which lets me do a quick Sanity...

i typically join the table against the insert/target table with a left join

it seems like the unique criteria you are using is the three columns i'm using in the join?...

i'm not sure if this will help, I'd really like to see a handful of sample data rows, and their expected values to really be sure.

but can you convert them...

ahh, i see it now;

objectname is fine for objects, like tables/procs(anything that exists in sys.objects), but you need a different field in the xml data for the database name

CREATE TRIGGER...

you had most of it, it looks like, but you forgot to handle the EVENTDATA() function, which ahs the currently scoped event information

CREATE TRIGGER Prevent_DB_Drop

ON ALL SERVER

FOR DROP_DATABASE

AS...

if it's a single 8 gig table, BCP is going to be a better option.

you'll need to create the table DDL on the Target server(as a new name) Like TableName_Imported...

i did get it working on my own;

If you've installed the 64 bit drivers, and also set these two properties on the drivers:

--Required settings for the provider to work correctly...

on line 7 there's a space inside "Purchasing _v_Line_Item_e" between "Purchasing" and "_v_Line_Item_e", resulting a double alias.

if the tablename has a space, it needs to be bracketed: [Purchasing _v_Line_Item_e]

otherwise...