>>I got:
>>Operand data type datetime is invalid for sum operator.
>>Because DATETIME1 - DATETIME2 is also datetime.
>>
>>DECLARE @Test TABLE (Fld1 datetime, Fld2 datetime)
>>DECLARE @i int
>>SET @i = 0
>>WHILE @i < 20
>> BEGIN
>> INSERT INTO @Test VALUES (GETDATE()+@i, GETDATE()+@i*20)
>> SET @i = @i +1
>> END
>>SELECT SUM(Fld2-Fld2) FROM @Test
>>
>
>I've no,idea what you're talking about :)
ROFL
Yep, now you haven't :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
