Search results for query: *

You can use the Formulas property. Set up a formula in your Crystal report. For example, name the formula PrintString and make it look like: "test print" Then, in your VB app, assign the actual value that you want to the formula: Report1.Formula(0) =...

I had this exact problem with a project I worked on.  Had to write scripts for both Oracle and SQL Server and allow the user to pass in variable parameters.  The best I've been able to do for for SQL Server is to write a stored procedure that takes in the variable...

I wrote several scripts that have to be scheduled to run on a daily basis.  I used the isql utility to run the script from the command line and used NT scheduler to execute a BAT file at a certain time each day.  The isql utility takes in many command line parameters to...

Thanks everyone for the help but I think foxdev is right, I <br>think I have to wait for the implementation of functions (I didn't know SQLS2K was going to have them).<br>JerryCurl and MapMan your suggestion actually works but I still need the cursor for my initial select statement which is...

I don't believe that would work.&nbsp;&nbsp;I want to get the result for every row in the table. So, for instance, if there were 10000 rows in tablea the select statement should return 10000 rows with the calculations for each tnum and tdate in the table.

I'm not sure if it's required, but I always add a final default value in case none of the DECODE values match:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DECODE ( GRADE,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'A', 4.0,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'A-'...

How can I return the results of a stored procedure into a query?&nbsp;&nbsp;For example, I have 4 stored procedures that take in variables and return a calculated value.&nbsp;&nbsp;I want to select every row on a table, pass in the variables to the stored procedures and output the calculated...