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 |
|
SamuelT
Starting Member
6 Posts |
 Posted - 2007-08-14 : 09:38:09
|
| Hi all,This follows on from a query I had a few days back (and for which I was promptly flamed! However, I've got skin like a rhinoseros, so here goes...)I have a table - ProjectSite - that is pulling information from a two tables (Project and Site). This table contains data regarding which sites are part of which project.I now want a means of reporting dates against this. The problem is that each project has bespoke milestone dates, so I can't just create columns in ProjectSite. The only solution I can see is to pull each project (and there's quite a few and its corresponding sites into a new table) and then I can create my bespoke columns.Does this sound like the best viable option, or can anyone suggest another means of doing this?TIA,SamuelT |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-14 : 10:17:45
|
| post some data your table structure and some scripts to create the tables and inserts in the tablesand the result you are looking for. this will help others help uAshley Rhodes |
 |
|
|
|
|
|
Table Options