Search results for query: *

So as these tables get into the 10 of thousands of rows and not just the 2500 curently there this will not run the system low on resources with multiple requests? Billy For in the past, Lies the future.

I have a stored procedure which I have several temp tables declared. Declare @temptbl table () Once i am done using these I have the results input into another temp table. How do I drop the previous temp tables? I keep getting a some results have been dropped because I am low on resourses...

I have a CR 8.5 Developer using the RDC and have this code. I just upgraded to 10.0 Developer and need to modify the code for upgrade. It gives me errors when I try to use this code after the upgrade. Not sure what I need to change to make it work. Dim Report As New rptinvsum Dim Subreport...

OK, I modified my nested cursor to retrieve this information. Everything is being placed into the temp table first, but I can still get no data from the cursor in the query or in the report. WHAT am I missing Declare @DT datetime DECLARE @apDate nvarchar(15) declare @ApName nvarchar...

each line is written directly to a table which is processed directly to the report. There are no reporting tools on this one. I would have like Crystal or SQL Reporting services or something, but this is how the client has it working. In reality after each select in the cursor, a command...

There is no client side grouping... this writes to a tabl;e and is processed line by line from the table

What I have to do is get a list of all appointments for each doctor. Each of these will be on a separate page. This is part of a report process for this program. (Still trying to figure it out as you have to send each line to the report) I need a dataset that will give all appointments for the...

I do not write cursors very often, but this time I have to. How do you get a nested cursor to work without the error that the cursor already exists or that it is already open? Here is my code: Declare @DT datetime DECLARE @apDate nvarchar(20) declare @ApName nvarchar (150) Declare @ApAge...

I cannot get the cursor to work. I may be doing it wrong, but I sent the 2 records into the temp taple and the loop is still taking over 30 min. All I want to to is combine the 1 field in up to 20 records into a single field. Is there any way of doing this that will not take hours?

What I am atttemting to do is to get all of the alerts into a single field. I can display the results set, however was thinking of using a loop function to combine all of the results into 1 field. Here is what I have so far: select top 1 @id = AlertCode from AccountAlert Where AccountKey...

All of a sudden out of the blue my computer has been asking me to run a program as a user. I am the adminisrator on the box. Why would I have to answer this run as on every executable? (even add and remove programs) Run As Protect my computer and data from unathorized program activity...

But when the report launches, it asks for paremters in a format only god knows who invented. I guess we will have to write the code and take it from there.

I am trying to make it not look so bland and more user friendly... Like type in a normal date, even an ASP page with a calendar which could read the parameters ask and recieve them in a more friendly fashion. I tried one of their sample pages, but all it has is setting default parameters...

I am trying to make it not look so bland and more user friendly... Like type in a normal date, even an ASP page with a calendar which could read the parameters ask and recieve them in a more friendly fashion. I tried one of their sample pages, but all it has is setting default parameters...

The page that comes up through CE 10 when you retrieved a report with parameters needs to be "Prettied up". I am looking for direction on how to get an ASP page to read the paramters and allow me to have the user enter these on another page or modify the current default page so it will accept...

NM I got it... stupid me had a typo Billy Ballard For in the past, Lies the future.

I downloaded a smaple parameter report for CE 10. I changed the parameter to log in under the administrator login. I created a virtual directory and attempted to open the report. This is what I am getting: Error Type: CrystalEnterprise10.SessionMgr.1 (0x80042A01) Unable to retrieve cluster...

I am trying to query a linked server and the the only properties I have is the IP address which is linked directly to the DB I have access to. I have tried a query such as select [10.10.10.10].* from 10.10.10.10.tbl1 I know this is incorrect, but the server is linkeddirect to the DB which...

I just found out that we are importing the same data multiple times throuought the day in a new table. Since I cannot query information inserted as it is coming from a text file, I need to write an insert trigger that will add the record if the IDNumber does not exist. If it does exist do not...

I already got it... All I was looking for was the number of days. I added a formula to break out just the date portion, then did a distinct count on that under the group that held the person section. Now I have the number of days each person work to get the average call per person per day...