Good point about sorting when date is stored in character datatype. I used to get various date points (i.e. first day of month, last day, etc...) by stripping the Year(),...

Try something like:

Declare @FileFrom varchar(255),

  @FileTo varchar(255),

  @path varchar(255),

  @OutputString varchar(500)

SELECT @path='C:\Program Files\Microsoft SQL Server\Backups\' --Or whatever your path is

SELECT @FileFrom =@path +'logname_2004-01-12. 300.trn'

SELECT @FileTo =@path +'logname3.trn'

select @OutputString= 'REN ' + '"'+...

Excellent function!!

But as others have pointed out holidays will invariably need to be taken into account; we have a holiday table which (simplified version) is called HCD and has one...

Try This

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TempDBImpact]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[TempDBImpact]

GO

CREATE  procedure dbo.TempDBImpact

@tab2bs     varchar(100) = null ...

Check out 'sp_addlinkedserver' in SQL Books Online