Where clause bug?

sqlpadawansqlpadawan Posts: 6
edited July 10, 2015 4:53PM in SQL Data Compare 11
This afternoon ran a sql data compare using a where clause to filter the data in a table to compare. When I used the deployment wizard, I ended up with sql statements with two where clauses:

EXEC(N'UPDATE [dbo].[Table1] SET [Col1]=5.56, [Col2]=8.55, [Col3]=42.00, [Col4]=''RC '', [Col5]=''2015-07-08 00:00:00.000'', [Col6]=''2015-07-07 20:50:06.193'', [Col7]=2.50 WHERE [Col8] = 9 AND [Col9] = ''XX'' AND [Col10] = 2 AND [Col11] = 19742985 AND (WHERE [Col11] IN ( 2993304, 2993519, 3025220, 3081347, 3085337, 3092625, 3093660, 3156319, 3223346, 3270582, 3341110, 19742985)

This was the where clause in the project to filter the data in the compare: (WHERE [Col11] IN ( 2993304, 2993519, 3025220, 3081347, 3085337, 3092625, 3093660, 3156319, 3223346, 3270582, 3341110, 19742985)

Is this a bug or did I do something wrong?

Comments

Sign In or Register to comment.