SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Jostein Kjønigsen
-- Create date: 14.7.2006
-- Description:	Gets details for a specific photo
-- =============================================
CREATE PROCEDURE dbo.PhotoGet
	@PhotoID int
AS
BEGIN
	SET NOCOUNT ON;

	SELECT PhotoID, ImageURL, Description,
		(SELECT ArticleID FROM dbo.Photos WHERE PhotoID = @PhotoID)
		AS GalleryID,
		(
			SELECT TOP(1) PhotoID FROM dbo.Photos
			WHERE ArticleID=@GalleryID
			AND PhotoID<@PhotoID
			ORDER BY PhotoID DESC
		)
		AS PrevID,
		(
			SELECT TOP(1) PhotoID FROM dbo.Photos
			WHERE ArticleID=@GalleryID
			AND PhotoID>@PhotoID
			ORDER BY PhotoID ASC
		)
		AS NextID
	FROM dbo.Photos
	WHERE PhotoID=@PhotoID
END
GO