Thank you for the suggestion, however, nothing (i.e. the rest of the procedure) is processed after the OPENQUERY error so I would not get to the xp_logevent. I had even...

Fixed the problem. I was adding 'from stringtest' to the end of the select. The functions are successful if I only use 'select dbo.fn_pes_CONCAT1(8)' and do not add 'from stringtest'.

I...

Hi,

I got both versions working but each one gives me back multiple rows not just one. Here's what I have:

(can it be made to vary the column and table?)

/*

create function...

Thank you for the clear example. I should have no problems and I can try it out later today. I too am curious to see the performance of cursors. If...

bobjbain that sounds perfect. I only need to pass key XX since all tables and their related rows have XX. If a row in Table C has key XX then...

Thank you bobjbain. I will have to go the extra steps with John because I really do want one row. Now that the structure of the database is changing one-to-many...

Hi John,

Okay, but I have been working late and I'm going home now. I will post something from home. I may decide to shorten the number of columns being gathered

Warm...

Hi,

Here is the current stuff with the tables B and C (Payroll and PayrollShipping) commented out and the data (all strings) I used to get from them now sends NULL...

Jeff, as far as the code possibly having been used for verification I was lead to understand that the procedure sent output to a report and that the report only...

Thanks Ryan and Jeff, without the output from the procedure I guess I just couldn't wrap my head around the concept that a working procedure was doing something kind of...

Thank you B and everyone for your posts.

Thank you B, your post will be used as a starting point for me to learn more about the system tables.

Warm regards

Hi and thank you ALZDBA,

So that's what I kinda figure - one match and I'm done

Ok, it will be written with cursors then.

NEW QUESTION:

One question regarding CURSORS, in the line...

Hi Jeff,

Thank you for your most recent comment. Even as a newbie I will have to trust my own instincts, the method of dropping and renaming was an idea I...

Hi Ian,

Thank you for your interest. There is a previous post by me that contains the real sequence. If you have time and interest you will find that the openquery()...

Hi Jeff,

I looked up SET XACT_ABORT and I don't believe it would help me achieve my goal.

Being new to SQL my original post was a question (see below). I suggested...