Have a look at another thread at

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15767&FORUM_ID=5&CAT_ID=1&Topic_Title=Database+Log+File+full&Forum_Title=Administration

Change the column EventClass to INT.

Maybe the info is already available in a table/view/schema

Create Table EventClassTable(Event_Number varchar(10),Event_Name VarChar(100),Description Varchar(300))

GO

Set NoCount...

What is the size of the database and is a log file size of 30Gb normal?

See there is even a 120GB external drive

TO latch onto what spongemagnet is saying, remember a problem with an Invoice Age Analysis sp with which I ran into trouble with on 6.5. After some MS help decided...

I'll also go the DTS route, can also compress CSV files. A slow possibility is to use a public domain stored procedure tot select the data and create SQL insert...

Hope it helps a bit.

Set NoCount on

Go

Create Table Hits(LeDate int,aHits Int)

Go

Insert Hits values (1,100)

Insert Hits values(2,125)

Insert Hits values(3,145)

Insert Hits values(3,155)

Insert Hits values(4,165)

Insert Hits values(5,100)

Insert Hits values(6,125)

Insert...

Not much but have a look at http://dbforums.com/arch/72/2002/12/635572

Can do a 'not exists' but prefer Antares686 solution.

Forgotten, will it always be a one to one relationship?

Will it be always a single branch relationship (one to one)?

How many records get loaded and how frequently is the table accessed.

Can do update stats, etc. after load.

Try something like

Case When R1=1 Then (SELECT Top 1 English FROM TableR1) Else '' End

If I understand the problem correctly, how many levels can this go one?

After ?? time periods F -> E -> D -> C -> B-> A etc.

quote:

---

our knowledge is good but we could do with having access to real expertise

---

What about...