Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO Complaint
- SELECT Address_lookup.case_id as case_id FROM Address_lookup WHERE Address_lookup.case_id is not null
- UNION
- SELECT [Complaint type] as complaint_type FROM [dbo].['311 Open Data NYC$'] WHERE [Complaint type] is not null
- UNION
- SELECT [Location type] as location_type FROM [dbo].['311 Open Data NYC$'] WHERE [Location type] is not null
Add Comment
Please, Sign In to add comment
