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.
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" |
|
|
|
|
|