There may be no I in team...but there is a me

ok then how about

SELECT  t.vDay ... FROM (SELECT CONVERT(VARCHAR, DATEPART(dd, s.dtDate)) 'vDay' ,CONVERT(int, DATEPART(dd, s.dtDate)) 'vDayorderby' .... FROM Schedule AS S

UNION

SELECT CONVERT(VARCHAR, DATEPART(dd, h.dtDate)) 'vDay' ,CONVERT(int, DATEPART(dd, s.dtDate)) 'vDayorderby' .... FROM Holidays AS H

ORDER BY vDayorderby 

Did you try

SELECT  t.vDay FROM (SELECT CONVERT(VARCHAR, DATEPART(dd, s.dtDate)) 'vDay' .... FROM Schedule AS S

UNION

SELECT CONVERT(VARCHAR, DATEPART(dd, h.dtDate)) 'vDay' .... FROM Holidays AS H

ORDER BY vday

For a guide see http://www.microsoft.com/downloads/details.aspx?familyid=b4e57b5e-2cfc-49ae-a184-5705acf8591f&displaylang=en

For a microsoft sponsored lab on using SSMA see http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032291121&EventCategory=3&culture=en-US&CountryCode=US

It depends what you want to convert and to what you want to convert that to.  Tables only are easy to convert.  The Upsizing wizard can help with this. 

For...

SQL will take care of this itself.  If someone is locking the table so your package cannot get write access, the package will wait until it can get access.  Once...

Please ask the question again. I don't understand

either..  but since they relate to the package I would put them inside the package as the 1st and last tasks to be done.  (I think its called Execute SQL...

1) to kill all users see http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=30

There are also a couple of other similiar scripts available

2: to not allow users in set databse to single user status see BOL...

Please don't cross-post.  You already have a response in the other forum where this same message was posted.

Very nice.  I didn't think of creating a big string.  I believe I can work with this.  Ultimately the user wants this in an Excel spreadsheet so all I need...

You may find this proc useful.  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1505

If you pass the dataset it will create the restore statements needed to restore the full backup and all transaction logs.  You can...

The "\r\n" worked fine.  thank you.  I tried changing the F2 to F2 and it really doesn't work as I expect.  I get the error Error = [Microsoft][ODBC SQL Server...

The logins and passwords are on master but they can be rebuilt using DTS or one of several scripts found on this site.  Also all databases are registered on master,...

Mike makes soe good points.  If you need an example of INLINE TABLE-VALUED FUNCTION see http://www.sqlservercentral.com/columnists/nboyle/userdefinedfunctions.asp