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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by chaoma

  1. chaoma

    merging row on date

    I have to merge this data to another table. This date must fall within the date on another tables. What I meant is if client changed address, did something else happen in the same period? Therefore, I think the data need to be group first before I can merge with another table. It's not...
  2. chaoma

    SQL question: least and most employed in a given period

    I think you said, who come and go the most/least. Select ID_NUM, MIN(CNT), MAX(CNT) FROM (select ID_NUM, count(*) as cnt) AS B
  3. chaoma

    merging row on date

    Hi, I hope someone can help here. Here is a sample data: ID StartDate EndDate ZipCode 1 20080101 20080128 90815 1 20080129 20080315 90815 1 20080316 Null 90819 2 20080201 20080415 90801 2 20080416 20080601 90802 2...
  4. chaoma

    Enterprise Manager Looping for Login

    Same thing. Thanks.
  5. chaoma

    Enterprise Manager Looping for Login

    Hi, I just start learning Oracle 10g. I just finished installing Oracle 10g Personal Edition on Windows XP (evalution copy). I have already setup the database (ORCL, SID=ORCL). I typed: emctl status dbconsole It said ORACLE_SID not define. So I defined it as: Set ORACLE_SID=ORCL I...
  6. chaoma

    MDF file too big 45 GB: how to split?

    My log file is much smaller than MDF file. It has always been set to "simple". I always schedule to have it shrink every week. But I'll try to truncate the log file to see how it will go. I should know by next week. Thank you for your assistance.
  7. chaoma

    MDF file too big 45 GB: how to split?

    I'll try: BACKUP databasename WITH TRUNCATE_ONLY How do I split this file into smaller files (instead of 45GB)? Thanks.
  8. chaoma

    MDF file too big 45 GB: how to split?

    Hello, I have a single mdf/ldf file for my database. Now it grows to 45 GB. About once a week, I got log file is full message. I tried to shrink database, but it takes too long. Is there anyway to split the file into muliple files? I don't need to backup my tables because the data get...
  9. chaoma

    export to text file with char(13)

    Mutley, Thank you again. You have save my day. I was going to write a more complex code. First, I thought your code doesn't work, but after a while it starts to make sense. Thanks.
  10. chaoma

    export to text file with char(13)

    Thanks.
  11. chaoma

    export to text file with char(13)

    I guess I have to write my code a different way. Thanks.
  12. chaoma

    export to text file with char(13)

    Char(10) did not help. Thank pjw001. Anymore idea?
  13. chaoma

    export to text file with char(13)

    Hello, I need to export this table to a text file. Here is how the table was created: Select row_id+ column1+ column2+ char(13)+ row_id+ column3 from my table With Char(13), it should split the data into 2 rows per record. However, after I export the...
  14. chaoma

    export to text file with char(13)

    Hello, I need to export this table to a text file. Here is how the table was created: Select row_id+ column1+ column2+ char(13)+ row_id+ column3 from my table With Char(13), it should split the data into 2 rows per record. However, after I export the...
  15. chaoma

    insert number 1,2,3,... into table

    ca8msm, Thanks for the hint. I modified my query as follow: select column1, column2 into NewTable from MyTable alter table NewTable add row_id int identity Again, thank you.
See more

Part and Inventory Search

Back
Top