Search results for query: *

Thanks Musafa, by CODE i meant how can format CODE, I have that figured out by myself, I have to use Use TGML (Tecumseh Group Mark-up Language) to format, Thanks In Advance for your help..looking forward to your reply

Hi Mufasa, Thanks for quick reply, Is it possible to normalize the above table without creating any procedure or function, I am thinking if you can tell me, Then i can give normalized result to my manager and tell this is the best i can get from existing table. one more thing...how...

Hi Mufasa, Thanks for the reponse, I do not have control over database structure. I am just a report designer and i have only READ ONLY access to database. So, manager asked me if i can generate a report in the format explained in the previous post, that will be good. But, yeah I know...

Hi, I have this table that contains Names and in other column, I have list of groups that person belongs to in CSV format. This might be possible that many person can belong to one group. so, what i am looking for is the reverse of the table. I want to list individual...

Hi, I have this table that contains Names and in other column, I have list of groups that person belongs to in CSV format. This might be possible that many person can belong to one group. so, what i am looking for is the reverse of the table. I want to list individual...

Hi, I have table in this form SAY TABLE upload_id col_name Value Row 13668 SS_ID 112 1 13668 AK DLP-2 1 13676 SS_ID 113 4 13676 AJ HP 4 13676 AK DSP-1 4 14576 SS_ID...

Thanks!!!!!!!!!! It worked Perfectly

Hi SantaMufasa, Thanks for your reply, I know its very poor table design, but the table was created considering other factors...right now I just have to create a report that requires a breakdown of above second column into seprate columns e.g TEAMS Departments ABDteam...

Hi, I have one table with two columns in one column Names of different Teams are stored and in other columns ....different departments are stored, basically these departments are divided into 3 categories say category 1, category 2, category 3 and are stored in second column in this format...

yes it runs successfully in TOAD

Hi, Is there any way to schedule Report for LAST BUSINESS day of month? Thanks

Hi, i have to generate report that includes almost 200 fields and for that i am using SQL query in the COMMAND. but as soon as after writing SQL query in Command, I hit OK, the crytal closes automatically. can anybdy tell , is there any limitation on the number of fields in CR or is...

Hi Musfasa, Thanks Very Much, Its Perfect ...

here is the sample data SS_ID Asset_Center Time 271620 CENTRAL TECHNOLOGY 7/23/2006 4:12:32 AM 271620 CENTRAL TECHNOLOGY 7/23/2006 4:12:33 AM 50805 ASSET 7/23/2006 3:29:37 AM 50805 TREASURY AND SECURITIES 7/23/2006 3:29:38 AM 50805 CENTRAL TECHNOLOGY AND...

Hi Santa, The example that i have given was simliar to the work assignment , i thgt it would be easier to understand problem with simple example. If you want to know the exact sample data from my work problem i can provide that... here is the table, I have table that includes following...

Hi, I have a table that has 3 fields Field A Field B Field C 101 Apple 3/2/06 3:00 AM 101 Orange 3/2/06 4:00 AM 101 Banana 3/2/06 9:00 AM 102 Orange 3/2/06 4:00 AM 102 Grapes 3/2/06 5:00 AM 102 Orange 3/2/06 10:00 AM 103...

Hi, i have table that following fields ID Name Value Record 11 Sname Peter 1 11 Age 38 1 11 Height 62 1 11 Weight 78 1 12 Sname Sam 2 12 Age 27 2 12 Height 59 2 12 Weight 89 2 13...

Hi, I already have this data for several last months and i need to generate on demand report, to show the number of times one record gets updated (between two dates) and what was the previous value for that record before its got updated. so i was thinking of creating a table where i can...

Hi, Thanks for the reply, I have a table that has 3 fields Field A Field B Field C 101 Apple 3/2/06 3:00 AM 101 Orange 3/2/06 4:00 AM 101 Banana 3/2/06 9:00 AM 102 Orange 3/2/06 4:00 AM 102 Grapes...

Hi, I have a table that has following fields field A, Field B, Field C(Time) for example Field A Field B Field C 102 Apple 3:00 AM 102 Orange 3:15 AM 102 Banana 4:00 Am 300 Grapes 1:00...