Just my 2 cents.. I wouldn't even want the interview if that's what you're basing you search on.

Search this site if you want pointers for interview questions.

I would assume that PK and FK relate to each other in this case .

Now that's a strech .

Well I can hide the cursor and the while from this but I'm not sure that the performance would be any better. I however can't get out of the...

Can't wait to see the solution to this one .

Update A set A.Col = 'WhatEver' from TableA A inner join TableB B on A.Pkid = B.Fkid

Did you try it???

yes you can.

How many got the job with this question???????

Check the books online. It's really like "if/else" but with a mix of "select case" .

The only time I saw this be an issue is that we are required by law to have a sequential number for our work orders reports (without missing ids). ...

You'd need dynamic sql to create the pivot script... ask Noeld for this, he's much more expert than I am for that type of query, but he's at pass right...

almost had an heart attack...

please AVOID cursors if possible!!!!!!!!

Ya that should do it... but I rarely saw a system where the tables HAD TO be separated. Can we hear the reason behind this split?

Happy to have almost helped . Donald did the job mostly all be himself...

Can we see the code of the sp please?