Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Check Against List of Bank Holidays

Author  Topic 

Jonny1409
Posting Yak Master

133 Posts

Posted - 2008-09-11 : 11:20:28
Hello,

I have a function which calculates my employees working hours on a particular date based on their shift pattern.

I then reference this function in a stored procedure, and it returns me a float value, or a value of 0 if they don't work on that date.

However, what I'd like to do now is check the date against a list of bank holidays (tbl_BankHolidays), and if the date is a bank holiday I'd like the stored procedure to return me 0.

Can anyone help me with the syntax for this please ?
If so, have I provided enough information ?
If I haven't then please let me know what you require and I'll supply it.

Thank you.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-11 : 11:36:35
where not exists (select * from tblBankHolidays AS x WHERE x.Date = yak.Date)



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -