USP_ORGANIZATION_EDITLOAD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@ORGANIZATIONNAME	nvarchar(100)	INOUT
@INDUSTRYCODEID	uniqueidentifier	INOUT
@NUMEMPLOYEES	int	INOUT
@NUMSUBSIDIARIES	int	INOUT
@PARENTCORPID	uniqueidentifier	INOUT
@PICTURE	varbinary	INOUT
@PICTURETHUMBNAIL	varbinary	INOUT
@PICTURECHANGED	bit	INOUT
@WEBADDRESS	UDT_WEBADDRESS	INOUT
@TSLONG	bigint	INOUT
@ISPRIMARY	bit	INOUT

Definition

Copy



create procedure dbo.USP_ORGANIZATION_EDITLOAD (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @ORGANIZATIONNAME nvarchar(100) = null output, 
            @INDUSTRYCODEID uniqueidentifier = null output,        
            @NUMEMPLOYEES int = null output,
            @NUMSUBSIDIARIES int = null output,
            @PARENTCORPID uniqueidentifier = null output,
            @PICTURE varbinary(max) = null output,
            @PICTURETHUMBNAIL varbinary(max) = null output,
            @PICTURECHANGED bit = null output,
            @WEBADDRESS dbo.UDT_WEBADDRESS = null output,
            @TSLONG bigint = 0 output,
            @ISPRIMARY bit = null output

        ) as
            set nocount on;

            set @DATALOADED = 0;
            set @TSLONG = 0;

            select 
                @DATALOADED = 1,
                    @ID = CONSTITUENT.ID,
                    @ORGANIZATIONNAME = CONSTITUENT.KEYNAMEPREFIX + case CONSTITUENT.KEYNAMEPREFIX when '' then '' else '\' end + CONSTITUENT.KEYNAME,
                    @INDUSTRYCODEID = ORGANIZATIONDATA.INDUSTRYCODEID,
                    @NUMEMPLOYEES = coalesce(ORGANIZATIONDATA.NUMEMPLOYEES,0),
                    @NUMSUBSIDIARIES = coalesce(ORGANIZATIONDATA.NUMSUBSIDIARIES,0),
                    @PARENTCORPID = ORGANIZATIONDATA.PARENTCORPID,
                @PICTURETHUMBNAIL = CONSTITUENT.PICTURETHUMBNAIL,
                @WEBADDRESS = WEBADDRESS,
                    @TSLONG = CONSTITUENT.TSLONG,
                @ISPRIMARY = ORGANIZATIONDATA.ISPRIMARY
            from 
                    dbo.CONSTITUENT
                    left join dbo.ORGANIZATIONDATA on ORGANIZATIONDATA.ID = CONSTITUENT.ID
            where 
                    CONSTITUENT.ISORGANIZATION = 1 and
                CONSTITUENT.ID = @ID;

            return 0;