SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: Jostein Kjønigsen-- Create date: 14.7.2006-- Description: Gets details for a specific photo-- =============================================CREATE PROCEDURE dbo.PhotoGet @PhotoID intASBEGIN 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=@PhotoIDENDGO