13,042,819 members (79,120 online)
Rate this:
See more:
this question is deleted

this question is deleted

this question is deleted
Posted 17-Feb-13 18:34pm
Updated 17-Feb-13 21:06pm
v3
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?

Rate this:

## Solution 1

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

```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'

Top Experts
Last 24hrsThis month
 Karthik Bangalore 130 Satya Prakash Swain 130 OriginalGriff 105 ppolymorphe 105 Richard MacCutchan 75
 OriginalGriff 4,255 RickZeeland 1,834 F-ES Sitecore 1,483 ppolymorphe 1,474 Dave Kreskowiak 1,309