tsql - SQL Stored Procedure: Business Hours -

How can I create a stored procedure that accepts a start and end date? (Eg 1 April - 30 April

1) Get business days including Saturday X (a value). + 2) Get the holidays x (a value)

and return the total.

I'm new to this, I think it will be a tsql function, hmm.

Any help would be appreciated.

Thanks

The simplest solution to this problem is to create a calendar table in which every There is a price for the day that you may want to consider, then you can add columns which show that this is a business day or holiday. With it, the problem gets thinner:

  ... the calendar is where business days = 1 and calendar Between [2010] '2010-04-01' and '2010-04-30' / code>  
 If you want to count the days, you can do the following: 
 < Pre>  select par (when IsBusinessDay = 1 then 1 other zero end) as the BusinessDayCount, the calendar where calendar as the holiday code for the yoga (case when iHolID = 1 then 1 es 0 and calendar). [Date] between '2010-04-01' and '2010-04-30'     
 


  















Popular Posts




How to fix this python error? RuntimeError: dictionary changed size
during iteration -



    This gives me this error:    Exception thread in thread -163: traceback ( Most recent calls last): File "C: \ Python26 \ lib \ threading.py", line 532, __bootstrap_inner self. In the file "C: \ Python26 \ lib \ threading.py", line 736, run the self (* self.args, ** self.kwargs) file "C: \ Users \ Public \ SoundLog \ Code \ Código Python \ SoundLog \ SoundLog.py ", line 337, the self.data1 = copy.deepcopy (Auxiliar DataCollection.getInfo (1)) file in getInfo" C: \ Python26 \ lib \ copy.py ", line 162, deepcopy y = Copier (x, memo) file "C: \ Python26 \ lib \ copy.py", line 254, in key _deepcopy_dict, value in x.iteritems (): runtime error: while executing your python program    Words change while walking.   How can I survive to do this?   Thank you in advance;)      General advice, as per other answers To avoid using, use  iteritems  (rather than use  items ). Of course, in your case, an option is  not , because  iteritems  calls are...






c++ - Binary tree number of nodes with a given level -



    I have to write a program that calculates the number of nodes from a certain level given in the binary tree   I mean & lt; Numberfonds (int level) {}>   I tried to write it without any success because I do not know how nodes are counted to reach a certain level.      Do this with a recursive function which only descends at a certain level.     






What is the difference between these two statements (asp.net/c#/entity
framework) -



     IEnumerable & lt; विभाग & gt; MyQuery = (myContext में डी से। डिपार्टमेंट ऑर्डर डी डी। DptName डी चुनें); Var myQuery = (myContext में D से। डिपार्टमेंट ऑर्डर डी डी। DptName D का चयन करें);    ऊपर दिए गए इन दो कथन में क्या अंतर है? मेरे छोटे asp.net/C#/ EF4.0 ऐप में मैं उन्हें किसी भी तरह से लिख सकता हूं, और जहाँ तक मैं उनका उपयोग करना चाहता हूं, वे दोनों काम करते हैं, लेकिन एक कारण होना चाहिए कि मैं एक दूसरे को क्यों चुनूं ?       (डी में myContext में। डिपार्टमेंट्स आदेश डी डीप्टाइनम डी चुनें);    एक प्रकार का ऑब्जेक्ट देता है  IQueriable & lt; विभाग & gt;  जो बदले में लागू करता है  IEnumerable & lt; Department & gt;    जबकि आप यहां  var  कीवर्ड का उपयोग करते हैं, कम्पाइलर इसे  IQueriable & lt; विभाग & gt;      





















Powered by Blogger