Hi,

put varchar datatype, why because actual data is like: Sorry for not mentioning earlier.

99.87%, 99.96%, 8.67%

Thanks,

Abhas.

Hi All,

Thanks for reply.

But is it possible search "." and select only one character after ".". because dataype is varchar here.

kindly help.

Thanks,

Abhas.

Thanks Cadavre,

I done the same but different way. I inserted data forst into temp table and do left join of that temp table with main query. But you have simplified...

Thanks,

I tried as below:

First execute sql task, Fetching file names and storing into variable here.

After i am using for each loop container. in that using script task. but not able...

Thanks Phil,

Could you please share sample or design?

Thanks

Abhas

Hi All,

Thank you so much. All solutions are suitable.

Thank yoy very much. 🙂 🙂

Thanks

Abhas.

Hi All,

I want to list Dates for particular day between two dates.

for eg. if user enters 08/01/2014 and 08/31/2014 with value 0 then all the Sundays and related dates...

Thanks Gail,

I am trying to do. Think will stuck to multi sort using probably case statement.

Thanks

Abhas.

Thanks Gail,

I will try. Could you please share sample code if you have?

Thanks,

Abhas.

Thanks for reply,

But i want to bind this with output parameter.

If record insert then 1 else 0

Thanks

Abhas.

Thank you anthony and Hardy.

Thank you very much for both of you for quick reply.

Both approaches are working fine.

Thanks

Abhas.

Thanks you

Chris and Louis. Its working.... :-):-):-)

Thanks,

Abhas.

Thanks Kingston Dhasian 🙂

its working for me. Thank you very much for your quick help

🙂

🙂

🙂

Thanks

Abhas

Hi J Livingston

Exactly same...

Thanks

Abhas

Hi All,

Its Security issue.

Thanks for your help.

Thanks

Abhas