Hi
I have one table,in that more 10000 records,in one fields is may or may not NULL,i need to get records ,those fields are NULL from 10000 records.Below is my table fields.
DocumentName, [Document], Path, Version,SWF
In this Document and SWF fields are file stream,i mean i store binary data of files in that fields.All row of Document fields got binary data,but SWF fields some row is NULL.
So here i need to get which SWF fields is NULL from more than 10000 records.
If i use following query
select DocumentName, [Document], Path, Version,SWF from FTRepository where ([SWF] IS NULL)
It show "Timeout expired" error,here i attach screenshot link
http://prntscr.com/6rfidq[
^]
IF i use following query still show same error,here i use top of 200 with where condition,if without where condition get result,but i need where condition,But this is not good idea,bcz always it retrieve top most 200 records,i mean all time it retrieve same 200 records,it not move next 200 records form 10000 records
select Top (200) DocumentName, [Document], Path, Version,SWF from FTRepository where ([SWF] IS NULL)
So how to solve this.
And second question
I have more that 10000 records in FTRepository table,in that i need to retrieve first 200 records,after process with first 200 records,then need to move next 200 records,and then next 200 records and so on,i mean in more than 10000 records i will spilt 200,200 ... records and process with 200 records and so on...
Here no need where condition (SWF is null),just i need to take 200,200..... records form more than 10000 records.
Records
Araind