Search results for query: *

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

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

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

Same thing. Thanks.

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

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.

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

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

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.

Thanks.

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

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

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

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

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.

This might be an easy question, but I cannot find help anywhere. I have a table and need to insert a sequential number starting from one for all rows in my table. I tried this but, it give some weird nubmer. Select newid() as row_id, Column1, Column2 into NewTable From...

Thank you Bill. I cannot upgrade. Windows XP only like PE.

Hello, Microsoft SQL 2000 Server Agent refuses to run after the 8th jobs already running. Is anyone know how to overcome this limitation. I am using Windows XP, MS SQL 2000 Personal Edition. Thanks

I want to write a store procedure that will accept any cursor name. Microsoft SQL 2000 cusor is global. If I want to call this store procedure 10 times almost simultaneouly, I need to have different cursors. I hope you understand me on this one. Anyway, how would I use @PrimaryKey in EXEC...

I forgot to mention that I am using SQL 2000. Thanks.