USP_DATAFORMTEMPLATE_VIEW_WPSOCIALIMAGE

                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPSOCIALIMAGE 
                    (
                    @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
          @IMAGE varbinary(max) = null output,
          @IMAGETHUMBNAIL varbinary(max) = null output

                ) as
                    set nocount on;
                    set @DATALOADED = 0;

          select 
            @IMAGE = IMAGE,
            @IMAGETHUMBNAIL = IMAGETHUMBNAIL,
            @DATALOADED = 1
          from
            WPSOCIALIMAGE
          where @ID = ID

                    return 0;