Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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