Big Int Problem

Transact-SQL
21

@ScottPletcher was correct. It does have indexes

	CREATE UNIQUE NONCLUSTERED INDEX [key0] ON [dbo].[Product_Structure]
	(
		[PARPRT_02] ASC,
		[COMPRT_02] ASC,
		[EFFDTE_02] ASC,
		[ALTCDE_02] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
	GO

I'm guessing I should re-index before running the query.

22

what do you get for this targeting the columns in that Index

 ;with cte
 as
 (
 select   PARPRT_02,'349-00006001-03' as COMPRT_02,'2018-10-10' as EFFDTE_02,'' as ALTCDE_02
  FROM [Product_Structure]
  WHERE PARPRT_02 LIKE '41%
)

select PARPRT_02,COMPRT_02, EFFDTE_02, ALTCDE_02, count(1)
 from cte
 group by PARPRT_02,COMPRT_02, EFFDTE_02, ALTCDE_02
 havinng count(1) > 1
23

I was thinking this also yosiasz
:slightly_smiling_face::slightly_smiling_face:

Unique
Index created on 3 columns

Combination of 3 columns
Duplicate s
Can be identified
Group by
Having count (*) > 1

I have some doubts about how 3 columns
Group by
I mean
Col1,Col2,Col3. ..using commas
Or
Col1+Col2+Col3 . concatenation of 3 columns into one value