USP_BBNC_GETNETCOMMUNITYCLIENTUSERIDS

create procedure dbo.USP_BBNC_GETNETCOMMUNITYCLIENTUSERIDS(
  @CONSTITUENTID uniqueidentifier,
  @ROWCOUNT int output
)
as
  if object_id('tempdb..#NETCOMMUNITYCLIENTUSERIDSTABLE') is not null
  begin
      insert into #NETCOMMUNITYCLIENTUSERIDSTABLE
              select ID from dbo.NETCOMMUNITYCLIENTUSER where CONSTITUENTID = @CONSTITUENTID;

      select @ROWCOUNT = count(*) from #NETCOMMUNITYCLIENTUSERIDSTABLE;
  end