DECLARE @PersonAddress TABLE
(
PiD int,
Address1 varchar(50),
Address2 varchar(50)
)
INSERT INTO @PersonAddress (PiD, Address1, Address2)
SELECT 1, '123 ABC St', 'Suite 201' UNION ALL
SELECT 1, '123 XYZ St', 'Suite 201' UNION ALL
SELECT 1, '123 Cookie St', 'Suite 201' UNION ALL
SELECT 1, '123 ABC St', 'Suite 201' UNION ALL
SELECT 1, '123 ABC St', 'Suite 301' UNION ALL
SELECT 2, '457 Marvel St', 'Suite 1001' UNION ALL
SELECT 2, '1 DownTown Lane', '' UNION ALL
SELECT 3, '2 Busy Rd', 'Apt 2001' UNION ALL
SELECT 3, '2 Busy Ave', 'Apt 20' UNION ALL
SELECT 3, '2 Busy Ave', 'Apt 20' UNION ALL
SELECT 4, '10 CutOver Lane', 'Suite 201' UNION ALL
SELECT 4, '10 CutOver Lane', 'Suite 301' UNION ALL
SELECT 4, '10 CutOver Lane', 'Suite 401' UNION ALL
SELECT 5, '10 CutOver Lane', 'Suite 201' UNION ALL
SELECT 5, '10 CutOver Lane', 'Suite 301'
ASKER
ASKER
DECLARE @PersonAddress TABLE
(
PiD int,
Address1 varchar(50),
Address2 varchar(50)
)
INSERT INTO @PersonAddress (PiD, Address1, Address2)
SELECT 30, '73-345 Power Pl', 'Suite 200' UNION ALL
SELECT 30, '73-345 Power Pl', 'Suite 200' UNION ALL
SELECT 30, '73-345 Power Pl', 'Suite 200' UNION ALL
SELECT 30, '73-345 Power Pl', 'Suite 200' UNION ALL
SELECT 30, '73-345 Power Pl', 'Suite 200' UNION ALL
SELECT 30, '73-345 Power Pl', 'Suite 200' UNION ALL
SELECT 30, '75-240 Krazy Dr', 'Suite 6B' UNION ALL
SELECT 30, '75-240 Krazy Dr', 'Suite 6B' UNION ALL
SELECT 30, '75-240 Krazy Dr', 'Suite 6B' UNION ALL
SELECT 30, '75-240 Krazy Dr', 'Suite 6B' UNION ALL
SELECT 30, '75-240 Krazy Dr', 'Suite 6B' UNION ALL
SELECT 30, '75-240 Krazy Dr', 'Suite 6B' UNION ALL
SELECT 30, '98-151 Saint St', 'Suite 142' UNION ALL
SELECT 30, '98-151 Saint St', 'Suite 142' UNION ALL
SELECT 30, '98-151 Saint St', 'Suite 142' UNION ALL
SELECT 30, '98-151 Saint St', 'Suite 142' UNION ALL
SELECT 30, '98-151 Saint St', 'Suite 142'
ASKER
ASKER
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY
Open in new window