November 12, 2010 at 7:01 pm
Hi for the below questions i need good and efficient answers. Below are the inrterview questions asked in one interview. I am having the real time exp. But the interviewer is not satisfied with my answers. I will furnish my answers also.
1) I am having one table and the customer is exported some data from an excel sheet to the table. After that some changes has been made and uploaded the excel sheet again in to the application. How we should decide which was updated and which was the new item was added in the excel sheet?
MY ANSWER:
Wht i told is : First i will take the excel data in to a temporary table and i will repeat the loop for every record and i will check whether the record was updated or not?
But the interviewer wants me to compare all the records at atime. I don't know how it was compared?
2) BOM Pricing Required?
BOM Pricing in the sense:
One product is having sub products. Tha sub products are also having BOM. Like that i have so many levels of bom's are there. How i should find out the BOM priciong at that time?
MY ANSWER:
I told him to write a while loop by saying thast, loop thru which the product is not having the sub products and then take all the items and claculate the price.
But he is not impressed with this answer.
3) I have one table. In that some other third party application is inserting data in to it. But one stored procedure is looking in to that table and if any row inserted in to the table then this procedure should take the inserted or updated records and have to insert in some other tables. What is the best have to be implemented in the stored procedure?
How we know whether the record was inserted in to the main table?
MY ANSWER:
For the main table take one cursor. If any record was inserted in the main table then trigger will insert/update an item in some other table. Stored procedure will look in to the table and decide whether the record was inserted or not?
But he told me that i understood the logic. Totally He is not satisfied with my answers.
Please answer these questions as soon as possible.
Srinadh
November 12, 2010 at 9:14 pm
duplicate post. please post your replies here.
http://www.sqlservercentral.com/Forums/Topic1019837-392-1.aspx
Edit - fixed the url.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply