Click here to Skip to main content
15,936,169 members
Home / Discussions / Database
   

Database

 
GeneralRe: LDF file Size is so increased Pin
GuyThiebaut4-Jun-15 7:28
professionalGuyThiebaut4-Jun-15 7:28 
GeneralRe: LDF file Size is so increased Pin
Richard Deeming4-Jun-15 8:44
mveRichard Deeming4-Jun-15 8:44 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.5-Jun-15 20:40
Azam Niaz Ch.5-Jun-15 20:40 
GeneralRe: LDF file Size is so increased Pin
Richard Deeming7-Jun-15 21:27
mveRichard Deeming7-Jun-15 21:27 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.21-Jun-15 9:04
Azam Niaz Ch.21-Jun-15 9:04 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.4-Jun-15 7:29
Azam Niaz Ch.4-Jun-15 7:29 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.4-Jun-15 8:30
Azam Niaz Ch.4-Jun-15 8:30 
QuestionSQL: Function To find Last business day of the Month factoring in Holidays Pin
swoozie128-May-15 7:43
swoozie128-May-15 7:43 
We all have functions and code for business day calculations, or last day of the month calculations, ect... I am adding a caveat to this for Last business day of the month, not a holiday. I.e. (hypothetical), Last day is 12/31/2015, this is a Friday, however the company give this day off as a holiday so 12/30/2015 needs to be determined as the last business day of the month.

I am looking at a couple of ways to approach this.

1) Calculate the Last Day of the month, Determine if it is not a Sat\sun, if is DateDiff to a business day, then take that date and compare to a Holiday table and adjust accordingly.

2) use a function that already exists for Last Business day of the month and then take that date and compare to a Holiday table and adjust accordingly.

3) some better what that I can not think of and no we can not use the XLeratorDB or what ever that is called.


The out put I am looking for is just a DATE, the date of the very last company business day of the month.
Thank you In advance!

No reason to re-invent the wheel, just improve upon existing.

AnswerRe: SQL: Function To find Last business day of the Month factoring in Holidays Pin
Eddy Vluggen29-May-15 2:35
professionalEddy Vluggen29-May-15 2:35 
AnswerRe: SQL: Function To find Last business day of the Month factoring in Holidays Pin
Mycroft Holmes29-May-15 15:39
professionalMycroft Holmes29-May-15 15:39 
Questionstrange Sql Server error Pin
tiwal28-May-15 1:55
tiwal28-May-15 1:55 
AnswerRe: strange Sql Server error Pin
tiwal28-May-15 2:38
tiwal28-May-15 2:38 
GeneralRe: strange Sql Server error Pin
Richard Deeming28-May-15 2:49
mveRichard Deeming28-May-15 2:49 
GeneralRe: strange Sql Server error Pin
tiwal28-May-15 2:55
tiwal28-May-15 2:55 
GeneralRe: strange Sql Server error Pin
Richard Deeming28-May-15 2:57
mveRichard Deeming28-May-15 2:57 
GeneralRe: strange Sql Server error Pin
tiwal28-May-15 3:03
tiwal28-May-15 3:03 
QuestionRDBMS Pin
Member 1003097527-May-15 2:00
Member 1003097527-May-15 2:00 
AnswerRe: RDBMS Pin
Tim Carmichael27-May-15 2:15
Tim Carmichael27-May-15 2:15 
Questionwrite a procedures along with cursors to dump data from one table to another table Pin
Member 1171121322-May-15 1:53
Member 1171121322-May-15 1:53 
AnswerRe: write a procedures along with cursors to dump data from one table to another table Pin
CHill6022-May-15 1:55
mveCHill6022-May-15 1:55 
AnswerRe: write a procedures along with cursors to dump data from one table to another table Pin
Eddy Vluggen22-May-15 2:19
professionalEddy Vluggen22-May-15 2:19 
AnswerRe: write a procedures along with cursors to dump data from one table to another table Pin
Simon_Whale22-May-15 3:20
Simon_Whale22-May-15 3:20 
RantRe: write a procedures along with cursors to dump data from one table to another table Pin
Sascha Lefèvre22-May-15 4:05
professionalSascha Lefèvre22-May-15 4:05 
Questionjava prog to sort million input Pin
Sohail Sowell17-May-15 20:26
Sohail Sowell17-May-15 20:26 
AnswerRe: java prog to sort million input Pin
Jörgen Andersson17-May-15 20:32
professionalJörgen Andersson17-May-15 20:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.