Thank you.

This article helped!!

Thanks!

Well, I do not know exactly what the table will be. This will need to a "select into table" defined by which rows are selected from the source table...

The nvarchar change worked. I had not updated the function.

Thanks for the help...

I tried it but same result...

Triple checked everything. Not sure what it was, but I am able to connect now.

Thanks.

I also have sql 2008 installed on that server. I can still connect remotely to it.

The name is e521/R2 and e521 (slq 2008).

Allow remote connections is checked.

TCP/IP, Named Pipes...

Thanks!

Thanks!!

Another attempt at showing the desired display. The .... would be replaced with tabs or spaces.

The resulting delivery table is one row per company.

Site: Company Name

.....Product: Product1

.......Release: 2005

.........Type: Upgrade...

The tabs were lost in the initial message. Here are the statements to create table and test data:

create table regs (

site varchar(100),

product varchar(100),

release varchar(10),

type varchar(10),

cnt int

)

insert into regs...

Thank you.

exec mnsdb.dbo.sp_upodate worked as advertised.

Thank you, I 'filed' both methods.

I appreciate the help.

Thank you oh so much.

Bill

Thanks. I did the dynamic SQL and all went well.

Thanks, again,

Bill