I think you can just use a subquery:
from (select top 18 id, obsDate, impact
where diseaseID = 2 AND pCode = 3352 AND obsDate <=
'2014/11/5 11:30:00 PM'
I would also advise you to use a more standard date format, such as
'2014-11-05 11:30:00 PM'.
Have a look at this:
You will need to provide a custom <pagertemplate> where you will
insert a custom label, lets say totalRecordCount. Then in your code
behind, you will need to get the total row count of your data using
LINQ or any other method you like and assign it to the custom label
Not sure what you get in @TheDocumentIDs, but I suppose it should work
First of all as @Chris mentioned, you should check put condition to
where clause and as documentIds is a list of id's it should used with
IN condition and not equality, that's why you need or use
sp_executesql or fill id's to a temp table.
N'delete from [master_group_documen
The problem is with this line:
String query = "insert into
The table ChampionData has 13 columns:
While the row you'