object frmHighLighter: TfrmHighLighter
  Left = 246
  Top = 51
  BorderStyle = bsDialog
  Caption = #32534#36753#22120
  ClientHeight = 548
  ClientWidth = 751
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -15
  Font.Name = #23435#20307
  Font.Style = []
  OldCreateOrder = False
  Position = poScreenCenter
  PixelsPerInch = 96
  TextHeight = 15
  object btnClose: TButton
    Left = 637
    Top = 506
    Width = 75
    Height = 25
    Caption = #20851#38381
    Default = True
    TabOrder = 0
    OnClick = btnCloseClick
  end
  object SynEdit1: TSynEdit
    Left = 22
    Top = 14
    Width = 715
    Height = 483
    Color = clWhite
    CodeFolding.CaseSensitive = False
    CodeFolding.FolderBarLinesColor = 9617866
    ActiveLine.Background = clMenuHighlight
    ActiveLine.Foreground = clNavy
    ActiveLine.Visible = True
    LineDivider.Visible = False
    LineDivider.Color = clRed
    LineDivider.Style = psSolid
    RightEdge.MouseMove = False
    RightEdge.Visible = True
    RightEdge.Position = 80
    RightEdge.Color = clSilver
    RightEdge.Style = psSolid
    LineSpacing = 0
    LineSpacingRule = lsSingle
    Background.Visible = False
    Background.RepeatMode = brmNone
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -13
    Font.Name = 'Courier New'
    Font.Style = []
    TabOrder = 1
    BorderStyle = bsNone
    Gutter.ShowLineModified = False
    Gutter.LineModifiedColor = clYellow
    Gutter.LineNormalColor = clLime
    Gutter.Font.Charset = DEFAULT_CHARSET
    Gutter.Font.Color = clWindowText
    Gutter.Font.Height = -11
    Gutter.Font.Name = 'Courier New'
    Gutter.Font.Style = []
    Gutter.LeftOffsetColor = clNone
    Gutter.RightOffsetColor = clNone
    Highlighter = SynSQLSyn1
    Lines.Strings = (
      
        '/****** '#23545#35937':  StoredProcedure [dbo].[Ns_Fix_CtgryStat3]    '#33050#26412#26085#26399': ' +
        '12/15/2008 14:24:12 ******/'
      'SET ANSI_NULLS ON'
      'GO'
      'SET QUOTED_IDENTIFIER OFF'
      'GO'
      
        '/****** Object:  Stored Procedure dbo.Ns_Fix_CtgryStat3    Scrip' +
        't Date: 2002-04-01 15:36:51 ******/'
      
        '/****** Object:  Stored Procedure dbo.Ns_Fix_CtgryStat3    Scrip' +
        't Date: 2001-11-24 16:21:39 ******/'
      
        '/****** Object:  Stored Procedure dbo.Ns_Fix_CtgryStat3    Scrip' +
        't Date: 2001-05-21 14:19:34 ******/'
      
        '/****** Object:  Stored Procedure dbo.Ns_Fix_CtgryStat3    Scrip' +
        't Date: 2001-05-16 15:54:10 ******/'
      
        '/****** Object:  Stored Procedure dbo.Ns_Fix_CtgryStat3    Scrip' +
        't Date: 2001-05-15 '#19978#21320' 08:58:02 ******/'
      
        '/****** Object:  Stored Procedure dbo.Ns_Fix_CtgryStat3    Scrip' +
        't Date: 2001-05-14 17:11:58 ******/'
      ''
      'CREATE PROCEDURE [dbo].[Ns_Fix_CtgryStat3]'
      '@fromdate datetime,'
      '@todate datetime'
      'AS'
      ''
      'create table #t('
      #9'CanclRsn char(10) not null,'
      #9'Orgval numeric(15,2) null,'
      #9'val1 numeric (15,2) null,'
      #9'LqdtIncm numeric (16,2) null'
      ')'
      'declare @CanclRsn char(10)'
      'declare @Orgval numeric (15,2)'
      'declare @val1 numeric (15,2)'
      'declare @LqdtIncm numeric (16,2)'
      'declare CanclRsn_cursor cursor for'
      #9'select CanclRsn,sum(orgval),sum(LqdtIncm) from FixCard'
      
        '        where CanclRsn is not null and cancldt >= @fromdate and ' +
        'cancldt <= @todate'
      '         group by CanclRsn order by CanclRsn'
      ''
      'open CanclRsn_cursor'
      'fetch next from CanclRsn_cursor into @CanclRsn,@Orgval,@LqdtIncm'
      'while @@fetch_status=0'
      #9'begin'
      #9'select @val1=sum(val1) from VW_NsFixDpr'
      
        '        where CanclRsn=@CanclRsn and Optype='#39'F00001'#39' and cancldt' +
        ' between @fromdate and @todate'
      
        #9'insert #t (CanclRsn,Orgval,val1,LqdtIncm) values (@CanclRsn,@Or' +
        'gval,@val1,@LqdtIncm)'
      
        #9'fetch next from CanclRsn_cursor into @CanclRsn,@Orgval,@LqdtInc' +
        'm'
      #9'end'
      'close CanclRsn_cursor'
      'deallocate CanclRsn_cursor'
      ''
      'declare @p_count int'
      ' select @p_count = count(*) from #T'
      ' if @p_count > 0'
      
        ' insert into #t(CanclRsn,Orgval,val1,LqdtIncm) select '#39#21512#35745#39' as Ca' +
        'nclRsn,sum(Orgval),sum(val1),sum(LqdtIncm) from #t'
      ''
      'select CanclRsn,Orgval,val1,LqdtIncm from #t'
      'GO'
      '')
    WordWrap.Enabled = False
    WordWrap.Position = 80
    WordWrap.Style = wwsClientWidth
  end
  object SynSQLSyn1: TSynSQLSyn
    CommentAttri.Foreground = clGreen
    DataTypeAttri.Foreground = clBlue
    DelimitedIdentifierAttri.Foreground = clBlue
    KeyAttri.Foreground = clBlue
    NumberAttri.Foreground = clFuchsia
    NumberAttri.Style = [fsBold]
    StringAttri.Foreground = clOlive
    SymbolAttri.Foreground = clBlue
    SymbolAttri.Style = [fsBold]
    VariableAttri.Foreground = clTeal
    VariableAttri.Style = [fsBold]
    Left = 160
    Top = 208
  end
end
