Create Paging with Stored procedure
CREATE PROCEDURE [dbo].[proc_qca_CommunityMyFriendsSelect] @UserId Bigint, @StartIndex int, @PageSize int, @ColumnName Varchar(200), @SortType Varchar(10) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- DECLARE @StartIndex int -- DECLARE @PageSize int -- DECLARE @UserId Bigint -- DECLARE @ColumnName Varchar(200) -- DECLARE @SortType Varchar(10) -- -- SET @StartIndex =1; -- SET @PageSize = 3; -- SET @UserId = 104; -- SET @ColumnName = 'date_last_update' -- SET @SortType = 'asc' DECLARE @Query NVARCHAR(MAX) SET @Query = 'WITH MyFriends AS ( SELECT ur_friends.usr_unq_id, ur_friends.friend_unq_id, ur_friends.forward, ur_friends.backwards, ur_users.first_name, ur_users.last_name, ur_users.middle_name, sn_MyProfiles.picture_file, sn_MyProfiles.avatar, sn_MyProfiles.nickname, ur_friends.date_last_update, sn_MyP...
