CREATE PROCEDURE [dbo].[AN_R01_T01] (@TbName as varchar( 255 ), @PStep as smallint) AS

--Table 1. External trade by selected goods  from *** till ***  by month/quarter  interval; ‘000 Dollars USA

declare @sql as varchar( 8000 )
declare @fld as varchar( 32 )

if (@PStep= 1 ) set @fld='ngtd_month'
if (@PStep= 3 ) set @fld='ngtd_quarter'

set @sql = 'SELECT     ngtd_year, '+@fld+', dir_id, SUM(Cost_Cst_UE) AS Cost_Cst_UE, SUM(Cost_Product_UE) AS Cost_Product_UE, SUM(Cost_Stat_UE) AS Cost_Stat_UE'+
' FROM         [dbo].['+@TbName+']'+
' GROUP BY ngtd_year, '+@fld+', dir_id'+
' ORDER BY ngtd_year, '+@fld+', dir_id'

exec(@sql)
GO

    Private CnnTmp As New SqlConnection
    Private CnnStrTmp As String = "Data Source=SERVER;Initial Catalog=online_temp;User Id=db;Password=coolpass;"
    Private Cmd As SqlCommand
        
        CnnTmp.ConnectionString = CnnStrTmp
        CnnTmp.Open()
        Cmd = New SqlCommand("dbo.AN_R01_T01", CnnTmp)
        Cmd.CommandType = CommandType.StoredProcedure
        Cmd.CommandTimeout =  0 
        Call AddParameter(Cmd, "@TbName", SqlDbType.VarChar,  255 , ParameterDirection.Input, TbName)
        Call AddParameter(Cmd, "@PStep", SqlDbType.SmallInt,  0 , ParameterDirection.Input, PStep)

        Cmd.ExecuteReader()