No matter which way you do it, we're going to need to know what the primary key for the table is.

Guess I'll have to ask the obvious question... is either (or both) the SELECT and/or the INSERT wrapped in a BEGIN TRANSACTION/COMMIT pair?

Is the ProfileID column an IDENTITY column or not?

Why not have Informix do an export to, say, a comma or tab delimited file and then DTS that bad boy in?

Anders is correct... the reason why you're getting the arithmetic overflow is because SQL Server looks at those types of numeric dates as the number of days since the 1st...

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...