string sql=string.Format(@"DECLARE @skipRows int = {0}, @takeRows int = {1}, @count int = 0 ;WITH Message_cte AS ( SELECT M.*,O.OrderNo AS WebOrderNo,O.OrderDate FROM [Message] M INNER JOIN...
Gives you back end support so you save time!