Creating a PDF from a Stored Procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by M Ivica » Creating a PDF from a Stored Procedure

114 posts, Page 1 of 12

1 2 3 4 5 »»»

Creating a PDF from a Stored Procedure

Rate Topic

Display Mode

Topic Options

Author

Message

mivica

Posted Sunday, July 27, 2003 12:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 24, 2007 4:33 AM
Points: 7, Visits: 3

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp

Post #14614

kenwallacedesign

Posted Tuesday, August 26, 2003 12:58 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, February 04, 2012 2:20 PM
Points: 11, Visits: 58

Wow.

Any idea how well this would scale on a production system?

Edited by - kenwallacedesign on 08/28/2003 10:09:41 PM

Post #72325

bredins

Posted Tuesday, August 26, 2003 4:20 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 2:07 AM
Points: 36, Visits: 39

Very nice procedure - but the example data you provide doesn't match the graphs you display as output - or am I missing something?

Post #72326

Andy Warren

Posted Tuesday, August 26, 2003 5:36 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

I'll check on it tonight, I think something went wrong in the loading process. Bear with me!

Just guessing, I think scaling wouldnt be bad as long as the docs werent super huge. Not sure its a good idea to run on a server, but thats another story.

Andy
http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #72327

declanm

Posted Tuesday, August 26, 2003 9:18 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, September 24, 2003 12:00 AM
Points: 10, Visits: 1

Fantastic Stored Proc, however it did start to drive my server hard when I started to increase the calls. Looks like there is a lot of overhead in the OA_create calls.

Post #72328

fred2002

Posted Wednesday, August 27, 2003 8:29 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, March 31, 2010 2:18 AM
Points: 872, Visits: 83

Great Proc,
it works very fine!

Thanks

Post #72329

jloesch

Posted Wednesday, August 27, 2003 5:46 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, April 18, 2011 5:08 PM
Points: 410, Visits: 7

Where do you find the specs for the PDF format?

I would also like to make a suggestion. I personally think that code that is shared with others should be easier to follow. One of the things that helps with that a lot is clear variable names. I have no idea what @cr, @pr, or @ti are for. Comments are also helpful. I'm not complaining, just suggesting.

James Loesch

James C Loesch

Post #72330