Viewing 9 posts - 1 through 9 (of 9 total)
Thanks All,
For this use case, I don't care which of the duplicate records gets inserted.
I don't see the option on this forum page to tag this post...
January 4, 2018 at 5:46 am
January 3, 2018 at 1:28 pm
ok I follow your Table Alias now.
Yes, fields5-20 represents 15 other individual columns I spared the forum having to read.
ImpTbl_ComputerInventory is the only Table with data at...
January 3, 2018 at 12:49 pm
I'm sure ya'll season SQL users understand Lynn's ideal, however for this newbie, I have no clue what her [ci2] or [ci1] refers too and can only guess the "Select 1" is some...
January 3, 2018 at 10:36 am
Looking at the Extended Properties Both say Collation= SQL_Latin1_General_CP1_CI_AS
And the field types are the same..
CREATE TABLE [dbo].[ImpTbl_ComputerInventory](
[Computer Name] [nvarchar](15) NOT NULL,
[Service Tag] [nvarchar](35) NOT NULL,
December 29, 2017 at 7:03 am
Not following your references to the Red 1 char or ci1, ci2 ?
December 28, 2017 at 2:46 pm
Viewing 9 posts - 1 through 9 (of 9 total)