Delting duplicate rows with condition

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

SELECT 326.8 AS ITEMCHARGE , 29075 AS CPT4 , 20101204 AS EFF_DATE , 'GO' AS CPT4MOD
INTO #Table
UNION ALL
SELECT 326.8 , 29075 , 20110104 , 'GO'
UNION ALL										
SELECT 326.8 , 29075 , 20110204 , 'GO'
UNION ALL										
SELECT 326.8 , 29075 , 20110406 , 'GO'
UNION ALL										
SELECT 352.69 , 29075 , 20090611 , 'GO'
UNION ALL										
SELECT 352.69 , 29075 , 20090917 , 'GO'
UNION ALL										
SELECT 352.69 , 29075 , 20100614 , 'GO'
UNION ALL										
SELECT 352.69 , 29075 , 20100722 , 'GO'

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results