Click here to Skip to main content


AnswerRe: Windows Run Command PinmemberEddy Vluggen2-Oct-12 9:08 
QuestionMySQL Question PinmemberSQL Ed28-Sep-12 5:21 
AnswerRe: MySQL Question PinmemberEddy Vluggen29-Sep-12 3:38 
QuestionRemoving the updated row Pinmembersindhuan28-Sep-12 2: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

AND t1.period=t2.period

INSERT (Id, period,constraint)
VALUES (t2.Id,t2.period, 0);

SELECT t1.constraint
FROM table1 AS t1
JOIN table2 AS t2
ON t1.Id=t2.Id
AND t1.period =t2.period
SET constraint=1;
WHERE t1.period AS DATE =upi.t2.period AS DATE
QuestionMySQL sql statement question Pinmemberjrahma27-Sep-12 10:28 
AnswerRe: MySQL sql statement question Pinmemberjschell27-Sep-12 11:12 
GeneralRe: MySQL sql statement question Pinmemberjrahma27-Sep-12 12:08 
GeneralRe: MySQL sql statement question PinmemberEddy Vluggen29-Sep-12 3:42 
QuestionIs there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pinmembermuhalet27-Sep-12 1:56 
AnswerRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? PinmemberEddy Vluggen27-Sep-12 2:42 

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.150224.1 | Last Updated 27 Feb 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid