Thanks for your Example we have tried with the same before, but we need in query ( not in dynamic qry). because we have done in many place like this...
I have created partition table and view. with using below code create table p11(dt int not null check (dt>=10 and dt<20),nam varchar(10) not null)...
Separate names with a comma.
