Big problem with table

[pee2002]

ER Model:
http://img22.imageshack.us/img22/7292/modeloer.jpg

I´ve got this:

[IMG]http://img31.imageshack.us/img31/2384/antesj.jpg[/IMG]

And want this:

[IMG]http://img12.imageshack.us/img12/5241/depoispkd.jpg[/IMG]
(Paint image.. lol)

Anyone knows how to build a stored procedure who does that or a view?

Thanks!

[sknake]

Why don't you post the CREATE() table structure with some sample data so we have something to work with.

[pee2002]

I already gave you all the information :(

Please, view the links in the first post.

Regards

[sknake]

You gave me a picture of the database diagram and the results pane. I asked for the create statements. See the second post.

[pee2002]

lol.. The first diagram contains EVERYTHING you should want to know include the CREATE statement.. so see again the first post..

[sknake]

Well you obviously fail to understand my outlook on this. I am not going to take your picture and rewrite your create statements at the expense of my time to help you solve your problem.

I hope you find a solution to your problem. I am unsubscribing from this thread and ignoring future posts on it. Good luck.

[pee2002]

ohh.. THANKS for your precious time on spending more time criticise the obvious thing than helping me..

Guys like u should be baned.. tshhh..

[cgyrob]

Pee,

Sknake is one of the most helpful posters here. He asked simply that you provide him with a create statement and sample data so he can provide you with a thorough solution for your problem.

Everyone here has their own work to do so it is the requester's responsibility to do the grunt work if you need help.