are you implemented trn backup plan onthat database? please stop than plan.

-mohan

try this one,

INSER INTO TABLE

SELECT * FROM

UNION

SELECT * FROM

UNION

SELECT * FROM

UNION

SELECT * FROM ;

ABOVE QUERY IS GIVING CONVERTION ERROR, WITH SLIGHT CHANGES DONE.

Select Cnt as Count1 from

(

Select 10 - (CAST(Img1 AS INT)+ CAST(Img2 AS INT) + CAST(Img3 AS INT) +...