as a first step i fixed the loop, used variable for count. I tried before(and failed) and will try again to use row_number, and will also try the load into...

Done and Done, and Thanks

Thank you so much(when i compare my attempts to your reply its sad.), in the future i will include the data...Again thank you for the introduction to XML(and STUFF)...

Thank you very much, and that article is very helpful...may i ask one more bit of advice form you?

select FilemakerID,

STUFF((select ',' + cast(Courseid as varchar(10))

from...

Thanks folks,

i am looking into those things, one thing I noticed is that in the UNION, two like table(different countries) have different clustered indexes, could that effect performance? the...

Thanks folks,

i am looking into those things, one thing I noticed is that in the join, two likes table(different countries) have different indexes, could that effect performance? should the indexes...

Thanks, is there any relevance to the issue of it taking so long as a SP vs running it in QA?

Thanks, Unfortunately this import works with 20+ other imports so they need to be the same.

i was ale to tweak the import code with

cast(duration as char(8) charset utf8)...

really appreciate your help. This code was written 10 years ago....and i am a little new to coding.

SELECT DATEADD(mm, DATEDIFF(mm, 0, CONVERT(DATETIME, '20121130', 112)), 0) MonthStart ) CM

ON calldate >=...

Thank you..

Thank you...

I now need to turn this into a insert statement, calls_key a the primary key and i'm getting a new error on that issue. Can you help on that?

Thank you

SET...

i figured it out...Thank you for your assistance...

Sorry, The EMP table is not on a linked server, it is a SQL table in the Local database..

does that explain the error ' ambiguous column name 'ext'

Very grateful for your input!! thank you.