How to make SELECT NEXT VALUE work in SQL Server?
CREATE TABLE Person(FirstName Varchar(50),LastName Varchar(50));/*Insert Some Values Into Person*/CREATE SEQUENCE CountBy START WITH 1 INCREMENT BY 1 ;SELECT NEXT VALUE FOR CountBy OVER (ORDER BY LastName) AS ListNumber, FirstName, LastName INTO table_xFROM Person
SELECT NEXT VALUE FOR GROUP_A AS GROUP_ID, SS.RISK_IDINTO table_X FROM ( SELECT DISTINCT RISK_ID FROM table_Y ) SS
Try this one -
IF OBJECT_ID ('dbo.table_X') IS NOT NULL DROP TABLE dbo.table_XSELECT RISK_ID --, ..... columnsINTO dbo.table_XFROM ( SELECT DISTINCT RISK_ID FROM dbo.table_Y ) SSSELECT * FROM dbo.table_X