Search results for query: *

Well Dave, It seems as if I've made a big to-do out of nothing here. Thanks for your time & efforts...

Thanks Dave - to move on... I've been working with the GROUP BY RollUp function and listed my code below: SELECT accountno, beginyr, sum(rate) AgtRate FROM table1 GROUP BY ROLLUP (accountno, beginyr) ORDER BY 1 The output that I receive is good, but there seems a be an total line added...

The columns are necessary to the output...but not to the calculations. How would you go about 'tricking' Oracle to have the data listed. I was just looking for a little assistance...I'm sorry if I upset you.

Hi Dave, The Rep and EndYr columns are not being grouped or calculated...so I would eliminate them? Or could the still be listed, without being grouped?

Hi Bill, I have 3 SQL reference books on my desk right now...and none mention anything about Cube or Rollup options... Could you please direct to a site that would have this information?

Hi Dave, The output that I am looking for should be something like AccounNo BeginYr EndYr Sum(Rate) 12345 1 1 100 12345 2 99 100 I suppose by adding the Rep column, it would mess up things a bit?

Hi All, I've run into an issue that I just can't phathom how to go about getting done... I have listed the information from the table below. What I am looking to do is group the information by AccountNo, BeginYr...then sum by the Rate...listing the Rep and End Yr columns: AccountNo Rep...

Thanks RJOUBERT, It worked perfectly! A star for you. Thanks for your help PHV. However, I haven't been able to get you suggestion to work yet...and time is of the essence. Although, I'm sure it 's my error Thanks to you both

I forgot to mention that I'm getting a run-time error '3464': Data type mismatch in criteria expression

Hi all, Awhile back, in 2003, there was already a post for the issue...but I can't seem to find it no matter how I search. I hope that someone remembers this oldie. The thread number was 702-563930... Anyway, my issue now is that I can't seem to search the db looking for a number. The number...

Hi Rudy, Thanks so much for the reply. I guess I scaled my example down too far for me to implement the premise into the acutual code. I've posted my actual code below. Falling short of asking you re-write it for me. How could I implement the nested selects and inner join into the mess that...

Hi all, I am in desparate need of some assistance with the following SQL statement. What I am attempting to accomplish is to have the Name, ID & Company listed, with the case count listed for each Company. SELECT a.name, a.id, b.company (SELECT count(c.cases) FROM table3 c WHERE...

Thank you for both of your suggestions...but I believe that I had posted this issue in the wrong. Albeit - I figured out something that works. It's not as clean as yours - but it works just fine...for now... Select t.table_name, (Select count(*) From table1) From all_tables t Where...

Hi all, I am looking to perform a comparison row count. I will take a count of all records in 20 different databases today. Next week, I would to perform the same fucntion. My adminstrators inform me that our all_table & all_indexes tables are only analyazed once a week, which will not...

Must be the stress of the EOY processing ô¿ô Multipy by 100 to remove the decimal points. My 5th grade teacher would be upset... Thanks PHV - you've saved my life again!! Thanks Zameer

Hi all, I've looked for 2 days now for something that I can use...but I'm running out of time here. I have a calculation which gives me some results, wherein, I need to massage the data to have it formatted in a distinct format. Calculation: 494,570.49 * .60 * .75 Answer...

Hi All, I have a complete mess on my hands here. I have been given a DB which has a column of values with leading zeros. To data is varying lengths...and also contain alpha characters. After looking all over this forum...I could only find resolutions that solve for numeric values alone. Is...

Hey Solun, I appreciate your response...but there is no way that any programmer should be building individual front ends for each of the users in the company. Do you realize the maintenance that would have to be done? Not to mention the roll-outs of new versions! Thanks again for your...

Hi all, I have a DB that is being utilized by several users at once. They all use the same form, which uses the same query...but with different filters. I'm having a problem with the Agency_Seq field. I have 30 different agencies, each agency could have any number of records...Agency_Seq...

Thanks to anyone who attempted to resolve my issue...I've figured it out. Thanks anyway