UPDATE DemographicNum SET EndDate= WHERE DemographicNumID=;FINISHFixed
SELECT a.DemographicNumID AID,b.StartDate BStart FROM DemographicNum as a JOIN DemographicNum as b ON a.AttachTo=b.AttachTo and a.AttachID=b.AttachID and a.DemographicLink=b.DemographicLink and a.EndDate='0000-00-00' and b.EndDate='0000-00-00' and a.StartDate < b.StartDate;OUTPUT
Saving..
$in{DNumber}=~s/\,//g;
SELECT DemographicNumID from DemographicNum where DemographicLink= and StartDate=;OUTPUT NIL
UPDATE DemographicNum SET AttachID=,StartDate=,Source=,DemographicLink=,DNumber=,F%d>,
LMBy=,LastModified= WHERE DemographicNumID=;OUTPUT NIL
INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',,,,,,F%d>,,,);OUTPUT NIL
SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID= AND DemographicLink= AND StartDate < ORDER BY StartDate DESC LIMIT 1;OUTPUT NIL
UPDATE DemographicNum SET EndDate= WHERE DemographicNumID=;OUTPUT NIL
SELECT StartDate NSTD FROM DemographicNum WHERE AttachID= AND DemographicLink= AND StartDate > ORDER BY StartDate LIMIT 1;OUTPUT NIL
UPDATE DemographicNum SET EndDate= WHERE DemographicNumID=;OUTPUT NIL
SELECT DemographicID as DemographicLink FROM Demographic WHERE DemoCategory= ORDER BY DemoSubcategory,Priority DESC,DemoName;OUTPUT EachDNum
Saved Changes.
| Select a Demographic Category |
|
SELECT DISTINCT DemoCategory FROM Demographic ORDER BY DemoCategory;OUTPUT
[Add New]
[Import]
|
Existing Demographic Dates
SELECT DISTINCT StartDate XSD from Demographic,DemographicNum where DemoCategory= AND DemographicLink=DemographicID AND AttachTo='Container' and AttachID= ORDER BY XSD;
OUTPUT
|