SET ROWCOUNT 0
go

IF OBJECT_ID('tempdb..#ProductVersion') IS NULL
BEGIN
	CREATE TABLE #ProductVersion
	(
		ProductID int NOT NULL,
		Version int NOT NULL,
		MinorVersion int NOT NULL,
		ReleaseVersion int NOT NULL,
		StandardCost numeric(30, 4) NOT NULL
	)
END

DECLARE @ProductId INT
DECLARE A CURSOR FOR
	SELECT	ProductId
	FROM	ProductVersion
	GROUP BY ProductId
	ORDER BY ProductId
OPEN A
FETCH NEXT FROM A
	INTO @ProductId
WHILE	@@FETCH_STATUS = 0
BEGIN
	INSERT INTO #ProductVersion
	SELECT	TOP 1 ProductId,
			Version,
			MinorVersion,
			ReleaseVersion,
			StandardCost 
	FROM	ProductVersion
	WHERE	ProductId = @ProductId
	ORDER BY ProductId ASC,
			Version DESC,
			MinorVersion DESC,
			ReleaseVersion DESC

	FETCH NEXT FROM A
	INTO @ProductId
END
CLOSE A
DEALLOCATE A

SELECT * FROM #ProductVersion
DROP TABLE #ProductVersion