I use Nero and just got nero to burn the image to a CD.  No Problem with CD.

Thanks Frank. 

This did help, except for the numbers and precision I am using, but now i can work around the situation.

One other thing to Remember, a Null <> Null so you could have the Following Row a, b, c, Null, d in the table  And sitll insert a, b, c, null,...

There is something a bit odd in this Trigger. MAybe I do not quiet understand what you are trying to do.

If it is triggered by an update statement the Row...

In That Case You Are Looking for:

Select

[Product Code],     [Part#]

,Month = Convert( Varchar(7), [Replacement Date], 120 )

,Qty = Sum( [Replacement Qty] )

From SourceTable

Your Question is a bit vague.  Please post the source table structure and what the results should look like.

Simply add This:

CompletedReq = Sum( Completed )

,UnCompleted =  count(ClientGroup.fk_clientid)  - Sum( Task.Completed )

or

,UnCompleted =  Sum(

   Case Task.Completed

)

Why not just

Where a.Dt >= b.StartDt

And  a.Dt <= b.EndDt

Sql's Datetime datatype is treated as one.

HI. Thanks foor the esponse. I have tried this. Even at Complexity levels below 0.1( highly likely to cause a split) the tree is Very short. I...

Reading your mail made me go Check Some Settings, and you were spot on. My Desktop did not have Permissions on the Sorce SqL DataBase. Thanks, Pretty Dumb...

All Done through AS Using NT Authentication

I had the same problem and also tried the instructions given in BOL. We had to Reboot the server ( not just restart the Service ) in order to...

instead of

where (@P1 is null or table.p1=@P1) and

(@P2 is null or table.p2=@P2) and

(@P3 is null or table.p3=@P3)

Try using

where (table.p1= isnull( @P1, table.p1) and

(table.p2=isnull( @P2, table.p2...

Tasks use a connection( referenced by name [Actually the DTS Connection Description]).

By changing the Connection Properties the Tasks will be function correctedly. It is like changing the properties of...

/*********************

Move DAta to Tempt table with RowID ordered by SPID, loginTime

*/

Insert into #tmp

Select SPID, LoginTime, DT, CPU

FRom cpu_usage cpu1

order by SPID, LoginTime, DT (desc ) -- This is Important

Select

...