thanks, i will try to read it

can you give me example with LAG FUNCTION AND How to use it

i am trying to learn something here ok not copying or doing any cheating

this is by far i have tired

;with cte (month, totalchargedamount)
...

my table already stored value of sum(value) as a value

i just need to take value ,so i cannot do sum(value) in my select statement

is there any dynamic data flow approach ?

example if they are updating every month. but every 2 months.

what should i do

sorry type mistake, suppose i have 41 rows ,20 processed successfully and 21th got error.

now when next time my package run i want it to start fro 22 rows .

how...

thanks a lot

i am not finding it anywhere

yes interview question

so what data type i should give so that it wont come as $ in my excel sheet

thanks

but i cannot group by date ,most of the time i have same date or max 3 different dates.

will it give me same output

sample data:

date amount1 amount2 ...

it worked thank u so much.

i use replace(replace(Name,char(10),''),char(13),'')

i tried to use replace but still getting same result. at phone column from where its breaking into new line.

also i am using replace while iam inserting values into temp...

ok i did see my result in text editor in SSMS.

its not correct after phone its breaking into new line.

what should i change in my stored proc , to make...