USP_RECORDOPERATION_WPSOCIALIMAGE_USEASPROFILEIMAGE

                    CREATE procedure dbo.USP_RECORDOPERATION_WPSOCIALIMAGE_USEASPROFILEIMAGE (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null
                    ) as begin

              exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

              declare @CURRENTDATE datetime
              set @CURRENTDATE = getdate()

            declare @CONSTITUENTID uniqueidentifier;
            declare @IMAGE varbinary(max);
            declare @IMAGETHUMBNAIL varbinary(max);

            select 
              @CONSTITUENTID = WPSOCIALID,
              @IMAGE = IMAGE,
              @IMAGETHUMBNAIL = IMAGETHUMBNAIL
            from WPSOCIALIMAGE
            where @ID = ID

            update CONSTITUENT
              set PICTURE = @IMAGE,
                  PICTURETHUMBNAIL = @IMAGETHUMBNAIL,
                  DATECHANGED = @CURRENTDATE,
                  CHANGEDBYID = @CHANGEAGENTID
            where @CONSTITUENTID = ID

                        return 0;
                    end