This is the simplest solution for this. however this is still the wrong method of doing this. There comes a point where laziness doesn't pay up. Create...

Yup, that good old cartesian result .

IIRC = If I remember correctly.

Here is where the person is at the moment he speaks .

A picture of the webpage could be usefull here.

The proc would be very simple :

Insert into dbo.tablename (User_ID, Skill_ID, Skill_Rank) values (@UserId, @SkillId, @SkillRank)

Now you just have to figure...

K. Dinner time is just around the corner here .

Bait is of too low quality this time.

Gay marriage his being legalised as we speak... so it shouldn't be long .

We should all be so lucky .

arhem, WE always rise to the bait dear.

He wants to do it the lazy way >> no create statement... but I know you're right .

This is still useless without the data. I wanna help you but you have to learn to help yourself.

Nice car... goes from Japan to canada widthwise???

how big is the tank?

Why can't you use static sql for this task?

Yes sysobjects is in each db, so the table should be listed in its own database.

I don't think it's possible to have orphaned objects in a db... but we never...

What are you not understanding? This is simple concatenation.

Didn't you run my demo step by step?