Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Creating a PDF from a Stored Procedure Expand / Collapse
Author
Message
Posted Sunday, July 27, 2003 12:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, August 26, 2003 12:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:14 PM
Points: 11, Visits: 59
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
Posted Tuesday, August 26, 2003 4:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 1:20 PM
Points: 36, Visits: 40
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
Posted Tuesday, August 26, 2003 5:36 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 8:30 AM
Points: 6,794, Visits: 1,905
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
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #72327
Posted Tuesday, August 26, 2003 9:18 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, August 27, 2003 8:29 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!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
Posted Wednesday, August 27, 2003 5:46 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-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
Posted Thursday, August 28, 2003 9:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 4, 2004 2:10 AM
Points: 46, Visits: 1
Excellent!

Very very cute procedure for creating PDFs.




Post #72331
Posted Tuesday, September 23, 2003 1:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 12, 2014 2:27 PM
Points: 45, Visits: 2
a very good one !!!




Post #72332
Posted Wednesday, October 1, 2003 3:47 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:49 AM
Points: 1,391, Visits: 608


Very nice work done for PDF.

Please provide some comments in your procedure for declaring variables for PDF Format.




Post #72333
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse