THANKS, BUT HOW TO USE IT . i DONT KOW HOW TO USE IT AND LOCALISE IT.

Check the attached txt file for design and query to be edited.

How to do that?.

thanki SSC

ok this will work fine to single action, like here for removing commas. but what if i have some other special character to remove then again i have to write...

yes, I want to eliminated comma before importing my data into sql server.

I ll Brief this :

I have one table eg table1 with has an id and multiple values for same id . i have one more table with the id of...

no, i have completed 90% of this but i want the insertion of data in second table which i think will be done by some loop. but i m...

yes the solution is satisfactory but i want something different. i have an execute sql task and

in that i have used a query which gives me single value....

oops i missed the condition of month.. yes i got it. Thanks

But actually i missed something. I missed one condition for month and year.

If month is feb then it ll...

Yes , your are right what your r saying . but my requirement is same and not changed, sorry by mistake i wrote that. I want if(feb) then sum(after feb...

I m not an old member of this group and plus i m a fresher to database. Anyway , your query has made my 60 % work done but...

Yes i got it . I have removed the condition in join for month :

cte c on c.stdid = d.stdid --and month(eddate) < monthno

now thw the sum is coming but...

yes, this is what i want, but what i wanted is to the column A and B the values in @tblmonth be added.

i.e row of a like 10+20+40.. to be...

yes, i have used char(13) but its still not showing result in new line

the problem is that i m using this value in a dataset for exporting in...