Hi,
Here is some sample data:
CREATE TABLE
#MyTable
(
Pk INT,
GroupID INT,
Value VARCHAR(10)
)
INSERT INTO #MyTable (Pk, GroupID, Value) VALUES (1,1,NULL)
INSERT INTO #MyTable (Pk, GroupID, Value) VALUES (2,1,'')
INSERT INTO #MyTable (Pk, GroupID, Value) VALUES (3,1,'ABC')
INSERT INTO #MyTable (Pk, GroupID, Value) VALUES (4,2,'')
INSERT INTO #MyTable (Pk, GroupID, Value) VALUES (5,2,'XYZ')
INSERT INTO #MyTable (Pk, GroupID, Value) VALUES (6,3,NULL)
SELECT * FROM #MyTable
DROP TABLE #MyTable
I am looking to retrieve any GroupID in which every Value of that GroupID is either (a) null, (b) an empty string, or (c) "XYZ". So in the above example, GroupID #1 would not be returned in my query because there is a Value of "ABC", but GroupID #2 would be returned since it consists of only nulls, "XYZ"'s, and empty strings.
What would be the most efficient way to write such a query?
I greatly appreciate any assistance!
Retrieve when all values in group have same record
Posted - 2015-02-25 : 10:30:14
