Check the strored procs and front-end code that you use to insert data for a bug that may be causing this.

If you are not allowed to have duplicates of IDs...

You will need to run through the setup process again to create an instance, if you have access to the SQL server install disks then run through these again.

you are using the text data type so you will need to cast to varchar to convert

UPDATE tbl1847

SET ...

try this code to update

Update tbl1847

Set YourFieldName = '00' + YourFieldName

I was unsure what your field name was, so subititue it in..

this should get you the latest value based on time-stamp

SELECT top 1 *

FROM YourTable

ORDER BY timestamp DESC;

do you have any indexes for data1 and data2?

how many rows are in the table?

if there are no rows in your table for def----failure and ghi---succes then it will not be able to cout these at all.

do you have a master table that...

How big is the table?

What indexes do you have defined?

clive.norman (8/13/2008)

---

I have just thought of hopefully one last question

If all I need is SQL Server why do I need C#? AS alot of books seem to indicate.

Look forward to...

try casting the weeks to integers

Select Property_Name, Sum(cast(week_1 as int) + cast(week_2 as int) + cast(week_3 as int) + cast(week_4 as int))

from Profit_Records

where Type_Property = 'CASTLE'

Group by Property_Name

I think this is what you want

Select Property_Name, Sum(week_1 + week_2 + week_3 + week_4)

from Profit_Records

where Type_Property = 'CASTLE'

Group by Property_Name

I have done something similar using PATINDEX and a while loop, try this code.

DECLARE @i int

DECLARE @String varchar(100)

SET @string ='Starsky & Hutch Ltd.'

SET @i = (SELECT PATINDEX('%[^a-z^0-9 ]%', @String))

WHILE...

It looks like it is an issue with the data that is currently in the tables, are you able to clear out the tables then create the relationship?

ISNULL requires two arguments;

ISNULL ( check_expression , replacement_value )

so to replace the value ISNULL as 0 use

ISNULL([T_ICPAudit.Amount],0)

Enable SQL browser on the SQL server..