I know it can be done by dynamic sql but is there any way to do it without dynamic sql?

Thanks,

kayal