Generate Pdf from sql query

I want to create a store procedure which return pdf, and save it our given folder.
I want to do this through sql script. So anyone can tell me simple script for exporting pdf.

Any help is appreciated


SQL Server Reporting Services can output to PDF. I suppose one could create a CLR procedure to ouput a file to PDF.