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 Chriss Miller 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. shenay921

    Parameters using 'ALL' union but still select multiples

    Thanks for the response! I will study on that idea that the parameters are either a single value or an array of values. I had already tried the indexing and even adjusted the query to pull fewer records but the performance was still poor when selecting all.
  2. shenay921

    Parameters using 'ALL' union but still select multiples

    Hi There, I am working in SSRS 2008. I have a parameter to pull 'All' of a set of records or it will pull one. What it won't do is allow someone to select two or more. It is either one or All. I found the standard 'Select All' was killing my report -- like 5 minutes. This 'All' workaround runs...
  3. shenay921

    Need to make SQL query in stored procedure faster

    I tried running the SP alone -- took about 5-6 seconds and in the report. Takes about 15 minutes.
  4. shenay921

    Need to make SQL query in stored procedure faster

    Ok, I ran the index and it took the same amount of time. Thanks for your help!
  5. shenay921

    Need to make SQL query in stored procedure faster

    First, if I just run the query without any additional indexing it only takes 6 seconds. Something in the report is killing it.
  6. shenay921

    Need to make SQL query in stored procedure faster

    Index name: PK_FDC_Descriptions Index description: clustered, unique, primary key located on PRIMARY INdex Keys: type, code
  7. shenay921

    Need to make SQL query in stored procedure faster

    Sure! CREATE PROCEDURE CUST_LLA_TRIP_VITALS AS SELECT tdate, job, vdate, vtime, pulse, resprate, bps, bpd, palpitation,spo2,etco2,painscale, who_text as crewname, temperature, comments, PTA, RespReg.descr as respreg, Pulsereg.descr as pulsereg, PulseStrength.descr as pulsestrength...
  8. shenay921

    Need to make SQL query in stored procedure faster

    Well, I changed the code and the procedure ran but it is still taking 15 minutes to pull the data into the report. This maybe a crystal issue as it is running as a subreport. Thanks for your ideas.
  9. shenay921

    Need to make SQL query in stored procedure faster

    I am converting the code right now but am confused by the line: (SELECT descr FROM FDC_Descriptions WHERE type = 6021 and code = V_CUST_LLA_Trip_Vitals.ecgectopics) as ecgectopics, glucose The additional glucose is throwing me off. Am I to insert: ecgectopics.descr as ecgectopics, glucose...
  10. shenay921

    Need to make SQL query in stored procedure faster

    Hi Markros, Thanks for the ideas! Why would explicity specifying the columns speed up the processing? I think I can do it but was wondering what that mattered as opposed to using the * symbol. Thanks! Laura
  11. shenay921

    Need to make SQL query in stored procedure faster

    ...as etco2compensation, V_CUST_LLA_Trip_Vitals.status from V_CUST_LLA_Trip_Vitals where status=1 GO Code for the View: CREATE VIEW dbo.V_CUST_LLA_Trip_Vitals AS SELECT * FROM dbo.Trip_Vitals where Trip_Vitals.tdate > '2007-01-01' Thanks for the help! Laura
  12. shenay921

    New Line in String in Crystal 7.0

    Hi There, I read that in Crystal 10 you can create a new line in a string series using chr(10) or chr(13). Is there anything that works for Crystal 7.0? Example: 'Cancellation Reasons Count' + chr(10) + 'Cancelled by FD PTA: ' & {#CancelbyFDPTA}
  13. shenay921

    Compare and Concatenate String Field within Group

    Thanks for the help Ian. --Ok, I tried putting the @part1 into the details along with the global variable -- it did not like any array number except 1: -- Whileprintingrecords; stringvar array map := split({CorrectLargeIndex_.Ext# Map Page},";"); if ubound(map) >= 1 then map[1]; global...
  14. shenay921

    Compare and Concatenate String Field within Group

    Hi There, Using Crystal XI, Windows XP I've been reading through the posts and have had some luck with (@reset,@accum,@display). I have for fields: StreetName, PrimKey, BigPage, SmallPage The data example: Group: 1st Street Details: 1st Street; 21976; 3104; 2073; 1st Street; 21972; 3104...
  15. shenay921

    Crystal 7.0 Convert DateTime to UTC

    Nice job! That worked! Thank you!
  16. shenay921

    Crystal 7.0 Convert DateTime to UTC

    Hi There, I need to take a datetime and add 7 hours to it to give me a new datetime in Crystal 7.0. Such as datetime 8/26/2008 20:00:00 and convert to 7 hours ahead: 8/27/2008 03:00:00. I know versions 8.0 and higher have the DateAdd ability -- what can be done in 7.0? I haven't been able to...
  17. shenay921

    Crystal 7.0 datetime error unable to use Datediff in 7

    Also, the atddate, avldate, avltime and atdtime -- these are all strings with a format of 2006-11-03 and 12:14:13.
  18. shenay921

    Crystal 7.0 datetime error unable to use Datediff in 7

    ...AVL := DateTime(Date({Trips.avldate}), Time({Trips.avltime})); dateTimeVar ATD := DateTime(Date({Trips.atddate}), Time({Trips.atdtime})); (AVL-ATD)*86400; Of course, it runs in crystal but it is erroring out in RescueNet with "Not enough arguments". Could someone tell me if the above...
  19. shenay921

    Compare 2 tables and create new in Access

    Thanks for your response. I tried to load the code but it does not like the AS A INNER JOIN.
  20. shenay921

    Compare 2 tables and create new in Access

    Hi there, I'm fairly new to Access 2003 and am used to Crystal. I have a table of billed accounts (Acct, DateFrom, DateThru, Rebill, DropDate) -- there are other fields but these are the main ones. The options for Rebill are null and R2. Null means a first-time billing. This table covers...

Part and Inventory Search

Back
Top