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 Rhinorhino 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: *

  • Users: PRMiller
  • Content: Threads
  • Order by date
  1. PRMiller

    Endless query after adding two variables

    Ok, I'm back with my ugly stored procedure. The looping problem has been solved, but I've ran into another roadblock. As I loop incrementally through records in a temp table, I insert new records to fill in the gaps. Here's that snippet of code: INSERT INTO #TEMP1...
  2. PRMiller

    Problem with nested WHILE statement, looping through recordset

    On a post at http://www.tek-tips.com/viewthread.cfm?qid=926902, DSect pasted some code to loop through a recordset. I understand that looping tends to be pretty hard on the server, but so far this is the only solution I've been able to identify. Unfortunately (and, of course), I have a problem...
  3. PRMiller

    xp_sendmail and attachments

    Having trouble sending an attachment from the query analyzer using xp_sendmail. Here's my code: EXEC master..xp_sendmail @recipients = 'me@mymail.com', @subject = 'Snapshot', @attachments = 'c:\Off-Line\Snapshot\rpt_Snapshot.snp' I receive the error "xp_sendmail: failed with mail error...
  4. PRMiller

    Problem with CURDATE()

    Hi all, I have a DTS package pulling data from TotalView's IEX database. While I haven't been able to get a straight answer on the type of database IEX uses, I can tell you that my DSN uses the Simba Client driver. I am having a problem querying records by date. Specifically, I am pulling...
  5. PRMiller

    DTS Error: "Too many columns found in the current row"

    Afternoon, Having a problem importing a text file using DTS. I have not run into this before. My source is a pipe-delimited file with no text qualifiers. Sample of the data: Extension|Name|Vector Number|Measured|Acceptable Service Level|BSR Application|BSR Agent Strategy...
  6. PRMiller

    Advice on building a table

    I am creating a database that will outline call routing for thousands of toll-free numbers. My data looks like this: Policy # Account Name Toll Free Number 11111 ABC Company 800-111-2222 22222 DEF Corp 805-111-3333 Of course, there are about 40 additional columns of data...
  7. PRMiller

    Using LEFT function in a DTS ActiveX script

    Hello, I am importing 9 text files to a staging table. My text files each come from a different source system (each at a different facility), although they have identical formats. As I load each row into the the staging table, I add a foreign key value and dump the staging table into...
  8. PRMiller

    Error running a stored procedure from Access

    I am attempting, for the first time (well, more like 63rd time today...) to call an SQL Server stored procedure from Microsoft Access. I started by copying code from http://www.tek-tips.com/viewthread.cfm?qid=904798. Here's what I pulled in: Private Sub cmdGo_Click() Dim cnn As New...
  9. PRMiller

    Problem opening a form with a filter

    Greetings, Having a bit of a problem passing a filter from one form to another. I am returning a preview, if you will, of a large recordset to a form I call "frm_Search_Results". The user selects a record by clicking a > button. The button is supposed to set a filter, close the form, and...
  10. PRMiller

    UPDATE query with JOIN and where

    Having a problem getting an update query to work. What's really odd is that I can do this in Access, but not in Enterprise Manager. The query analyzer parses it correctly, but I receive the error "Invalid column name 'split'" when attempting to run with SQL. Here's the query: update prod...
  11. PRMiller

    Query by client or DNIS

    We are using Witness v6.4 with the SQL back-end. I am looking for a way to query evaluations by client. In looking at the EVALUATIONS table, I found a field labeled CUST_CONT_PK. I traced that to the CUST_CONT field, which contains a CONT_GUID, NAME, and DESCRIPTION, among others. The name...
  12. PRMiller

    Data-Mining: XP v NT rounding Witness table numbers?

    Has anyone experience a problem with some systems rounding numbers retrieved through queries, but other systems not? For example, one of my users is on Windows NT, while I am using Windows XP. I am using Access 2002 to query records. A number returned from a query and placed on a report...
  13. PRMiller

    Help connecting to a SyBase database

    I'm having some problems connecting to a Sybase database. I lifted a connection string from www.connectionstrings.com but have been having problems getting it to work. I've searched through the posts on the site and checked out issues other users have been facing, but none of the solutions...
  14. PRMiller

    Multiple matches as one recordset

    I am having trouble with the correct syntax for a multi-select problem. I have a query driven by a form. The form allows users to search by client, which is abbreviated as "DIV." The DIV is a three-character abbreviation, consisting of letters and numbers. If a user wants records only for a...
  15. PRMiller

    Form doesn't close... sometimes

    I'm having a rather odd problem. I have a form, called "frmScorecard" that accepts input from a user. On click, it checks to see if a record matching the criteria entered by the user exists. If a record does not exist, it calls a procedure, then closes itself (the form) and opens a...
  16. PRMiller

    Witness/eQuality system

    Good afternoon, I originally posted this question an Avaya forum, which was, of course, the wrong place to do so! This seems to be the most appropriate forum to post this question in, based on the results of my search. I am looking for users who have attempted some data mining of the Witness...
  17. PRMiller

    Rotate entire report

    Good evening, I have a "continuous report" that can grow to an infite length depending on the number of records. Due to design parameters, the report needs to grow horizontally. Here's an example: Rec Item1 Item2 Item3 Item4 1 2 3 4 With data being populated under Item1 through Item4...
  18. PRMiller

    Determine result based on mixed number of variables

    Good afternoon, I have been struggling with this issue for a while and am finally being smart enough to ask for help. I have a database application used to measure performance for customer service reps. One aspect of their performance measurement is productivity. Reps take a variety of phone...
  19. PRMiller

    Type Conversion Error with InStr and a date field

    Queries and I are NOT getting along well this week... Attempting to run an append query from one table to another. The selected table has a field labeled "EmpHireDate." It is a Date/Time data type with an input mask of 99/99/0000;0;_ I am attempting to split the date into month, day, and...
  20. PRMiller

    Very odd Loop problem

    I have the following code set up in my database: Dim dDate As Date Dim sCurrentTime As String Dim sEventTime As String dDate = Date + 1 sTime = "03:00:00 AM" sEventTime = dDate & " " & sTime Do Until sCurrentTime > sEventTime sCurrentTime = FormatDateTime(Now(), vbGeneralDate) Loop...

Part and Inventory Search

Back
Top