Click here to Skip to main content
11,933,854 members (56,345 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
Zoltán Zörgő 18-Feb-13 0:43am
This question had nothing to do with c# or 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
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
     If duration < halfdayAllowance
         Do B
         Do C

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

if duration < 8
     Do A
     If duration < 6
         Do B
         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'

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.151126.1 | Last Updated 18 Feb 2013
Copyright © CodeProject, 1999-2015
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