Thanx Karl

It will work, But Is there any option to make trigger run for each row even I execute batch update

e.g

Update mytable set statuscode='ACT' where statuscode is null

If above query will affect...

Hi

Try to move log file to another location and while attaching database files specify only .mdf file. If SQL Server Creates new log for you, you will be lucky!!!

Hi Neetu

Use this query to get required output,

select year(DateEntered)as yr ,branch,count(*) as TRec  ,NULL as YearlyTotal

from stat

group by year(DateEntered),Branch

union

Select NULL,NULL,NULL, count(*) as YearlyTotal

from stat

group by

year(DateEntered)

Hope this will work

Vikas