0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) DROP TABLE #tmpPopPostDD;

CREATE TABLE #tmpPopPostDD 
( 
  RowId INT IDENTITY(1,1),
  Id INT,
  BatchId INT,
  ViewCount INT,
  Title VARCHAR(255)
);

INSERT INTO #tmpPopPostDD (Id, BatchId, ViewCount, Title )
SELECT Id, 1 AS [Batch], ViewCount, Title
FROM Posts 
ORDER by ViewCount DESC
OFFSET 0 ROWS
FETCH NEXT 10 ROWS ONLY;
--UNION
INSERT INTO #tmpPopPostDD (Id, BatchId, ViewCount, Title )
SELECT Id, 2 AS [Batch], ViewCount, Title 
FROM Posts 
ORDER by ViewCount DESC
OFFSET 9 ROWS
FETCH NEXT 10 ROWS ONLY;

SELECT COUNT(*) FROM #tmpPopPostDD;

view current version

edited oct 18 21

created oct 18 21 anonymous