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

  • Users: dobe1
  • Order by date
  1. dobe1

    Jet SQL RTRIM Doesn't work

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

    Jet SQL RTRIM Doesn't work

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

    Jet SQL RTRIM Doesn't work

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

    Jet SQL RTRIM Doesn't work

    BTW, this is Access 2003
  5. dobe1

    Jet SQL RTRIM Doesn't work

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

    How do I Seed an AutoIncrement Number

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

    How do I Seed an AutoIncrement Number

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

    How do I Seed an AutoIncrement Number

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

    How do I Seed an AutoIncrement Number

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

    How do I Seed an AutoIncrement Number

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

    Price Check

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

    Recursive With

    Thanks, Dobe
  13. dobe1

    Recursive With

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

    Help on Update with a Join

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

    Help on Update with a Join

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

    Help on Update with a Join

    Yes see 1 Feb 07 15:49
  17. dobe1

    Help on Update with a Join

    How do you edit the post?
  18. dobe1

    Help on Update with a Join

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

    Help on Update with a Join

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

    Help on Update with a Join

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

Part and Inventory Search

Back
Top