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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gkrenton

  1. gkrenton

    Copying 1 table to training DB

    I have a table that I resides in my live DB but not in my test DB. I can't figure out what the sql syntax would be to copy the table from the one instance to the other. MS Sql looks like it would be something like this insert into ol_rentontrain.atb.ren_custom_tran select *...
  2. gkrenton

    Cumulative Addition in Query?

    Thanks I've been reading the ms knowledge bases all friggin day before I made this post. Guess I must be 'slow' but when I use dsum in this query the results INSTEAD of getting 51749 I'm getting 126618345 using this syntax BegData2...
  3. gkrenton

    Cumulative Addition in Query?

    Hmm, not familiar with dsum but when I put dsum in the 'else' statement the numbers go insanely huge. I got this dlookup statement to sort of work EXCEPT it's adding the 'negative' week1 # to the cum vs subtracting BegData...
  4. gkrenton

    Cumulative Addition in Query?

    I'm trying to create rolling weekly onhand numbers. I've gotten week 1 figured out but am now trying to figure out how to calculate the inventory position for week 2 by adding data to week 1. I have 2 tables being pulled used: PYactuals which has the weekly data BOM which has the beg year...
  5. gkrenton

    Remove ' from Character Field

    Holy Cow - you're all fast! All workable solutions - I tried replace but didnt' have enough ' based on these examples. Thanks - you've all made my day a bit brighter. gina
  6. gkrenton

    Remove ' from Character Field

    I'm creating some data to export to a flat text file interface. I've been asked to do either remove the single quotes that reside in the description field OR add double qoutes around the output. select 1 as Division, substring (ca_id from 1 for 1) as dept, (ca_desc) from category where...
  7. gkrenton

    SED last delimiter from unload file

    Thanks - guess I didn't pick that up in all the documents & online resourcs I've perused over the last day & half trying to figure it out. Good to know for future use. gina
  8. gkrenton

    SED last delimiter from unload file

    I think I stumbled upon it - this seems to work sed -'s/,$//' onorderold.txt > onordernew.txt guess e was a red herring. - gina
  9. gkrenton

    SED last delimiter from unload file

    Hadn't tried it but still have comma's at the end of the line. I've typed: sed -e '$s/$,//' dsonorder.txt > dsonodernc.txt & results are the same 11,002,6,075,30.0,2399.7,1110.0, 17,098,1,010,0.0,0.0,0.0, Got another idea? thanks gina
  10. gkrenton

    SED last delimiter from unload file

    I've created a script that unloads a file as a comma-delimited txt file (orderfile.txt). The gotcha is that after the last record there is a comma that I need to remove. IE The comma at the end of the line as shown below. 9,002,7,095,92.0,2318.08,1025.45, 11,899,6,075,0.0,0.0,0.0...
  11. gkrenton

    Case statement in Where Clause

    Not updating the table just puttind the data into the current week. So only that you wish to show 3/9/2007 for a PO_promise of 2/10/2007 which will then assign week 5 to this data vs week 2. Which your case statement as shown above does! Hot diggety dog! I see where my problem understanding how...
  12. gkrenton

    Case statement in Where Clause

    Unfortunately that doesn't quite do it. Po_promise date that's in the past needs to be assigned to the current week assignment. The suggested code works but keeps data assigned o the week in which is was originally assigned to ie PO_promise of 2/10/2007 still reports out was week 2 vs showing...
  13. gkrenton

    Case statement in Where Clause

    I have a query that works except I need to do a date evalution that takes any document that falls before the current period & puts it into the current period. I'm stumped as to how add this case statement case when P.po_promise < today then today else P.po_promise end to the where clause...
  14. gkrenton

    Sun-Sat Date calculation

    Thanks - that got me past the brain jam. gina
  15. gkrenton

    Sun-Sat Date calculation

    I'm sure I'm missing the obvious reading through faq 701-4230 & the numerous other date posts here but for the life of me my brain isn't getting it. I have a table where all 52 weeks of the year are accounted for Sun-Sat for expample. In the table there is a record for week 4 which is defined...
See more

Part and Inventory Search

Back
Top