Compute Holiday Day of the Month for any Year

This script provides the day of the month for the standard bank holidays for any given year. This is especially useful for computing the workday after a holiday.

Independence Day II

It's a holiday in the US and Steve Jones wishes everyone a good day.

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently

Create bank holidays table

Do you know what happens if a holiday falls on a weekend? This script will help you.

Riddle Me This

Question of the Day for 07 Feb 2005

Comments posted to this topic are about the Question of the Day for 07 Feb 2005 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=446.

SQL Mail Setup?

I have been trying to setup SQL Mail, but it still isn't working    I have made a new user (sqladmin) in Active Directory Users and a login on SQL Server.  Then I have logged in as sqladmin.  It still won't work.  What else needs to be done?  Any help would be great.  I need to […]

RE: Linking "text" item with "numeric" item -- Please HELP !

Use cast to convert text to int/numericOFFERITEMS ON ITEMMAST.EDPNO = CAST(SUBSTRING(OFFERITEMS.OFFERITEM, 9, 8) as int)

RE: login failed in different domains

make sure you can reach the server from that machine! it sounds like the client lost configuration info

RE: poor Question of the day 7_13_2003

This is a poor question not because of the question itself, but because of the distractors. While it is correct that you JUST need a login to SQL server, you are added to master because of the default value of @defdb in sp_addlogin. At least that's the way I was thinking at the time... Am […]