marado

ALTER FUNCTION [dbo].[checkStatus] 
(
	@idvenda int
)
RETURNS BIT
AS
BEGIN
	declare @resultbit bit
	SELECT @resultbit = 
	case 
		when a.STATUS != 'CD81E048-8E57-4669-89E9-B70333044D58'
		then CONVERT(bit, 1) -- Nao deixa vender
		else CONVERT(bit, 0) -- Deixa Vender
	end 
FROM LinhadeVenda l
	INNER JOIN Artigos a ON l.artigo = a.idArtigo
WHERE l.idVenda = @idvenda
RETURN @resultbit
END