Dunno... If faced with such a problem, I'd have the spreadsheet do a transpose and write to a text file for me... then, I'd import the text file using Bulk...

Um.... let me get this straight... you say the delete job is scheduled to run once every minute and that everytime someone logs in to the app, it creates a...

Hey Robert!

Man, I just tried your fnStripTags function and I converted it to use a Tally table and tested both... I'm very well impressed!  In this case, the WHILE loop...

I'm thinking "structural artifact" myself.  If the FILL FACTOR isn't set to 100, I could see where an index on a small table could out strip the size of the...

How many indexes does the table have, Farrell?

Yep... like maybe to send an email to notify of a zero rows situation or maybe just log that nothing happened... hadn't thought about that before.

(Not sure what happened to the post you responded to)

Yep... I could be wrong... please post your function and your test code some I might do some testing... I will,...

Lee,

Lynn is absolutely spot on... the only thing is that the necessary cross join will spawn a huge number of interim rows even if you add a DISTINCT to the...

... 'course, if you have a Tally table, you don't even need a function (although they are convenient)... included the original data for convenience...

Create Table TableA (ID varchar(2), Nodes...

Heh... looks like you've been bitten before, eh Juan? 

So far as the ANSI_NULLs thing goes, the default setting, when you create an SQL Server instance, is ON.  Unless someone...

Cool... Thanks for the info, Robert.  I never tested to see if a trigger fired on a zero row insert... they way I write most of my triggers, it probably...

Guess you were the straw that broke the proverbial Camel's back this morning... have been fighting with some really stupid requirements written by some really stupid System's Analysts for one...

Horse feathers... asking "WHY" is very often the key to understanding the problem well enough to help you do what you need.

Since I can't ask "WHY" you want to do...

Yep, I agree with Serqiy about the denormalized thing... this is the wrong kind of update... and, if doing the concatenation in SELECTs turns out to be a chore, just add...