OMG... you are awesome !it's working perfectly but it's hard to understand based on my knowledge level.

thanks Mark!

thanks tim,

what i want to design is even before going to data flow i want to perform all the checks and based on the condition i have all the follow...

Hi guru,

the volume should be float value and it's derived from query column{select count(*) from ..}

e.g in the first row if you excute the select query from...

Im thinking add seq number to the table and using seq to update each row in the table but am not sure. any suggestion?

...

Thanks Thom &John,

You guys idea is valid. thanks a lot now i can able to slove the problem.

Again Thanks a lot!

Austin

hi,

the first businessday it can be any weekday . eg 8-1-2017 is tuesday

Thom,

iI already have a holiday table.
e.g   holiday   date
         newyear   1-1-2017
          ..      ...

hi john ,

you may misunderstood my point, i was saying i want to run all the sps(sp1 &sp2&sp3) on first bussiness day.
and here the business day not...

ho Thom,

yes when i said business day means except holidays.

Thanks John, it works and it's more easier!! You are awesome 

select a.*,
avg(salary) over(partition by dept) as dept_avg,
avg(salary) over(partition by ...

for the second one 
-

select a.*,
(select avg(salary) from emp)as com_avg,
b.Dept_avg
from emp a
join (select...

I guess u can try while loop instead of cursor.

thanks john,

1) first question is resolved
delete e
from(
select *,seq =ROW_NUMBER() over(partition by code,state order by date desc) from #state
...

implement this logic*

That's my question.

how many days of that week were in each month? How to write a code to implement this code