Thanks for the info Luis and Piet 🙂

Thanks Alan but that doesn't really work for me.

Because what I want is to get for each part number the last (max date_a) percent_b that was entered

And the earliest...

Thanks to both of you. I've used tuning advisor and apply the recommendations and I've gain more speed now.

The execution plan it's already in the zip file

Thanks,

Stan

Here the structure I will provide the sample data soon.

Can you tell me if that will be Ok some script with insert statement, for the sample data that you required?

Thanks,

Stan

Sorry about that I didn't not see the article at the beginning, and that's why I was kept replying back to you.

Thanks a lot and have a nice day,

Stanley

Usually I post my question her. If that's not the right place to do it can you please let me know??

Thanks,

Yes my question is how can I import 3 excel file with different structure, to 3 different sql table with SSIS?

Thanks,

Yes it financial stuff. But thanks for your advice. I will put that in practice 🙂

Thanks Louis 🙂

Thanks for the quick answer

Thanks Jeff my problem is fixed now

Thanks Dugi that help me fix my problem.

Have a nice day,

Stan

The procedure is use to set a flag in the table RRF_FICH_GPS_BRUT

Here is the table def and sample data :

USE [MRG_M002]

GO

/****** Object: Table [dbo].[RRF_SEGMN_RETRO] Script Date:...

Thanks a lot guys for your effort helping me solving this issue. Removing all the functions from the where clause solve the problem. The query ran a lot faster now....