How to Get Filtered Data from SQL server into Microsoft Excel 2007
 

This query will work
select code,unitprice from item
where code like 'fg%'

and u can write this query at
Other Data Sources
From SQL Query (at the end of the drop down list)
next
next
next
Query
and then write the query and go into file menu
and select export data into excel from there and then select pivot table from given options