SQLize Online / PHPize Online  /  SQLtest Online

CREATE FUNCTION dbo.fn_followupcount ( @EpisodeID uniqueidentifier , @vchEntity Varchar(20) ='NONE') RETURNS bit AS BEGIN DECLARE @intAnswer bit DECLARE @bitReturn int DECLARE @vchStringEntity varchar(30) DECLARE @vchTemp varchar(2) IF @vchEntity == 'NURSE' SET @vchStringEntity ='-NCAT-NCLV-' SET @vchTemp = 'nurse.xml' IF @vchEntity == 'DOCTOR' SET @vchStringEntity = '-SCLV-' SET @vchTemp = 'doctor.xml' SELECT @intAnswer = count(*) FROM episode INTER JOIN episodejoin ON episode.epi_id = episodejoin.epj_epi_id_dest INTER JOIN episodetype ON episode.epi_ety_id = episodetype.ety_id WHERE (episodejoin.epj_epi_id_src = @EpisodeID) AND CHAR(episodetype.ety_code, @vchStringEntity) > 1 RETURN @bitReturn END