Search results for query: *

Hello there, I'm developing a stored procedure for a Crystal report and starting out with some code that has already been developed. I'm fairly new to this and this is just over my head. Can you help? I have 8 types of fields that need to be sorted, according to the values contained in each...

I did it right after you pointed it out. Thank you!

Oh, don't I wish! We're using SQL 2000. In your mind, would it return random samples?

Yes, I had just changed that from the TempID late last night. When the other developer saw it, it had the TempID as the final sort. I musta been bleary. Thanks for waking me up! What do you think about the code with it sorted by TempID?

Hello, I wrote some code that is supposed to select a random sample of clients from three views. I needed to allow the user to ask for a certain number of records to be returned. What I did was run the parameters of the selection and union the results of the return into a temp table, while...

Thanks to all of you! I got some great ideas, but used GMastros code first and it did the trick perfectly. I had to think about why the first part [(@ServiceCodeGroup = 'All Service Codes'] would return all records, but then I translated this to the equivalent of "where 0=0" which would be...

Hello, I'm trying to set up a where clause with (among other things) a selection of a variable if it has a value other than "all" or a wildcard if it is "all." I'm pulling the data from a temp table. I'm not sure how to code this and have botched it in several different ways. Can you help me...

George, Thank you for the more streamlined code! Also, I removed *all* the "go"s and removed the two extra "insert into"s that I had in the union query and I'm down to an error near "not" which I can handle. Thanks so much for your help!

Thanks JBenson and George. I'll get rid of the "GO" and try it. I never get to call the procedure because it isn't built yet. Just running the code checker through Query Analyzer nets me errors. Here is the error list: CREATE PROCEDURE dbo.usp_ProgressNotes @TherapistName...

Hello, I hope you can help me as I'm new to using SQL. I'm trying to create a procedure, but when I test it in Query Analyzer, it doesn't recognize the variables that will be passed in as having been declared. Is there something wrong with my syntax? I've looked at several things and have added...

Hello, I'm using version 8.5 and trying to link a Crystal Report main report to another report that uses the same stored procedure on a network. I want them to remain separate, as I want the parameters of the second report to fire only when the hyperlink on the first report has been clicked--not...

I'm having this same problem and don't get it. I have a very simple query: one table that the report is based on. When I go into the record source and run the query, it returns all the data, which is sorted by sequential item ids. However, when I run the report, it leaps from record 1 to record...

Thanks Bob, but I don't want to use another form. These reports are to be printed out on the fly and the time to pull up two forms just would get in the way. It should work from code at a button push like anything else. All they're inputting is the year.

Hi Bob, I probably wasn't clear enough in my original explanation. Some of the reports run input boxes from the "on open" event, which I don't want the user to have to fill out multiple times. I'm trying to print out multiple copies with one print command, which DoCmd.OpenReport rpt...

Hi, I've set up a form that accesses the reports container and lists out specified reports. The User selects one of these reports and can either view it by clicking one button, or print it by clicking another. Since these reports might be run in multiples, I wanted the ability to print the...