Click here to Skip to main content
       

Database

 
AnswerRe: Windows Run Command PinmemberEddy Vluggen1-Oct-12 5:09 
QuestionRe: Windows Run Command Pinmemberjojoba20111-Oct-12 22:09 
AnswerRe: Windows Run Command PinmemberEddy Vluggen2-Oct-12 0:58 
QuestionRe: Windows Run Command Pinmemberjojoba20112-Oct-12 6:58 
AnswerRe: Windows Run Command PinmemberEddy Vluggen2-Oct-12 8:08 
QuestionMySQL Question PinmemberSQL Ed28-Sep-12 4:21 
AnswerRe: MySQL Question PinmemberEddy Vluggen29-Sep-12 2:38 
QuestionRemoving the updated row Pinmembersindhuan28-Sep-12 1:48 
Hi All
I have merged data into a new table say table1 from table2(need to do this every time data comes into table2..Both the tables have following columns Id,Period(which includes date and time)Constraint(flag is only for table1)
Once the data is merged into table1 the data in table2 gets deleted automatically.when a new data comes into table2 it checks whether the period(only date not the time) in table1 and table2 matches..If it gets matched then we update the constraint flag of table1 to "1". then we add this new data from table2 to table1..Then I should remove the old data...what I wanted to do now is remove the data whose contraint flag is 1 from table1
 
I have given the code what I have done..Can some one help how to proceed
 
MERGE INTO table1 AS t1
USING table2 AS t2
ON t1.Id=t2.UsagePointId

WHEN MATCHED THEN
UPDATE SET
AND t1.period=t2.period
t1.constraint=0

WHEN NOT MATCHED THEN
INSERT (Id, period,constraint)
VALUES (t2.Id,t2.period, 0);
 

WITH x AS
(
SELECT t1.constraint
FROM table1 AS t1
JOIN table2 AS t2
ON t1.Id=t2.Id
AND t1.period =t2.period
)
UPDATE x
SET constraint=1;
WHERE t1.period AS DATE =upi.t2.period AS DATE
QuestionMySQL sql statement question Pinmemberjrahma27-Sep-12 9:28 
AnswerRe: MySQL sql statement question Pinmemberjschell27-Sep-12 10:12 
GeneralRe: MySQL sql statement question Pinmemberjrahma27-Sep-12 11:08 
GeneralRe: MySQL sql statement question PinmemberEddy Vluggen29-Sep-12 2:42 
QuestionIs there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pinmembermuhalet27-Sep-12 0:56 
AnswerRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? PinmemberEddy Vluggen27-Sep-12 1:42 
GeneralRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? PinmemberJ4amieC27-Sep-12 2:51 
QuestionRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? PinmemberEddy Vluggen27-Sep-12 4:27 
AnswerRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? PinmemberJ4amieC27-Sep-12 21:29 
Questionsql script [modified] Pinmembersindhuan26-Sep-12 20:08 
AnswerRe: sql script Pinmemberihoecken26-Sep-12 21:10 
GeneralRe: sql script Pinmembersindhuan26-Sep-12 21:21 
AnswerRe: sql script Pinmemberihoecken26-Sep-12 21:44 
AnswerRe: sql script PinmemberJ4amieC26-Sep-12 21:46 
GeneralRe: sql script Pinmembersindhuan26-Sep-12 23:30 
AnswerRe: sql script Pinmemberihoecken27-Sep-12 0:07 
GeneralRe: sql script PinmemberEddy Vluggen27-Sep-12 0:22 

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
Web03 | 2.8.140827.1 | Last Updated 30 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid