Search results for query: *

it is clipped portion of large formula. I just wanted to get idea accross. at this point i dont want to re write all the formulas again. I wonder if there is a better solution out there that will skip same amount of rows in each copied formula. thanks

I have a forumla like below =IF(AND('Publish Tracking'!$E95) Cell# 1 =IF(AND('Publish Tracking'!$E102) cell# 2 The above formula is skipping 7 rows every time. Now if i have to copy this formula down to many rows. it will not skip same number of rows (i.e 7rows) every time. instead it...

no

I have spreadsheet like belwo 123 123 124 128 125 127 //problem column above is higher 125 130 130 138 GOOD BAD what will be the formula to validate if above 5 columns is in assending order. Meaning column below is not higher then column above. They can be equal but column...

if i change below substr(output_svycode_NM,1,4) as SI and i can get seperate segment. However i still want to combine anything that is 29U* except 29UT is my delemma.

Thanks for all your help on this. I need one more thing with it. select substr(output_svycode_NM,1,2) as SI, TO_CHAR(TRUNC(batch_release_dt,'IW'),'FMMonDD')||'-'|| TO_CHAR(TRUNC(batch_release_dt,'IW')+6,'FMMonDD') week_sent, SUM(PROCESSING_BATCHSIZE_QTY) AS LOADS...

i tried column SHIP_ID format 9999 still same results SHIP_ID ------- 74 no change.

I have a numeric filed called Ship_ID in table which is typ VARCHAR2(6) When i desplay the result of my query it displays in following format SHIP_ID ---------- 72 The width is 10 space long. I will not exceed for short term width more then 4 spaces. How can i reduce the size of...

ok i figure it out it works. i had pagesize set to 0 i removed it. The column headings only displays as per columns. Is there a way to display full column headings regardless of field length.

i did this for some reason it just wont show title when i do break on sent_date skip 3 it does skip 3 lines after each sent_date however when i do page it does not do anythign. No titel is displayed anywhere.

ok i figured out the nvl part. Only thing required now is the column headings.

oh and i forgot to ask what do i have to do to get column title displayed on each set of records which is group by send date. So if send date changes break 2 and display column headings again.

thanks whats the syntax to use nvl with sum

here is sample output ship_id out in diff date 33Z 25563 25563 0 Fri-06-Mar-2009 09 33Y 5615 5615 0 Fri-06-Mar-2009 09 33K 61 Fri-06-Mar-2009 09 The above field diff calculate when column "in" is present. however when column...

thanks only 1 issue with above query. It does the math and returns a number when sum(out_parts) is present. However is sum(out_parts)=0 then it gives me no result. Is there way i can get a result every time.

select shipment_id as ship_id, sum(in_parts) as parts_recieved, sum(out_parts) as parts_sold, to_char(sent_date, 'DD-Mon-YYYY') as setn_date From parts_table where set_id like '33%' group...

select substr(output_svycode_NM,1,2) as SI, SUM(PROCESSING_BATCHSIZE_QTY) AS LOADS, to_char(batch_release_dt,'IW') WK from PARTS_DATABSE where (OUTPUT_SVYCODE_NM like '29%') and batch_release_dt >='02-FEB-09' and batch_release_dt <'27-DEC-09' group by...

Great thanks for the help. i use the #1 trunc option.

Hi everyone when i run below query it is not selection data for Feb 28 even though my scrpt says less then equal to. Any help select substr(output_svycode_NM,1,2) as SI, SUM(PROCESSING_BATCHSIZE_QTY) AS LOADS, to_char(batch_release_dt,'IW') WK from PARTS_DATABSE where...

I am building new pc and having few issues need help. motherboard==> ASUS P6T I have installed, cpu, memory, powersupply, hard drive, video card, sound card. I am getting 2 beeps and then computer stays on without any display. secondly when i try turning the computer off by holding power...