SweetingA
asked on
Using recordsets or equivelant in vb express working with sql server tables
I am working vb express 2010 and connected to an SQL server in Management Studio Express 2008.
I need to lookup each instance of startdate in tbl_1 and check every row of tbl_2, inserting a the downtime code from tbl_1 when the downtimecode is not currently null
tbl_1
ID StartDate StopDate StopTime DowntimeCode
1 2014-01-01 2014-01-02 24 3
2 2014-01-02 2014-01-03 31 6
3
tbl_2
ID StartDate StopDate StopTime DowntimeCode
2014-01-01 3
2014-01-01 3
2014-01-02 6
I must do this procedure from vb.
Thankyou very much for your assistance.
I need to lookup each instance of startdate in tbl_1 and check every row of tbl_2, inserting a the downtime code from tbl_1 when the downtimecode is not currently null
tbl_1
ID StartDate StopDate StopTime DowntimeCode
1 2014-01-01 2014-01-02 24 3
2 2014-01-02 2014-01-03 31 6
3
tbl_2
ID StartDate StopDate StopTime DowntimeCode
2014-01-01 3
2014-01-01 3
2014-01-02 6
I must do this procedure from vb.
Thankyou very much for your assistance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.