Click here to Skip to main content
11,570,906 members (51,792 online)
   

Database

 
GeneralRe: SQL Group By Question Pin
loyal ginger31-Dec-12 5:48
memberloyal ginger31-Dec-12 5:48 
QuestionIssues installing ODP.NETx64 Pin
cpp_prgmer6-Dec-12 4:18
membercpp_prgmer6-Dec-12 4:18 
AnswerRe: Issues installing ODP.NETx64 Pin
Eddy Vluggen6-Dec-12 14:37
memberEddy Vluggen6-Dec-12 14:37 
GeneralRe: Issues installing ODP.NETx64 Pin
Peter_in_27806-Dec-12 15:12
memberPeter_in_27806-Dec-12 15:12 
GeneralRe: Issues installing ODP.NETx64 Pin
Mycroft Holmes6-Dec-12 16:52
memberMycroft Holmes6-Dec-12 16:52 
AnswerRe: Issues installing ODP.NETx64 Pin
Mycroft Holmes6-Dec-12 16:53
memberMycroft Holmes6-Dec-12 16:53 
QuestionSQL Query - append results Pin
AndreFratelli5-Dec-12 6:43
memberAndreFratelli5-Dec-12 6:43 
AnswerRe: SQL Query - append results Pin
Chris Meech5-Dec-12 6:55
memberChris Meech5-Dec-12 6:55 
GeneralRe: SQL Query - append results Pin
AndreFratelli5-Dec-12 7:08
memberAndreFratelli5-Dec-12 7:08 
QuestionSQL 2008 Data Base Table Design suggestion Pin
VishwaKL4-Dec-12 23:36
memberVishwaKL4-Dec-12 23:36 
AnswerRe: SQL 2008 Data Base Table Design suggestion Pin
Simon_Whale4-Dec-12 23:43
memberSimon_Whale4-Dec-12 23:43 
GeneralRe: SQL 2008 Data Base Table Design suggestion Pin
VishwaKL4-Dec-12 23:47
memberVishwaKL4-Dec-12 23:47 
GeneralRe: SQL 2008 Data Base Table Design suggestion Pin
Simon_Whale4-Dec-12 23:51
memberSimon_Whale4-Dec-12 23:51 
AnswerRe: SQL 2008 Data Base Table Design suggestion Pin
PIEBALDconsult5-Dec-12 3:56
memberPIEBALDconsult5-Dec-12 3:56 
Your description isn't clear enough, so here's a design that could be used for some interpretations of what you wrote.

0) There are several sites.
1) A check list has several check list items.
2) Each site has a check list with a subset of all available check list items.
3) Each check list item may be on several sites' check lists.

This is a classic many-to-many relationship and the typical implementation is to have (at least) three tables:

Site: ID, Name, etc.
Item: ID, Name, etc.
SiteList: SiteID, ItemID (usually no other data here, but maybe in some cases)

Another schema would allow for defining lists and assigning them to sites:

Site: ID, Name, etc.
Item: ID, Name, etc.
List: ID, Name, etc.
ListItem: ListID, ItemID (usually no other data here, but maybe in some cases)
SiteList: SiteID, ListID (usually no other data here, but maybe in some cases)

This second way may be approriate for your needs, you can define a common list and custom lists and assign multiple lists to the sites. Getting a complete list of all items for a site is simple as well.
Question[HELP] how to using array in my case? (Query & PHP) Pin
jimmy.suharry4-Dec-12 20:14
memberjimmy.suharry4-Dec-12 20:14 
AnswerRe: [HELP] how to using array in my case? (Query & PHP) Pin
Mycroft Holmes4-Dec-12 20:38
memberMycroft Holmes4-Dec-12 20:38 
GeneralRe: [HELP] how to using array in my case? (Query & PHP) Pin
jimmy.suharry4-Dec-12 20:56
memberjimmy.suharry4-Dec-12 20:56 
QuestionSQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 3:09
memberAnirbanM 23-Dec-12 3:09 
AnswerRe: SQL query Date Sort Problem Pin
ihoecken3-Dec-12 4:42
memberihoecken3-Dec-12 4:42 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 18:46
memberAnirbanM 23-Dec-12 18:46 
AnswerRe: SQL query Date Sort Problem Pin
Eddy Vluggen3-Dec-12 5:20
memberEddy Vluggen3-Dec-12 5:20 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 18:48
memberAnirbanM 23-Dec-12 18:48 
GeneralRe: SQL query Date Sort Problem Pin
Eddy Vluggen3-Dec-12 23:00
memberEddy Vluggen3-Dec-12 23:00 
AnswerRe: SQL query Date Sort Problem Pin
djj553-Dec-12 5:46
memberdjj553-Dec-12 5:46 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:12
memberAnirbanM 23-Dec-12 19:12 
AnswerRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 8:50
memberPIEBALDconsult3-Dec-12 8:50 
GeneralRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 13:12
memberMycroft Holmes3-Dec-12 13:12 
GeneralRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 13:18
memberPIEBALDconsult3-Dec-12 13:18 
GeneralRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 16:18
memberMycroft Holmes3-Dec-12 16:18 
GeneralRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 17:29
memberPIEBALDconsult3-Dec-12 17:29 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 18:57
memberAnirbanM 23-Dec-12 18:57 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 18:52
memberAnirbanM 23-Dec-12 18:52 
AnswerRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 16:24
memberMycroft Holmes3-Dec-12 16:24 
GeneralRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 17:28
memberPIEBALDconsult3-Dec-12 17:28 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:07
memberAnirbanM 23-Dec-12 19:07 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:10
memberAnirbanM 23-Dec-12 19:10 
GeneralRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 19:48
memberMycroft Holmes3-Dec-12 19:48 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 24-Dec-12 2:12
memberAnirbanM 24-Dec-12 2:12 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 24-Dec-12 2:30
memberAnirbanM 24-Dec-12 2:30 
GeneralRe: SQL query Date Sort Problem Pin
Eddy Vluggen4-Dec-12 3:12
memberEddy Vluggen4-Dec-12 3:12 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 24-Dec-12 3:27
memberAnirbanM 24-Dec-12 3:27 
GeneralRe: SQL query Date Sort Problem Pin
Eddy Vluggen4-Dec-12 4:44
memberEddy Vluggen4-Dec-12 4:44 
AnswerRe: SQL query Date Sort Problem Pin
Michael Potter4-Dec-12 8:11
memberMichael Potter4-Dec-12 8:11 
AnswerRe: SQL query Date Sort Problem Pin
jschell4-Dec-12 8:23
memberjschell4-Dec-12 8:23 
Questionoltp vs olap Pin
a.fatemeh2-Dec-12 10:51
membera.fatemeh2-Dec-12 10:51 
AnswerRe: oltp vs olap Pin
Mycroft Holmes2-Dec-12 11:49
memberMycroft Holmes2-Dec-12 11:49 
GeneralRe: oltp vs olap Pin
a.fatemeh2-Dec-12 11:57
membera.fatemeh2-Dec-12 11:57 
GeneralRe: oltp vs olap Pin
Mycroft Holmes2-Dec-12 13:28
memberMycroft Holmes2-Dec-12 13:28 
GeneralRe: oltp vs olap Pin
a.fatemeh2-Dec-12 13:41
membera.fatemeh2-Dec-12 13:41 
GeneralSQL instance name when using network group Pin
Aamir Saleem2-Dec-12 10:32
memberAamir Saleem2-Dec-12 10:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.150624.2 | Last Updated 1 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid