At present i have the following SP code
SELECT TOP(@PageSize) * FROM
(
SELECT RowID = ROW_NUMBER() OVER (ORDER BY datentime DESC),
RefID, InboxId, MessageType, SenderID,
RecieverID, [Subject], Body, DatenTime,
TotalRows=Count(inboxid) OVER()
FROM Inbox_Messages
)
A WHERE A.RowID > ((@PageIndex-1)*@PageSize) order by datentime DESC
I want to introduce another table that has same column included as Inbox_Messages so that the result set displays both table data.
I understand that this can be achieved using a UNION. The problem is there is two extra entries namely TotalRows and RowID therefore the two tables do not have matching columns.So how may i reconfigure so that it returns correct paged data?
New table addition
SELECT
RefID,
InboxID,
MessageType,
SenderID,
RecieverID,
[Subject],
Body,
Datentime
FROM Inbox_Return