Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
attman
Starting Member
16 Posts |
 Posted - 2012-03-24 : 10:09:39
|
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-24 : 12:48:02
|
| Could you explain what you need more? Are you asking for a way to create the table (so a create table script) or a way to get that resultset (so a select query)If you want a select statement, can you post some sample data for the source tables?--Gail ShawSQL Server MVP |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-24 : 21:17:45
|
| you've not specified how tables are related------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
attman
Starting Member
16 Posts |
Posted - 2012-03-27 : 18:20:18
|
| I collect proposals for purchasing jobs. I do not know how are going to create the destination table.that the products of a Procurement, multiple company would offer. How should the database design. I could not. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-27 : 18:56:14
|
| Please explain more what you want, we're guessing and that does not make for good or quick answers.How are the tables related?What exactly do you want?--Gail ShawSQL Server MVP |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2012-03-27 : 20:03:57
|
| Hello OP,It appears you are looking for a "dynamic cross-tab" result.If that is the case, this site contains articles you can search for which demonstrate such techniques.HTH,Have a nice evening. |
|
|
|
|
|
|
How do I make the target table