Click here to Skip to main content
12,076,206 members (48,613 online)
Rate this:
 
Please Sign up or sign in to vote.
this question is deleted

this question is deleted

this question is deleted
Posted 17-Feb-13 19:34pm
Edited 17-Feb-13 22:06pm
v3
Comments
Zoltán Zörgő 18-Feb-13 0:43am
   
This question had nothing to do with c# or asp.net since you posted a portion of a stored procedure.
Is the sp executing correctly if you start it directly from SQL Management Studio?

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Don't quite understand your talk of loops etc. but an observation:

Your code is summarised as

if duration < FulldayAllowance
     Do A
Else
     If duration < halfdayAllowance
         Do B
     Else
         Do C

Assuming FulldayAllowance to be 8 and half day to be 6, that gives us

if duration < 8
     Do A
Else
     If duration < 6
         Do B
     Else
         Do C

So - if duration is 1 it should Do A (because 1 is less than 8)
If duration is 7.9999 it will still to A because 7.9999 us less than 8
If duration is 8 or higher it will do C

B cannot happen

This is probably not what you want;

So what you (probably) want to do is swap the tests for Full and Half day around, so it tests less than 6 first, then if it's not less than 6 test less than 8, if not less than 8 it does the 'default'
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web04 | 2.8.160208.1 | Last Updated 18 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100