Error with my SQL statement,

See more:

SQL

SQL-Server

Hello :)

I tried to use IF Statement within my stored procedure in SQL SERVER 2008 R2

but there are errors that I don't know how to fix it.

any help please ?

here is my stored procedure

USE [MsaGroup_SYTS]
GO
/****** Object:  StoredProcedure [dbo].[InserNewcommentFromViewPages]    Script Date: 03/05/2012 02:08:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[InserNewcommentFromViewPages]
@_UserID Int,
@_Text NVarChar(MAX),
@_Type NVarChar(50),
@_Date DateTime,
@_ItemID Int
as
insert
into
Comments
(
Comments.[User_ID],
Comment_Text,
Comment_Type,
Comment_Date,
Comment_TypeID,
Comment_FlagIsActive,
Comment_Original
)
values
(
@_UserID,
@_Text,
@_Type,
@_Date,
@_ItemID,
'true',
'~/pages/' + @_Type + 'view.aspx?ID=' + @_ItemID + '&Image='
+ (IF (@_Type  = 'Parteners') 
BEGIN
   SELECT Partners.Partner_ImageGalleryID from Partners where Partner_ID = @_ItemID
END
ELSE
BEGIN
	IF (@_Type  = 'News') 
	BEGIN
		SELECT News.News_ImageGalleryID from News where News.News_ID = @_ItemID
	END
END
ELSE
BEGIN
	IF (@_Type  = 'Prodects') 
	BEGIN
		SELECT Products.Product_ImageGalleryID from Products where Product_ID = @_ItemID
	END
END
ELSE
BEGIN
	IF (@_Type  = 'Ads') 
	BEGIN
		SELECT Ads.Ads_ID from Ads where Ads.Ads_ID = @_ItemID
	END
END
)
+ '&Video='
+ (IF (@_Type  = 'Parteners') 
BEGIN
   SELECT Partners.Partner_VideoGalleryID from Partners where Partner_ID = @_ItemID
END
ELSE
BEGIN
	IF (@_Type  = 'News') 
	BEGIN
		SELECT News.News_VideoGalleryID from News where News.News_ID = @_ItemID
	END
END
ELSE
BEGIN
	IF (@_Type  = 'Prodects') 
	BEGIN
		SELECT Products.Product_VideoGalleryID from Products where Product_ID = @_ItemID
	END
END
ELSE
BEGIN
	IF (@_Type  = 'Ads') 
	BEGIN
		SELECT Ads.Ads_ID from Ads where Ads.Ads_ID = @_ItemID
	END
END
)
)