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

    Need to select the one value if it exists otherwise another value

    Thank you, I'll take a look at it and keep it for future reference.
  2. szeiss

    Need to select the one value if it exists otherwise another value

    Thank you for the reply. A co-worker was able to free up some time and help me out with this. I am familiar with the CASE syntax just wasn't successful in making it work. But, this is what we came up with, we also added a little more information to the query. select s.ProjectID...
  3. szeiss

    Need to select the one value if it exists otherwise another value

    I'm not sure how to go about this. In my tbl_Project_Employee below I have 4 dummy records. I need a query that selects where the employee_type_id = 48 if it exists; otherwise I select where the employee_type_id = 22. I've shown below the table what my results should be. tbl_Project_Employee...
  4. szeiss

    Updating 1 Record When There Are Duplicates

    Thank you, but we actually changed the query so it is working fine now using listagg.
  5. szeiss

    Updating 1 Record When There Are Duplicates

    No, I don't. It's a report table where the data can change each time it's ran. That's why I thought of using rowid. Thanks, Sherry
  6. szeiss

    Updating 1 Record When There Are Duplicates

    I have a table called rpt_sp_category with the following columns: sponsor, dept_cd, subproject_id, fao_id, fund, agency, orgn, cnt_fund_groups, avail_appr, expenses, spending_plan My problem is the rpt_sp_category will have duplicate records where the cnt_fund_groups > 1, but I only want to...
  7. szeiss

    Increment Number by Date with Reset

    Thank you for your help, greatly appreciated!
  8. szeiss

    Increment Number by Date with Reset

    Is there a way to increment a number by date resetting on an id column. For example: Table1 ContID Visit Date 145 1 01/01/2016 145 2 01/25/2016 145 3 02/01/2016 150 1 02/15/2016 150...
  9. szeiss

    Query records for only selected criteria

    Thanks, but I got it.
  10. szeiss

    Query records for only selected criteria

    In this example, I have 3 contracts/projects. The first one has 3 funding sources (Agcy 2207, 2307 & 6207), the second one has only one funding source (Agcy 2207), the third has 2 funding sources (Agcy 2207, 2307). I only want the contract/projects with Agcy 2207 or 2307 (SPID 238.001 &...
  11. szeiss

    Query records for only selected criteria

    I have one table with all available funding agencies. I also have a contracts table. I could have one contract with funding from multiple agencies such as 607, 207 or 307. What I need to find is which contracts are being funded ONLY by agency 207. How would I write this? Thanks, Sherry
  12. szeiss

    Grouping Table Problem

    Using CF8. I'm creating a report using cfdocument what will export as a PDF. I want the report to look like the following: Vendors Within the City comm_cd sub-heading vendor Name address loc_code vendor Name address loc_code comm_cd sub-heading vendor Name...
  13. szeiss

    List Function Confusion

    I'm using CF8. I have the following partial query - <cfquery dbtype="query" name="getVendor"> select distinct vendor, loc_code from variables.savedlist </cfquery> I'm using this query in a cfdocument pdf type report. I need to loop thru this query and look for where the...
  14. szeiss

    Mailing Labels

    I need to create mailing/address labels. There will be multiple addressees and most likely mutiple pages using Avery 5160. We are using coldfusion 9 as the front end and oracle as the backend. My thought is to use an avery 5160 template which I found on the web, insert text fields for the...
  15. szeiss

    Display FY2011 instead of FY-1 in Report

    How can I display the text FY 2011 instead of the calculation as the column heading in a report? Thanks, Sherry
  16. szeiss

    Equivalent to SQL IN operator in CF

    What would be the CF equivalent to the SQL 'IN' operator in coldfusion? <cfif #variables.location# IN "LO","AU","SL"> <cfelse> </cfelse> Thanks, SZ
  17. szeiss

    Rendering Recordset in HTML Using Cfdocument

    How do I do this? Or can I? Trying to render a recordset using HTML from an oracle 11g database thru CF 8 using cfdocument. I've gotten it to where the groups repeat for each data row, but haven't figured out how to get non-repeating group headers. HEADING Group 1 Data row...
  18. szeiss

    Passing Prompt Answer to Metric

    I'm a newbie with Microstrategy. This is something I've done with Crystal, but not sure how to accomplish this with Microstrategy. I will need this with probably every report I do. The situation is, a user selects a department and a fiscal year prompt i.e. 2012 for the FY. That number (2012)...
  19. szeiss

    CRAXDRT A month number must be between 1 and 12

    Using Oracle 10, Coldfusion, CR 8.5 on desktop and CR 11.5 on server. Keep getting this error when I press submit to run report, "A month number must be between 1 and 12". I've changed the parameters in the report to use DateSerial, but still doesn't work, keep getting the same error. Here is...
  20. szeiss

    CRAXDRT A month number must be between 1 and 12

    I forgot to mention that the dates being passed, startdate and enddate are being used as parameters on the crystal reports. Thanks, Sherry

Part and Inventory Search

Back
Top