CREATE UNIQUE NONCLUSTERED INDEX [IX_TableName_FieldName]
ON [dbo].[TableName]
(
[FieldName] ASC
) WITH (IGNORE_DUP_KEY = ON) ON [PRIMARY]
ON [dbo].[TableName]
(
[FieldName] ASC
) WITH (IGNORE_DUP_KEY = ON) ON [PRIMARY]
Excel :: Text :: 1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula :: TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...
No comments:
Post a Comment