Off Topic » Issue with Merge ??

hello,

I am facing one issue with my merge statement
I am having 1 requirment
in my source table column having data like
Primary ( to be primary)
Secondery (to be secondery)

I want to load only primary and secondery or any thing before '(' using merge statement.

is this possible in merge

Please help.
Thanks!

I didn't find the right solution from the Internet.

Reference:
https://social.msdn.microsoft.com/Forums...rum=transactsql


business consultancy services