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

    Help Needed in Parsing Values From A URL Field

    Hi... I have some data that contains a column with a URL field. Within the URL field's contents, there are several values that I need to be able to parse out. I can only do this with SQL (i.e. cant write a function since I dont have permissions to register/execute). Can anyone help...
  2. adventurous1

    Parsing Values Out of A URL Field

    Hi... I have some data that contains a column with a URL field. Within the URL field's contents, there are several values that I need to be able to parse out. I can only do this with SQL (i.e. cant write a function since I dont have permissions to register/execute). Can anyone help...
  3. adventurous1

    Help! I need a function to look up the geography for an IP address

    Hi all... I need help in writing a FUNCTION that will take an IP address and look it up in another table and return its corresponding geography values.( A function is needed as I have millions of records to lookup and brute force SQL does not perform well.) source record: IP Address Date...
  4. adventurous1

    Generate Cummulative Total in Access

    Hi... I am hoping someone smart can help me with this... I have records like this: Type Team Time Period Date #Bugs Auto Accounting Year 1/2/09 10 Auto Applications Year 1/2/09 30 Auto Finance Year 1/2/09 5 Auto Cust Service...
  5. adventurous1

    Help with Function to condense records

    Oh boy...here's the latest problem for the access newbie. My dataset has records that look like this: Field RecordID Created User OldValue NewValue status 6789 3/1/10 1:25:30 AM SVACS In Prog status 6789 3/1/10 1:25:30 AM SVACS Accepted status 6789...
  6. adventurous1

    Converting Row data to Modified Columnar format

    I need help converting the original row data below to the reformatted output. All help is appreciated! Original Row Data PARENT_ISSUE LINKED_ISSUE STATUS 179 194 Closed 179 189 Closed 205 116 Closed 62 357 Pending 62 363...
  7. adventurous1

    Need assistance converting Oracle function to Access Function

    Hi... I have an Oracle function that needs to be converted to an Access function (below). I have tried but cannot get it to work in Access. Can someone help out by posting the converted function? Thanks! create or replace function advent (f1 in varchar2, f2 in varchar2) return varchar2 is...
  8. adventurous1

    Rows to Columns Query Help... Please!!!

    Hi... Not very SQL savvy with this so any help is appreciated. Two problems... 1. Case 1 - Data is structured like this: ID Component 1 Hood 1 Body 1 Fender 2 Windshield 3 Bumper 3 Tire I need to transform this to look like this: ID Component 1...
  9. adventurous1

    SQL for Parsing a String Delimited with Periods

    Hi all... In a table, I have the following data stored in a field called DIRECTORY: PDN.RAD.40391.0110.IA0 PDN.SW.69740.HDQ.IWB1 OMH.WDW.216942.Standard.119988 DCHH.HH.44463.OB.RR I need to separate the characters between the periods into separate fields for the first three entries...
  10. adventurous1

    SQL for Parsing a String Delimited with Periods

    Hi all... In a TERADATA table, I have the following data stored in a field called DIRECTORY: PDN.RAD.40391.0110.IA0 PDN.SW.69740.HDQ.IWB1 OMH.WDW.216942.Standard.119988 DCHH.HH.44463.OB.RR I need to separate the characters between the periods into separate fields. Can anyone help? Thanks...
  11. adventurous1

    Removing blank spaces

    Ok... I am crying uncle and asking for help after doing my best to find this in any documentation or reference material. I am concatenating the following ZIP||SUBSTR(UPPER(LNAME),5)||SUBSTR(ADDR1,6). ZIP=60543, LNAME=JOHNSON, ADDR1=1 MAIN STREET The result = 60543JOHNS1 MAIN What I need it...
  12. adventurous1

    Need PL/SQL Function to Generate Summary Records

    Hi... I know there is a better way to do this but I dont know PL/SQL... My table description is: Record_Type varchar2(2) Key_ID Number Category Char(3) Create_date_time Date Hit_Num varchar2(8) Insert_date varchar2(40) Activity_code Varchar2(30) The data is arranged like this: Record...
  13. adventurous1

    Transposing row data to columns

    Hi all... Hopefully somebody can help me with this question.. I am trying to write a "simple" report to track the number of visitors and dwell time (total and per page) by page navigation for a user visiting a website. The problem is is that I have row level data that I need to convert to...
  14. adventurous1

    Spotting/flagging weekends for a comparison during two dates

    Another brain teaser from a newbie... I need to compare two dates, a TRIPSTARTDATE and TRIPENDDATE, to return a value to populate a Y/N flag in a column called INCL_WEEKEND. I am trying to accomplish this in a SQL statement but figure that it is better suited towards a PL/SQL function. Can...
  15. adventurous1

    Calculating a geographic radius from a zip code

    Help! I have a listing of hotel addresses, each with a zip code, latitude and longitude. I have another listing of customers with zip code, lat & longitude. I need to select all the customers that are within a 100 mile radius of each hotel. Can anyone help me do this in Oracle SQL or in...
  16. adventurous1

    Concatenating Repeating Row Data in a Single Column

    I need to be able to put all of the repeats into just one row of a table. Using a similar example, my source data looks like this: Field1 Field2 Field3 Joe Smith 555-555-5555 CogOrder1 Joe Smith 555-555-5555 CogOrder2 Joe Smith 555-555-5555 CogOrder3 Needed Output: Field1...

Part and Inventory Search

Back
Top