Search results for query: *

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...

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...

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...

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...

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...

CR 10 against SQL Server I have a listing of the number of calls and the days they were made. Day 1 1 2 3 4 5 Day 2 1 2 3 total days = 2 I have it group to give me the total calls per day and the total calls for the month. What i need to do is get the total number of days these calls...

I have another dealing with this... realizing my SQL is not what I thought I have a datetime field: start 1/11/2005 11:52 1/11/2005 14:45 total seconds: SEC 10 20 Agent: agent Ben I need to create a stored procedure based on a single date that will return to me the sum of the calls on a...

I am using cr10, connecting to SQL server. I am getting the time from a call log to come in total number of seconds per call for the month. I have 2 groups, 1 on the department, 1 on the agent. What I am tryin g to do is get the total number minutes and number of calls per agent for the day...

I need to develop a stored procedure or view that will convert the time duration of several calls to seconds. Here is what i am recieving: Duration 00:02:30 00:10:01 00:03:29 I need to convert these to total number of seconds per call in the view so I can add these up in a SP or in crystal...

I retrieve the durations of calls for a specific person. I am not sure how to add the durations together to get the total amount of time on the phone per day. I tried converting to seconds, which i can get the total number of seconds, but now i cannot convert back. I feel like an idiot, but Can...

I am trying to write a Crystal report that is linked a SQL DB. What I have done so far is imported the SMDRs into a SQL database. This is all great for reporting on the agent, but how do I get the agent group? The closest I have gotten was to copy and modify the tblindex view and send that to...

I am trying to write a query that will add the time from several different activities. Ex Activity1: Time 1:00:34 Activity2: Time 0:03:45 Activity3: Time 0:05:26 I need the total time by adding these together. Not sure how to accomplish this from SQL Server Billy Ballard For in...

I have a VB6 program that exports out a Crystal report as a PDF every 2 hours to a web portal to overwrite the file in question. If someone decides to open the file rather than download it, how can I kill the old report to prevent this error from happening? Billy Ballard For in the past, Lies...

I have a formula the shows 2 dates from a table: Date ({invdetail;1.InvStartdt}) & " to " & date({invdetail;1.InvEndDt}) Since I cannot format the dates to look like 01/02/04 to 01/31/04 via text formatting, how do I get them to stap printing out as 1/2/04. all of the conversions I know...

what requirements would be needed to enable a ghosted image off of my laptop to be placed onto my new laptop keeping everything in tact? I own the windows XP license for this machine, but do not want to tranfer and install 30 gig of data/programs again. Can this work if I ghost the drive and...