Click here to Skip to main content
15,565,146 members
Home / Discussions / Database
   

Database

 
QuestionPICTUREBOX IMAGE IN VB.NET Pin
Pauls Pauls13-Apr-15 1:18
Pauls Pauls13-Apr-15 1:18 
AnswerRe: PICTUREBOX IMAGE IN VB.NET Pin
Corporal Agarn13-Apr-15 1:35
professionalCorporal Agarn13-Apr-15 1:35 
QuestionSystem.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
indian1437-Apr-15 16:22
indian1437-Apr-15 16:22 
AnswerRe: System.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
Sascha Lefèvre7-Apr-15 17:42
professionalSascha Lefèvre7-Apr-15 17:42 
GeneralRe: System.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
indian1437-Apr-15 20:59
indian1437-Apr-15 20:59 
GeneralRe: System.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
Sascha Lefèvre7-Apr-15 21:54
professionalSascha Lefèvre7-Apr-15 21:54 
QuestionA data source instance has not been supplied for the data source Pin
indian1436-Apr-15 13:55
indian1436-Apr-15 13:55 
QuestionHow Do I Insert Only Recently Updated Row From Table1 To 2 in MySQL Pin
RevathySanthanam2-Apr-15 5:10
RevathySanthanam2-Apr-15 5:10 
XML
i have two tables with same schema. i have to check table1 for any updates and insert the updates or the entire row into table2, only the most recently updated row.
so basically, table2 has the unique values from table1; for the duplicate entries in table1, there is only the most recent entry in table2.
i have tried to get the most recently updated id from table1:

SELECT distinct id
FROM table1 order by time_date desc limit 1;

now i need to use this id to get the other columns from table1 and insert the row with that id, into table2.
and i have to do this for all the entries in table1.
i have to update the row in table2 if it already exists, else insert new row. i check for recent record based on the date column, time_date.
both the tables have same schema.

any help would be great.!
thank you.

Rant[REPOST] How Do I Insert Only Recently Updated Row From Table1 To 2 in MySQL Pin
Richard Deeming2-Apr-15 5:41
mveRichard Deeming2-Apr-15 5:41 
Questionmultiple joins, works in sql manager but not in asp.net Pin
jkirkerx1-Apr-15 13:47
professionaljkirkerx1-Apr-15 13:47 
Answer[solved] Pin
jkirkerx1-Apr-15 14:02
professionaljkirkerx1-Apr-15 14:02 
SuggestionRe: multiple joins, works in sql manager but not in asp.net Pin
Richard Deeming2-Apr-15 3:30
mveRichard Deeming2-Apr-15 3:30 
GeneralRe: multiple joins, works in sql manager but not in asp.net Pin
jkirkerx2-Apr-15 13:09
professionaljkirkerx2-Apr-15 13:09 
Questionimage in database Pin
vinay dahiya1-Apr-15 12:40
vinay dahiya1-Apr-15 12:40 
GeneralRe: image in database Pin
PIEBALDconsult1-Apr-15 13:08
professionalPIEBALDconsult1-Apr-15 13:08 
GeneralRe: image in database Pin
vinay dahiya1-Apr-15 13:15
vinay dahiya1-Apr-15 13:15 
GeneralRe: image in database Pin
PIEBALDconsult1-Apr-15 13:22
professionalPIEBALDconsult1-Apr-15 13:22 
GeneralRe: image in database Pin
vinay dahiya1-Apr-15 13:59
vinay dahiya1-Apr-15 13:59 
GeneralRe: image in database Pin
Richard MacCutchan1-Apr-15 22:22
mveRichard MacCutchan1-Apr-15 22:22 
GeneralRe: image in database Pin
vinay dahiya2-Apr-15 2:59
vinay dahiya2-Apr-15 2:59 
GeneralRe: image in database Pin
Richard MacCutchan2-Apr-15 3:38
mveRichard MacCutchan2-Apr-15 3:38 
GeneralRe: image in database Pin
vinay dahiya2-Apr-15 3:44
vinay dahiya2-Apr-15 3:44 
GeneralRe: image in database Pin
Eddy Vluggen1-Apr-15 23:25
professionalEddy Vluggen1-Apr-15 23:25 
GeneralRe: image in database Pin
vinay dahiya2-Apr-15 3:02
vinay dahiya2-Apr-15 3:02 
GeneralRe: image in database Pin
Richard MacCutchan2-Apr-15 3:39
mveRichard MacCutchan2-Apr-15 3:39 

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

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