Tuesday, February 15, 2011

I Love sqlforce

This morning the head of our consulting division decided to change the stage names used by opportunities. Before taking this step, I wanted to take a look at what stage names have actually been used by sales staff.
If I was working with a regular SQL database, I would simply run:
SELECT DISTINCT stageName Opportunity
How can I run the same query on a Force database?  Easy....start sqlforce and enter:
SELECT DISTINCT stageName from Opportunity

Case closed.

No comments: