Decimal Place incorrect

[JustineB]

Hi
I have a database on SQL Server 7.0

Every week for the last 2 months, the data has successfully loaded overnight on a Sunday. Our database is a rolling 4 week database with the oldest week of data being replaced by the most recent. Each week creates around 1.5 million records.

A manual divide by 100 is done in one of the programs prior to loading the data, but for some reason for the last 2 weeks the fiigures are showing as though this part of the code has been removed.

eg:

10.99 is being displayed at 1099

On looking into the database, the only thing that I can see is that the default filegroup on tempdb is full.
Would this be effecting the way in which the data is displayed? and if so what can I do about it? should we be dropping tempdb prior to each dataload?

Any help greatfully received.

Justine

 

[fluteplr]

No that would not cause what you are seeing. It may however be causing other problems.

 

[JustineB]

Hi - thanks for the reply

Can you expand on what other problems it may be causing? Do you also have any idea about what may be causing the problems with the decimal places?

Many thanks.
Justine