Thanks for your thoguhts ..

I believed that Primary key needs an index (clustred/ non-clustred) but wanted to see if we can create it without index.

I have attempted with an...

Luis,

I think your query is right if we remove the where clause as we need to show status 'OP' as well in the output.

SELECT EID,

[Status],

...