SELECT DISTINCT
LTRIM(RTRIM(queryParam)) AS qpTrimmed
FROM queryParamValTbl
has duplicates (it removes most duplicates)
I assumed that
scngs_zone
scngs_zone
was really
'scngs_zone'
'scngs_zone ' -- trailing whitespace
So I tried the following:
SELECT
DISTINCT
LTRIM(RTRIM(queryParam)) AS qpTrimmed
INTO #rTmp
FROM queryParamValTbl
ORDER BY qpTrimmed
SELECT DISTINCT * FROM #rTmp
-- But it has the exact same duplicates
Note, most duplicates are removed.
SQL 2000 & Win03 - lastest updates on each
LTRIM(RTRIM(queryParam)) AS qpTrimmed
FROM queryParamValTbl
has duplicates (it removes most duplicates)
I assumed that
scngs_zone
scngs_zone
was really
'scngs_zone'
'scngs_zone ' -- trailing whitespace
So I tried the following:
SELECT
DISTINCT
LTRIM(RTRIM(queryParam)) AS qpTrimmed
INTO #rTmp
FROM queryParamValTbl
ORDER BY qpTrimmed
SELECT DISTINCT * FROM #rTmp
-- But it has the exact same duplicates
Note, most duplicates are removed.
SQL 2000 & Win03 - lastest updates on each