Search results for query: *

I need to remove padded spaces from several fields, and the Trim(Name) and RTrim(Name) does not remove the spaces. Any suggestions?

I have a table with 16,000 pre-existing records. I wish to simply go into the design view, add a field auto increment, and seed the starting point at 500,000. How can I do this? Thanks in advance, Dobe

Moderators, I appologize in advance if this is not in the correct forum. I need to know what it would cost to purchase SQL Server 2005 for six seats. From whom do most IT pros buy this type of software? Thanks, Dobe

Hi, I'm trying to use the following code, which a sample I found is "SQL Cookbook" by Anthony Molinaro. with x (cname,ccust#) as ( select cast(cname as varchar(100)), ccust# from cust_table where cmstc# = 0 union all select cast(x.cname + ' - ' + e.cname as varchar(100)), e.ccust#...

Need some expert help please. I am attempting to update a table in MS Access with values from another table. I have attempted the following: UPDATE x AS a SET a.c_days = (select b.currentdays from Days_Current b where...

I have a table, which has over 5 million records in it. I have been attempting to delete all but about 1/2 million records. The deletion, indexed on the datetime field takes in excess of 20 hours. I must stop it at this point. I have decided to truncate the table. My question is this. Upon...

I am working with a table where customers have multiple days of service. For example, a customer may be serviced 1, 3, and 5 (Monday, Wednesday, Friday). The problem is that there may be three records for that customer and in the "day" field, there will be a 1 or 2, etc. Of course, in some...

I am trying to to locate the last word in a string. I have a list of street names with suffix, and wish to find the suffixes. For example in : St. Marlow CT Bridgstone Prkwy John Monroe St If I were looking for the index of the first space, this would be easy. I would use the following code...

I wish to concatenate several records' data into one field within one record. I know how to do this in Excel, but would prefer this in Access SQL only. Thanks, Dobe Example: Given............ cust_id Day-of-service 0001 1 0001 3 0001 5...

Hello, An employee of mine is attempting to load jpegs into Access by means of pointing to the field | right mouse click| insert object | create from file | browse | and load the object. It comes back into the field as a "package". I do not have the same problem on my PC and in Access. The...

I am trying to convert the implicit join below in Access 2000: SELECT a.vendor_name, b.first_name + " " + b.last_name AS name, c.number, d.type FROM vendor AS a, employees AS b, empl_phone AS c, phone_types AS d WHERE a.vendor_id=b.vendor_id And b.ven_empl_id=c.ven_empl_id And...

Upon executing this code: select a.ccmpny, b.rdrout from cust_table a join rdtl_table b on a.ccmpny + cast(a.ccust# as char) = b.rdcomp + cast(b.rdcust as char) where a.ccmpny in ('93', '95') and a.ccycle <> 'cr' group by a.ccmpny, b.rdrout order by a.ccmpny, b.rdrout I receive the following...

Need a little help on something that is probably elementary. I have tried the following update: Update cust_table set cbildt_1 = cast(cbildt as datetime) cbildt is a decimal 8,0, and the data is a format of i.e. 20050131. There are also some 0 (zero) values. This is the error that I get...

Using a legacy database, I have pulled tables into sql server. There is a date field and a time field, both are decimal(8). I would like to somehow concatenate them into a datetime column. I can convert the date field easily enough. The time field has been recorded in military time, not...

I have some experience with SQL queries in Access. I will be using SQL Server soon, and will be taking a five day class in February. I would appreciate a book recommendation on SQL Server based upon my limited experiences. Thank you in advance, Dobe

I am attempting in SQL ONLY to eliminate any duplicate records. I have the following two fields, with which I am working. Dynamap_id is the field, which is duplicated as many a three times per dynamap_id number. The other field is recnum. This field is unique, and will later aid me is...

What I hope to learn: I am looking for an SQL way (in Access) to find the numeric week of the month. In other words 1st, 2nd, 3rd, etc week of the month. The criterion is that the week must be a full week, and must extend to a full 7 days. I have data that must be reported by the week. I...