Wow! Great discussion, everyone! I chose to write a couple of stored procedures because replication was not an option and would not meet my needs. "Crazy Eights"...

To Jeff's question as to why...

The purpose of the stored procedure is to generate a script to functionally copy table content between databases within the same instance. This is...

Your postings helped, and mission accomplished. Turns out my syntax on the assignment was incorrect. I was trying to do this:

set @li_selected_row_nbr...

To SSC Rookie -

Thank you! Worked beautifully. I tought dynamic SQL, last night, would be my solution. That syntax is screwy - definitely a SQL Server...

First of all, my thanks to those who have tried to help. But my problem is a bit nastier than the replys have helped for. My stored procedure...

(Heh heh heh :o))

Apologies for the lack of clarity - you know, so close to the forest that ya can't see the trees....

I guess I have a few 'how to'...