I try this sql query
Select tblRV.ID as ID, tblRV.Owner, tblRV.Regno,
(Select Count(*) as total from tblvv WHERE MID = tblRV.ID and Name <> '')
as total,tblRV.MA, tblRV.MS from tblReg inner join tblRV On tblReg.RID = tblRV.RID
WHERE tblReg.StartDate >= '2016-06-01 00:00:00' AND
tblReg.EndDate <= '2016-06-08 23:59:59'
and tblReg.Region = 'UK'
order by tblRV.Owner
this query return me 24 rows so when i create procedure then i exe store procedure like this
grid_data 'UK' ,'2016-06-01 00:00:00', '2016-06-08 23:59:59'
sp
ALTER procedure [dbo].[grid_data]
@region varchar(50),
@fromdate datetime,
@todate datetime
as
Select tblRV.ID as ID, tblRV.Owner, tblRV.Regno,
(Select Count(*) as total from tblvv WHERE MID = tblRV.ID and Name <> '')
as total,tblRV.MA, tblRV.MS from tblReg inner join tblRV On tblReg.RID = tblRV.RID
order by tblRV.Owner
THIS SHOW ME 24913 records.