this is not the output i want... u jus check the out put of the query given by ken and saby...

Nope this not the Query saby and ken has given me the exact query which i want but the issue in actualy senario image col contains datatype image ... i...

Msg 206, Level 16, State 2, Line 1

Operand type clash: int is incompatible with image

while running the query.. which is provided my saby

any one plz reply ... need the query

nope this is not the case...

jeff waiting for the reply

how many rows are there with 3 not null values and

how many rows are there with 4 not null values

from column image1 to image10

Actaul table contains diffrent datatype for image1 to image10 it is image datatype bcoz it contains images

CREATE TABLE dbo.table2

(

...

jeff thkz for the reply but i dnt want this.....

i want the count

waiting for the reply

Also try this.....

DBCC CHECKTABLE('audit_record',REPAIR_FAST) can not fix this problem.

DBCC CHECKTABLE('audit_record',REPAIR_ALLOW_DATA_LOSS)

this error comes when 1 of ur data in the tables gets corrupted or wen 1 of ur index gets corrupted....

Try this ....

ALTER DATABASE name SET EMERGENCY

GO

ALTER DATABASE name SET...

Please find the attachment of the execution plan

GSquared----- If you really need to pull the data 15 times, what you might do is take the parts that don't change, dump those into a temp table ONE time,...

thknz GSquared plz provide more suggestions

Waiting for reply.....