How can I use output of a stored procedure dynamiclly?

Question

How can I use output of a stored procedure dynamiclly?

bkshn

Right there with Babe

Points: 794
More actions
November 18, 2013 at 2:04 am

#301290

Hello
I have a stored procedure as GENERATE that generates a html file and I have another one as SHOW that show this html file.
I use time to show system time in my GENERATE sp but when I use SHOW sp the time didn't change and show just the first time that Generate sp generated.
Could you help me How can I see time dynamiclly?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33507 More actions · Answer 1

How are you currently passing the value from the GENERATE to the SHOW stored procedure?

If possible post the code of both procedures, so we can analyze your problem and provide a better (working and tested) solution.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Sean Pearce SSCoach Points: 15999 More actions · Answer 2

In the generate proc you should define a placeholder for time and in the show proc you can replace your placeholder with the time.

This does sound like a job for SSRS though.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

bkshn Right there with Babe Points: 794 More actions · Answer 3

Hello

what did you mean about defining placeholder in SP?

I searched it but I didn't find any thing.

Sean Pearce SSCoach Points: 15999 More actions · Answer 4

I simply mean a unique string in the html contents that the generate proc creates. Then you can use the REPLACE function at display time.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

HanShi SSC-Dedicated Points: 33507 More actions · Answer 5

Can you confirm you actually put the generated time value inside the HTML file (and not only showing it)?

Do you save the HTML file to disk with the GENERATE proc? Are you sure you overwrite any existing files? If so, can you verify (with a text-editor or browser) that this file contains the correct generated time value.

Does the SHOW proc point to the correct file?

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **