[SQL Server 2005] Delete avec conditions
Bonjour,
Je souhaite supprimer toutes les lignes d'une table qui ne sont pas en double (sur deux champs)
Table :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14
| CREATE TABLE [dbo].[ItemPackagingSplit](
[ItemNo] [varchar](20) NOT NULL,
[LogisticType] [varchar](10) NOT NULL,
[SplitPackagingNo] [varchar](10) NOT NULL,
[PackagingDescription] [varchar](30) NOT NULL,
[MainValue] [tinyint] NOT NULL,
[BarCodeToCreate] [tinyint] NULL,
CONSTRAINT [PK_ItemPackagingSplit] PRIMARY KEY CLUSTERED
(
[ItemNo] ASC,
[LogisticType] ASC,
[SplitPackagingNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] |
je cherche a completer la requete suivante :
Code:
1 2 3 4 5 6 7
|
delete from ItemPackagingSplit
where [ItemNo],[LogisticType] IN
(select [ItemNo],[LogisticType]
from ItemPackagingSplit
group by [ItemNo], [LogisticType]
HAVING COUNT(*)<2) |
Cette requete ne marche bien sur pas (sinon je ne serais pas la :roll:).
Sauriez vous me dire comment supprimer tous les lignes de ma table qui réponde à la condition suivante ?
Code:
1 2 3 4 5
|
select [ItemNo],[LogisticType]
from ItemPackagingSplit
group by [ItemNo], [LogisticType]
HAVING COUNT(*)<2 |