kennyhuang0108 (8/4/2015)
Thank you very much Jason. None of the queries is working.The assignment is to exclude single LEV5 data and only show all the duplicate LEV5.
thanks.
Bf_ORGN_CD LEV5 BF_ACTY_CD
AC_21234_2 AC_21200_1 402
AC_21236_2 AC_21200_1 402
AC_21238_2 AC_21200_1 402
AC_53980_1 AC_53980_1 207
AC_53982_2 AC_53980_1 207
CB_10000_1 CB_10000_1 901
CB_10001_2 CB_10000_1 901
CB_10002_2 CB_10000_1 901
CB_10003_2 CB_10000_1 901
CB_10004_2 CB_10000_1 901
CB_10007_2 CB_10000_1 901
Please provide an example of what exactly you want the resulting data to look like.
In addition to that, provide the exact queries that you are using that are not working for your requirements.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events