Search results for query: *

Thanks, but this will not be a one time shot.

I just tried the above and it did not work. What I did do that worked was: update table set field = mid(field1,1, instrrev(field1," ")-1) fortunately there was a space just before the "wierd Y's". I will try your (the above) code again. It is one I would like to keep in my library, if I...

COMBS ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ I brought this data into my GIS, and found the padding actually to be the series of "y's" with a colon on top. How do I get rid of this.

BTW, this is Access 2003

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

Unfortunately, I cannot see where I can edit this post. The last post should have read " I had hoped from my descripton of the above that it were obvious I was using a flat file.....yada yada yada

PHV, I had hoped from my description of the above, that I was using a simple flat file in order to populate these values outside of our enterprise system. Again, The flat file resides within MS Access. The values well be inserted into our enterprise system. Dobe

PHV, I am afraid this resulted in the seed being 1, and from there the last record was N+1, where N = record number. The 500000 did not act as a see.

These are customers from a possible acquistion. Our enterprise system has a self generating field, which assigns customer numbers. Therefore, I need to take the highest possible value, and self generate from there. I suppose a better way would have been to simple populate the field with...

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

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

Thanks again for your patience and your indepth help. I must close down for the day. I will be with y'all tomorrow. Dobe

No, actually, I wish to have an update query call the Days_Current query. In order to do this, it would make no sense to have the "into" statement in the code. I only put the "into" statement in the code in order to test the possibility of the problem being a reference to the query vs. a...

Yes see 1 Feb 07 15:49

How do you edit the post?

What the above code does: I am given a list of customers, whose day(s) of service may be M, W, F, etc. If the customer is being service M, W, F, there will be a 1, in the day_ field in one record, a 3 in the day_ field of the second record, and a 3 in the last record. In other words, there is...

I did place an "into" statement in there so that I could see, if it would run from a table...to no avail. Dobe

SELECT custid, (Mon & Tue & Wed & Thu & Fri & Sat & Sun) AS CurrentDays FROM [SELECT custid, sum(day_1) AS Mon, sum(day_2) AS Tue, Sum(day_3) AS Wed, sum(day_4) AS Thu, sum(day_5) AS Fri, Sum(day_6) AS Sat, Sum(day_7) AS Sun from( SELECT custid, switch(day_ = 1, '1') as Day_1, switch(day_ =...