Recent content by gkrenton

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

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

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

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

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

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

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

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

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

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

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

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

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

Thanks - that got me past the brain jam. gina

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