Recent content by toblerone65

Thank you fisheromacse , a very good idea.

Hello everyone, need some help to build a logic formula. I have 3 groups and sample data as below GH1 CA GH2 Santa Barbara GH3 94015 Det 10 S RA 20 A PA 30 S JA where ever I have Value as S in second column, i need to sum up those values separated by / and show data like below 10 S RA/JA 20...

Hello everyone, need some help to build a logic formula. I have 3 groups and sample data as below GH1 CA GH2 Santa Barbara GH3 94015 Det 10 S RA 20 A PA 30 S JA where ever I have Value as S in second column, i need to sum up those values separated by / and show...

It works like charm thanks so much.

Friends need help on doing a running total like reset on Previous function Example: AA CA 123 AA CA 101 AA CA 341 AA MD 231 AA MD 222 should be shown as AA CA AA CA 123 AA CA 101 AA MD AA MD 231 1st and 2nd fields are groups. and first value of previous should be null. Any help...

Hello I have a simple store procedure whihc is created to insert records into other table. I like to execute this store procedure from Crystal reports command statement. It does not have any parameters. I use Oracle and Crystal 2008. When i say exec ABC in command, it throws error. Any help...

Problem was with access , direct access to the tables...seems for store proc i need direct access to the tables. Now it is working fine. Besides that I am creating this store proc because my query was running very slow I was using DB links to. I was told instead if i use store proc or...

I have created below but i get same error when i execute the procedure. BUt when i remove the table to DUAL it runs fine, when ever i use real table i get error. CREATE OR REPLACE PROCEDURE ritheshest IS Emp_number integer; BEGIN SELECT count(distinct BCBS_ASSOC_PLN_CD) INTO...

Thank you all, I will try the above solution, I am new to store procs in Oracle. I will rephrase my store proc in above format

Hello thanks for quick reply. I am new to store procedures since my select statement was running slow, i thought I will create Store procedure on my select so that it might help fasten the query. I get below error. ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in...

Hello I have a created a store proc on a simple store proc, but i get error , please help CREATE OR REPLACE PROCEDURE p_procedure2 IS BEGIN Select PROVIDER.PROV_ID_NBR, IDS.PROVIDER_TYPE_SPECIALTY.PROV_TYP_SPCL_USG_CD_SK, PROVIDER.PROV_FULL_NM, IDSXREF.PROV_TYP_SPCL_XREF.PROV_TYP_CD FROM...

Friends I have multiple subreports and places in different headers. One of the subreport has less data and has lot of blank space, i tried supress blank space, but i can still lot of blank space in the bottom, any way to supress it?

LB only problem how will it know min and max on string field.I did other way i did difference on the currenttimestamp and datetime field and converted the difference value to text and attached into colum 2 totext(@diff)+" "+field2 which is a string. Then i was able to do min and max since it has...

Hi friends Need help on below, I have records like this T1 abc1 10/20/1008 8.00.00 T1 abc3 10/20/1008 10.00.00 I want to show this as t1 abc1 abc3 Basically i like to min and max of recirds for the time stamp. Max(column2,datetime), etc Any help on this?

LB it works like charm whenver it has .com it would grab only till .com or else returing the original value. Thanks!