Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. p8ass8

    SQL Server Stored Procedure Return Value Problem

    gmmastros, Thats what I need. Thanks a lot!!
  2. p8ass8

    SQL Server Stored Procedure Return Value Problem

    gmmastros, I am sorry. I should have explained properly. Here is how the code looks right now: If(parameter=1) Begin Select Count(*) from ... Return (1) End When the procedure is executed, it comes back with the right number of records. But when I do, Declare @NumRecs INT exec...
  3. p8ass8

    SQL Server Stored Procedure Return Value Problem

    genomon, I am using Crystal Reports 10. I am sure an output parameter won't wreck the SP, but a lot of processes seem to depend on this SP and we 'd rather not touch it and cause unanticipated problems elsewhere. gmmastros, I tried this, the variable displays 1 - just that the procedure was...
  4. p8ass8

    SQL Server Stored Procedure Return Value Problem

    I have a stored procedure that returns the total number of records(INT) obtained for a particular parameter value(customer type). I need to create a report that runs this stored procedure for several different parameter values and displays the total for each type. The original SP does not have...
  5. p8ass8

    Crystal Reports 10 - Invalid Argument Error

    Thank you for your replies. Eventually turned out that a join was taking too long and perhaps caused Crystal to timeout or something. When I removed the join from Crystal, and did it in the stored procedure instead, the report started to work fine. So now it works! Thanks again
  6. p8ass8

    Crystal Reports 10 - Invalid Argument Error

    I have a report that takes a USERID value(int) as a parameter(user supplied). This report works for all parameter values except one(so I know this has nothing to do with stored procedure permissions). If I run the associated stored procedure independently for this parameter value, it returns...
  7. p8ass8

    Record selection using formula

    I am calculating percentage total in a formula. I want to be able to select those records where percentage total is above 1%. However, the select expert doesn't list this field and I don't know how to filter the report for those records with percentage total above 1%. Any help would be...
  8. p8ass8

    Report with summaries in it thru sql

    I need to build a report in Crystal, but with all the data coming thru a stored procedure in SQL server. The report has the following fields: physician id, physician's name - from physician table count of number of patients represented by each physician, in each category - labtest 1, 2, 3 or...
  9. p8ass8

    Retrieving the latest record

    Thank you for your reply. I think that might be it. I am about to try it right now, and will let you know if it works.
  10. p8ass8

    Retrieving the latest record

    There are students of different departments and classes that take different exams repeatedly based on certain requisites/rules. I need to pull the latest grades based on examdate for students of classid and departmentid that are passed to the stored procedure during execution. Here is my...
  11. p8ass8

    Variable doesn't seem to store value

    I am using the cursor to insert records into a new table whenever NonSmoker value is found to be a 1. I just realised that the while loop, for some reason, is reading only the first 100 records, for which, coincidentially, the NonSmoker values are NULL! So it makes sense that there are no...
  12. p8ass8

    Variable doesn't seem to store value

    I am trying to print the value of variable @NonSmoker by reading this float value from a table using a cursor. The print statement isn't returning anything. It seems the cursor isn’t reading or storing any values for @NonSmoker. What could the problem be?? Here is my script; create...
  13. p8ass8

    Creating a formula that does a Left Join on two tables

    I have 2 tables of which some records in the second one are missing. I haev to complete those, how do I locate those and display them on my report? I use a left join or not exists clause in a query to get the results on the database, but I don't know how to write a formula that does the same...

Part and Inventory Search

Back
Top