-- =============================================
-- Declare and using a KEYSET cursor
-- =============================================
DECLARE curname CURSOR
KEYSET
FOR
select * from _poheader order by 1

DECLARE @elementName varchar(255)
DECLARE @dataType varchar(255)
DECLARE @length float
DECLARE @required varchar(255)
DECLARE @defaultVal varchar(255)
DECLARE @description varchar(255)

OPEN curname

FETCH NEXT FROM curname INTO @elementName,@dataType,@length,@required,@defaultVal,@description
WHILE (@@fetch_status = 0)
BEGIN
 if @datatype in ('i4','number') and not @elementname in ('potype') begin
  print '.' + @elementname + ' = me.po.' + @elementname
  print '.' + @elementname + 'specified = me.po.' + @elementname + 'specified'

 end else begin
  print '.' + @elementname + ' = me.po.' + @elementname
 end

 FETCH NEXT FROM curname INTO @elementName,@dataType,@length,@required,@defaultVal,@description
END

CLOSE curname
DEALLOCATE curname
GO

--select * from _poheader