Using Microsoft Excel for Desired Inputs.

Every now and then you get requirement to produce ad-hoc report or data extract for given sets of excel data. User might provide you names, IDs for which he is expecting the results, but the problem is putting all that input data into your SQL queries in a way that it will fulfill the Syntax.

For ex.
SELECT company_id, address, city, state, country
FROM company
WHERE company_name in (('IBM','Oracle','Apple','Google','MicroSoft')

--List of names given by user (without quotes and comma separated):-
IBM
Oracle
Apple
Google
MicroSoft

It is doable when the list is small containing 10/20 items, But it becomes tedious & impractical to do it manually when list has 1000’s of items.
So while extracting such data yesterday, I found an easy and effortless way of achieve this thing using Microsoft Excel.

Here are Pictorial step-by-step instructions:



First Select the required columns (Cell)
Then using right click select the ‘Format Cell’ Option
Then use ‘Custom’ and Type as ‘@’, and click OK.

ICC World Twenty20 - India vs Pakistan

I hope after this win, We don't have to wait for next 24 yrs for the another world cup. Certainly, This win is precious for the India and will be treasured for the years to come. For me, I am just making a note here.

Bronx Zoo

Thanks to the corporate free tickets, It was economical to visit this Bronx Zoo with the family of four people.

We specially enjoyed the first ever Camel Ride and the Tiger mountain experience.

Thou due to late arrival, we couldn't cover the entire Zoo, but were able to visit the main attractions.

Family visit to NYC

This was a tiring family visit to New York city on the occasion of parents visit, by this time I've become a professional guide who can cover most of the NYC attractions in half a day starting with Grand Central, Park Ave, United Nation, Statue of Liberty, Wall Street, NYSE, Ground Zero (WTC), Time Square and Empire State and in the end serving the dinner in Indian Restaurant.