Hi,

When in real life the partition function is used?

Thanks & regards,

SS

Hi Ken,

It's giving error as follows:

Msg 321, Level 15, State 1, Line 28

"sql_handle" is not a recognized table hints option. If it is intended as a parameter to a table-valued...

Hi,

Could you please elaborate reg what you did in that query as I am not getting it?

You can please provide the acript for the tables you are using so that...

Hi,

Thanks a lot:)

Hi,

Thanks buddy.

Hi,

Many thanks for your reply.

Thats great.

Even we can do it as follows:

delete from BTBLPRODUCT_MST where COMP_ID IS NULL AND PRODUCT_ID = (SELECT MAX(PRODUCT_ID) FROM BTBLPRODUCT_MST)

Am I right??