USE [GDW]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_BI_Get_AsiaTopTen]

AS BEGIN
  DECLARE
  @fyname nvarchar(120),
  @fmonth nvarchar(120),
  @fmonth_num int = null,
  @world_area nvarchar(120) = null

    SELECT TOP 10
  @fyname= [FYName],
  @fmonth= [FMONTH],
  @fmonth_num= [FMONTH_NUM],
  @world_area= [World_AREA]
  FROM [dbo].[tbl_BI_FastReport1_Temp]
  WHERE [World_AREA] = 'Asia'
  AND [FMONTH_NUM] = '201401'

  INSERT INTO [dbo].[tbl_BI_AsiaTopTen]
  (
  [FYName],
  [FMONTH],
  [FMONTH_NUM],
  [World_AREA]
  )
  VALUES
  (
  @fyname,
  @fmonth,
  @fmonth_num,
  @world_area
  )

  END