asked on
DROP TABLE #tbl_WithSomeFields
CREATE TABLE
#tbl_WithSomeFields (
MyID VARCHAR(255)
,MyPID VARCHAR(20)
,MyOtherThing VARCHAR(100)
,MyOtherOtherThing VARCHAR(10)
,MyDate DATETIME
,MyMinDateTime DATETIME
);
INSERT INTO
#tbl_WithSomeFields (MyID, MyPID, MyOtherThing, MyOtherOtherThing, MyDate, MyMinDateTime)
VALUES
('1', '1234567', 'A', '12C', '2018-10-24 20:39:00', ''),
('1', '1234567', 'A', '11C', '2018-10-24 15:39:00', ''),
('2', '1234567', 'A', '12B', '2018-10-23 20:39:00', ''),
('2', '1234567', 'A', '13D', '2018-10-24 20:39:00', ''),
('3', '1234567', 'A', '8', '2019-10-24 20:39:00', '');