Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bill_
Starting Member
38 Posts |
 Posted - 2010-05-18 : 09:05:56
|
| I have heard there is something in SQL Server that is a template for output where you set up what the output will look like first and then fill it in with query results and variable values later.What is it called ?How can I learn to use it ? |
|
|
bill_
Starting Member
38 Posts |
Posted - 2010-05-18 : 10:57:54
|
| How can you get query results and variable values into html or text or printer or something like that ? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-18 : 13:53:41
|
| you will be better off giving your exact scenario so that we can suggest you some solution.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bill_
Starting Member
38 Posts |
Posted - 2010-05-18 : 14:23:56
|
| I queried a table in a stored procedure and put it in a cursor. Then I looped through the cursor and took some totals.Now I'd like to put it in a form where it can be viewed and printed on the computer.I hope that is specific enough. If you need more information, please let me know.Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-18 : 14:26:50
|
| actually you dont need a cursor in most cases. you can use a set based solution and then retrive the totals. then use proper connection string to connect to dn from form and display the values------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bill_
Starting Member
38 Posts |
Posted - 2010-05-18 : 16:09:39
|
| What is dn ? |
|
|
|
Nikhil1home
Starting Member
23 Posts |
Posted - 2010-05-18 : 17:46:43
|
quote:
Originally posted by bill_
I queried a table in a stored procedure and put it in a cursor. Then I looped through the cursor and took some totals.Now I'd like to put it in a form where it can be viewed and printed on the computer.I hope that is specific enough. If you need more information, please let me know.Thanks.
it's still not clear what you want to do. If you are looking to export data from SQL Server to text/Excel/CSV then you can use the Import-Export Wizard in SSMS. You can save the Wizard settings as a SSIS package and schedule it to run on a regular basis. |
|
|
|
bill_
Starting Member
38 Posts |
Posted - 2010-06-02 : 13:39:14
|
| I'm asked to make a ColdFusion program call a stored procedure that runs a query, processes the query data, writes it to an html file, and copies that file to a directory. Users use the ColdFusion prog and the rest should be automatic.So far I've got ColdFusion prog calling the stored procedure, report output going from a table to a table variable, and then printing to the results panel line by line. Hope someone has a suggestion for an easy way to get those line by line results into a file to copy to a dir. |
|
|
|
|
|
|
output