Thank you Thom A   appreciate your assist

I've made the calendar table and added my holiday table and it seems works good except the

@AdjustMode -

it should Calculate the days between the...

this function is calculating the number of working days between two dates Excluding Weekend & Holiday

and it takes the holidays from table exist in another database (for attendance)

@DateFrom - The...

hi again

actually the function does not work properly after mant tests

for example i've tried

Select [dbo].[fn_GetLeaveDays_scalar] ('2020-09-24',1,'2020-09-25',1,1,1)

and it should returns only 1 as friday is weekend but it...

actually my knowledge with functions is very poor as this is first time to use function

appropriate if you guide me to how to convert my mlTVF to iTVF and what...

FINALLY IT WORKS 🙂

the issue was in how to call the function not in the mentioned above modified function

it works fine when i used this to call it

            
September 29, 2020 at 1:16 pm
            
#3791621

            
            
                                                
        

actually i can't make that calendar table and even if i can, my concern is : that table should be created for how many years? and how to define the...

i've tried the below and got this error : Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_GetLeaveDays", or the name is ambiguous.

ALTER FUNCTION [dbo].[fn_GetLeaveDays]

(

@DateFrom DATETIME2,

@CalendarFunction INT,

@DateTo...

thank you.

Dears drew.allen & J Livingston thanks a lot

both ways working exellent

and also the cross tab provided by 'Livingston' is perfect except that i should desided how many colums do i...

Hi J Livingston,

thanks and appreciate ur assist.:-):-)

I've trying all day to do the cross tab by myself with no luck then finally i export it to access database and it...

lets say that in our bussiness the price always increasing or fixed.

no, only the itmId

may we can determine the highest one then the second then the third ?!

would you please to post the tables structure with sample data to be have a full view

Thank you very mach "Serg-52", I really appreciate your assistance.

Hi Jeff,

Actually, I thought that this case is deferent as we’ve a deferent/modified table structure:ermm: moreover the previous post has been stopped and I didn’t get any other answer...