I am waiting for a interview on monday they said their will be a test also.
So i am guessing for some questions.
1) What precaustions should you take when restoring an database which is already in the server.
Customer no pay type amount 1 pay 100 2 pay 150 1 cre 20 3 pay 200 3 cre 50
I need to get the total for each customer but in the pay type 'pay' add and if the pay type is 'cre' it has to deduct from the total. How do you get a group total for each customer.
any body knows about question of SQL server please pass it with the answers. Altough I have experience in ORACLE and INFORMIX , I have limited experince in SQL Server I need some help on this.