Posted by: a_little_idea May 23, 2015
Login in to Rate this Post:
0 
? 
?
Copy and Paste it on SSMS. Other than no.5 everything should work. Please provide more details for no.5 (see comments)
Editor doesn't preserve line breaks here so a SQL fiddle has been made. you will be able to see formatted code here
http://sqlfiddle.com/#!3/d58dc/13
Also for Question 5..
-------Write a procedure to remove duplicates from a table containing million rows using batching
--------not sure what do you mean by batching ??? please be more specific...and from what table you want to delete the records?? do you hav any sample data. just want to see how data is structured.
Last edited: 23-May-15 05:21 PM
Last edited: 23-May-15 05:23 PM