I have one store procedure and inside that one i used 4 tables(tb1,tb2,tb3,rs1).each table has only one column(x-varchar type).starting of the procedure I deleted the existing rows in the contents first 3 tables except rs1 then I ll insert some 10 to 15 rows in three tables.. End of procedure I ll insert the 3 tables data into rs1 using 3 insert statements(first rs1,rs2 and rs3). But the issue is when I select the rows from rs1,few ts3 rows are in first two rows of rs1 then it has rs1 data then ts2 value then missing ts3 rows..also this is not happened all the times... I'm not able to find out the reason for this...
Tb1 value ---------- ARUN Address State Tb2 value ---------- Product1 Product2 Product3 Tb3 value --------- Productname1 Productname2 Productname3
After I'm inserting the data to rs1 like this
Insert into rs1 Select x from ts1 Insert into rs1 Select x from ts2 Insert into rs1 Select x from ts3
Result is coming like below
Productname2 Productname3 Name Address State Product1 Product2 Product3 Productname1