I followed your instructions explicitly using SQL Enterprise Manager. I
executed each "segment" separately and in the same order. By "segment", I
refer to the instructions between each GO statement.
There now exists a table called "CallDetails". I ran your scripts
yesterday. The new table is empty.
Since running your script, the Calls On-Line in Emerald no longer works.
I appreciate the theory in the new table and have no problem with using it
- if I can get it to work.
Further help please.
>> I have in mind creating a new database each month called "nov_1998" or
>> something similar and then using the Transfer Management Interface to copy
>> the data into there from Emerald for future reference/use. The book i have
>> seems to use the word "move" and "copy" as if they meant one and the same
>> thing!!!! If I do take this course of action, will I delete the data
>> information in Emerald?
>
>If you break down the data into multiple table like that, then you
>can't do a query to summarize more than one month, with taking
>additional
>steps to include all the little tables.
>
Agreed however I don't perceive this as an issue as the table itself will
be accessible from my web site so users can checkup their time used
themselves. The only time the table will be used is when someone challenges
their bill for a particular month.
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet<>Fidonet needs
<>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailer
voice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930
http://www.aquarius.com.au <> mailto:sales@aquarius.com.au