Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pkohli8
  • Order by date
  1. pkohli8

    Reverse Table

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

    Reverse Table

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

    Reverse Table

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

    Reverse Table

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

    Reverse the CSV column(One to many relation)

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

    Query On One data point per records

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

    replace Regular Expression

    Thanks!!!!!!!!!! It worked Perfectly
  8. pkohli8

    replace Regular Expression

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

    replace Regular Expression

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

    200 Field Report

    yes it runs successfully in TOAD
  11. pkohli8

    Schedule for Last Business day of month

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

    200 Field Report

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

    add value to one record based on another record

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

    add value to one record based on another record

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

    add value to one record based on another record

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

    add value to one record based on another record

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

    Poblem with query

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

    add value to one record based on another record

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

    add value to one record based on another record

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

    add value to one record based on another record

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

Part and Inventory Search

Back
Top