CREATE procedure spGetFileDate (@FileDate varchar(200) OUTPUT)
/****************************************************************************************
Description:      Procedure to create a partial filename used in the naming
of backup files
Returns:    (None)
Author:           Paul Ibison (xt 26163)
Date Created:     22/12/2004
Revisions:
*****************************************************************************************/
as
declare @getdate datetime
set @getdate = getdate()
set @FileDate =  cast(year(@getdate) as varchar(100)) + '#' +
cast(month(@getdate) as varchar(100)) + '#' + cast(day(@getdate) as
varchar(100)) + '#' + cast(datepart(hh,@getdate) as varchar(100)) + '#' +
cast(datepart(mi,@getdate) as varchar(100))
GO