Hey,

Thanks that's almost what i was expecting but when i followed the same i am getting the data in single excel file inserted into table multiple times i.e, if...

Hey Rob,

I will give detailed picture to you.

i have a column in a table .

i need validate that data by conditions and get the same data formatted.

its like 'abcd@' --original...

Hey thank you....i got the output.

Hi Ron,

Thank you for your valuable suggestion.I learnt many technical issues.I got the solution from other forum member and it is working fine.:-)

Thanks,

Hemanth.

Hi,

Thank you very much for the code you suggested,i was searching for a solution since some time.

I used it by some improvising the code and it is working fine. 🙂

Thanks,

Hemanth

Hi Jack,

I followed Lowell's code and its working fine.Just as you said UPDATE function may result in unnecessary INSERT's.

Thank you for extending my area of solution.

Hemanth

..........................................................................................................................................................

Hi Lowell,

I tried your code for my trigger.It is working fine.

Thank you for your valuable suggestion.

Hemanth

....................................................................................................................................................

hi,

i m using sql server 2005 express edition free version. i m not using sql server with advanced features.

Is it possible by business intelligence studio server to generate reports and...

hi,

Thanks for your advice.....

hi,

thanks for u r feedback.i couldnt frame my doubt clearly.Now i try to clarify.....

i have to send message service to mobiles(sms) through smsgateway using smpp protocol --to the users of...

hi,

thanks for your advice.surely i will not use caps hereafter,and also thank you for the solution u gave to my scenario.:-)

hi,

the changeable data is calculated--one coloumnand the other coloumn is auto-generated sequence.

can u help me with this!!!!

thanks!!