DECLARE @DATE SMALLDATETIME = GETDATE(),
        @TABLE SYSNAME='MYTABLE'
DECLARE @FG_NAME SYSNAME, 
		@DATE_STR1 NVARCHAR(20), 
        @DATE_STR2 NVARCHAR(20),
		@STR_EXEC NVARCHAR(MAX)

SET @DATE_STR1 = CAST(YEAR(@DATE) AS NVARCHAR(10))+'-'
                 +RIGHT('0'+CAST(MONTH(@DATE) AS NVARCHAR(10)),2)+'-'
                 +RIGHT('0'+CAST(DAY(@DATE) AS NVARCHAR(10)),2)
				 +' 00:00:00'
SET @DATE_STR2 = REPLACE(LEFT(@DATE_STR1, 10), '-','')
SET @FG_NAME = 'FG_'+@TABLE+'_'+@DATE_STR2

IF NOT EXISTS (SELECT TOP 1 NAME FROM SYS.FILEGROUPS WHERE NAME = @FG_NAME)
    BEGIN   
       SET @STR_EXEC='

 BEGIN TRY 
	ALTER DATABASE [DATASTORAGE]
    ADD FILEGROUP ['+@FG_NAME+'] 
 END TRY
 BEGIN CATCH 
 END CATCH
 -----------------------------------------------
 BEGIN TRY 
    ALTER PARTITION SCHEME [SCH_'+@TABLE+']
    NEXT USED ['+@FG_NAME+']
 END TRY
 BEGIN CATCH 
 END CATCH
 -----------------------------------------------
 BEGIN TRY 
     ALTER DATABASE [DATASTORAGE]
     ADD FILE 	  
             (NAME = N'''+@FG_NAME+''',
             FILENAME = N''F:\SUDATABASES\DATASTORAGE\'+@TABLE+'\FG_'+@DATE_STR2+'.ndf'',
             SIZE = 1MB,
             MAXSIZE = UNLIMITED,
             FILEGROWTH = 5MB) 
             TO FILEGROUP ['+@FG_NAME+']
  END TRY
  BEGIN CATCH 
  END CATCH
 -----------------------------------------------
 BEGIN TRY 
    ALTER PARTITION FUNCTION PFN_'++@TABLE+' ()
    SPLIT RANGE ('''+@DATE_STR1+''')
 END TRY
 BEGIN CATCH 
 END CATCH
--=============================================
                    '
       --PRINT @STR_EXEC
	   EXECUTE (@STR_EXEC)
    END