Kanagavel A

with factorial(n,fact)as ( select 2,cast(2 asfloat) union all select n+1,(n+1)*fact from factorial where n<50 ) select n,fact from factorial

No resolution will last more than a week...Because if we wanted to do that or starting something new we could have done at the same moment we thought of it..Guess...

Could anyone tel me how can we execute a query step by step in sql server 2012 ?? ( Like we do in C language)

What are all the meticulous difference between sql server 2005,2008,2012 ??

As you said UPPER() , LOWER() and PROPER() functions can be used...But we need to enter thses informations in another cell (connecting the cell which we want to modify) then...

Would it possible to select some cells in the excel randomly(not in the same column or same row) and Do case change(upper to lower or lower to upper) ??