USP_BBITEMPLATETOOL_BBITEMPLATE_VIEW

                create procedure dbo.USP_BBITEMPLATETOOL_BBITEMPLATE_VIEW
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CLIENTID uniqueidentifier = null output,
                    @NAME nvarchar(250) = null output,
                    @PREVIEWHTML nvarchar(max) = null output,
                    @PREVIEWCSS nvarchar(max) = null output,
                    @ENABLED bit = null output,
                    @CLIENT nvarchar(250) = null output,
                    @TEMPLATEID uniqueidentifier = null output,
                    @PREVIEWCAPTCHAPOLICY nvarchar(250) = null output,
                    @PREVIEWCAPTCHAPOLICYCODE tinyint = null output,
                    @STATUSCODE tinyint = null output,
                    @STATUS nvarchar(250) = null output,
                    @OWNEDBYCURRENTAPPUSER bit = null output,
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @BASEURL nvarchar(2048) = null output,
                    @DIRTY bit = null output,
                    @LASTREVIEWEDBYCURRENTUSER bit = null output,
                    @OWNERNAME nvarchar(250) = null output
                )
                as
                    set nocount on;

                    -- Be sure to set this, in case the select returns no rows

                    set @DATALOADED = 0;

                    -- Populate the output parameters, which correspond to fields on the form.  Note that

                    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

                    -- will display a "no data loaded" message.


                            begin try

                                declare @OWNER as uniqueidentifier;

                                select
                                    @DATALOADED = 1,
                                    @CLIENTID = t.CLIENTID,
                                    @NAME = t.NAME ,
                                    @PREVIEWHTML = tpd.HTML,
                                    @PREVIEWCSS = tpd.CSS,
                                    @ENABLED = t.ENABLED,
                                    @CLIENT = a.WINDOWSUSERNAME,
                                    @TEMPLATEID = t.ID,
                                    @ID = bt.ID,
                                    @PREVIEWCAPTCHAPOLICY = tps.CAPTCHAPOLICY,
                                    @PREVIEWCAPTCHAPOLICYCODE = tps.CAPTCHAPOLICYCODE,
                                    @STATUSCODE = bt.STATUSCODE,
                                    @STATUS = bt.STATUS,
                                    @OWNER = bt.OWNERID,
                                    @BASEURL = bt.BASEURL,
                                    @DIRTY =  tpd.DIRTY,
                                    @OWNERNAME = a2.WINDOWSUSERNAME
                                from
                                    dbo.BBITEMPLATE bt
                                inner join
                                    dbo.TEMPLATE t
                                        on
                                            bt.TEMPLATEID = t.ID
                                inner join
                                    dbo.TEMPLATEDATA td
                                        on
                                            t.ID = td.TEMPLATEID
                                inner join
                                    dbo.TEMPLATEPREVIEWDATA tpd
                                        on
                                            t.ID = tpd.TEMPLATEID
                                inner join
                                    dbo.TEMPLATEPREVIEWSETTING tps
                                        on
                                            t.ID = tps.TEMPLATEID
                                inner join
                                    dbo.APPUSER a
                                        on
                                            t.CLIENTID = a.CONSTITUENTID
                                inner join
                                    dbo.APPUSER a2
                                        on
                                            bt.OWNERID = a2.ID
                                where
                                    bt.ID = @ID


                            if @CURRENTAPPUSERID = @OWNER
                            begin
                                set @OWNEDBYCURRENTAPPUSER = 1;
                            end
                            else
                            begin
                                set @OWNEDBYCURRENTAPPUSER = 0;
                            end


                            declare @LASTREVIEWERID uniqueidentifier = null;
                            select
                                top(1) @LASTREVIEWERID = btr.REVIEWERID
                            from
                                dbo.BBITEMPLATEREVIEW btr
                            where
                                btr.BBITEMPLATEID = @ID
                            order by
                                btr.DATECHANGED desc

                            if @LASTREVIEWERID = @CURRENTAPPUSERID
                            begin
                                set @LASTREVIEWEDBYCURRENTUSER = 1;
                            end
                            else
                            begin
                                set @LASTREVIEWEDBYCURRENTUSER = 0;
                            end

                            end try

                            begin catch
                                exec dbo.USP_RAISE_ERROR;
                                return 1;
                            end catch

                    return 0;