Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE foo (
- id int IDENTITY(1,1) PRIMARY KEY,
- parent_no int DEFAULT 0,
- name varchar(255),
- );
- INSERT INTO foo (name, parent_no) VALUES ('Locations', 0),VALUES ('NSW', 1),VALUES ('QLD', 1),VALUES ('VIC', 1),VALUES ('Sydney', 2),VALUES ('Brisbane', 3),VALUES ('Melbourne', 4),VALUES ('Sydney Head Office', 5),VALUES ('Brisbane Head Office', 6),VALUES ('Melbourne Head Office', 7),VALUES ('Level 21 Martin Place', 8),VALUES ('Level 22 Martin Place', 8),VALUES ('Level 23 Martin Place', 8),VALUES ('Level 24 Martin Place', 8),VALUES ('First Floor', 9),VALUES ('Ground Floor', 9),VALUES ('Second Floor', 9);
Add Comment
Please, Sign In to add comment