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 |
|
raginbullsht
Starting Member
8 Posts |
 Posted - 2015-02-22 : 13:21:56
|
| I have a single table that will need to contain the followingeach row in the table unique and it will specify a pipe and is the pkthis one pipe will be cleaned multiple times (10) a year and each inspection consists of the followinggallons usedfootage cleaneddate cleanedmy thoughts are for the table to look likepipe1 - clean1 - footage1 - date1 - clean2 - footage2 - date2 etcpipe2 - clean1 - footage1 - date1 - clean2 - footage2 - date2 etcpipe3 - clean1 - footage1 - date1 - clean2 - footage2 - date2 etcthe difficult part is that this cannot have joins, it must all be in one table and be able to query the data on a per month basis, or date range** this is a ArcGIS sde database to be put onto arcgis online, this is the reason for not having joins |
|
|
|
|
|
Design questions