MSSQL Server 2005, Help with Query to transfer infomation from multiple DBs
Basically what i need the query to do is call from a DB "User" id where the id is in Binary data. from that i need it to insert into 2 other tables in the Billing DB.
the UserId needs to be the same in all areas, and when it inserts into tblUserInfo it has to pull from userNumber from tblUser after the rows are entered so that the userNumber in tblUser and tblUserInfo are the same.
Hopefully you can help. if any further information is needed please just ask and ill try to give as much as i know.
Re: MSSQL Server 2005, Help with Query to transfer infomation from multiple DBs
Use the following scripts,
You didn't mention any condition to retrive "id" column from tbl_account table.If the condition is avialable then add it in where condtion.
|All times are GMT +5.5. The time now is 00:30.|