USP_DATAFORMTEMPLATE_VIEW_FISCALYEAREXISTS

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FISCALYEAREXISTS
(
  @DATALOADED bit = 0 output,
  @EXISTS bit = null output
)
as
  set nocount on;

  set @EXISTS = 0;

  if exists (select 1 from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'dbo' and TABLE_NAME = 'GLFISCALYEAR')
  begin
    if exists (select 1 from dbo.GLFISCALYEAR)
      set @EXISTS = 1;
  end

    set @DATALOADED = 1;

  return 0;