Database

;WITH cte AS
(
    SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE('.'+TREE+'.',
    '.0.', '.00.'),
    '.1.', '.01.'),
    '.2.', '.02.'),
    '.3.', '.03.'),
    '.4.', '.04.'),
    '.5.', '.05.'),
    '.6.', '.06.'),
    '.7.', '.07.'),
    '.8.', '.08.'),
    '.9.', '.09.') AS TREE
    FROM MYTABLE
)
, cte2 AS
(
    SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE('.'+TREE+'.',
    '.0.', '.00.'),
    '.1.', '.01.'),
    '.2.', '.02.'),
    '.3.', '.03.'),
    '.4.', '.04.'),
    '.5.', '.05.'),
    '.6.', '.06.'),
    '.7.', '.07.'),
    '.8.', '.08.'),
    '.9.', '.09.') AS TREE
    FROM cte
)
SELECT * FROM cte2;

USE master
IF EXISTS(SELECT * FROM sys.databases WHERE Name = 'BookCatalog')
DROP DATABASE BookCatalog
Go
CREATE DATABASE BookCatalog
GO
USE [BookCatalog]
GO

CREATE TABLE [dbo].[BookCategories]
(
    [Id]        [INT] IDENTITY(1,1) PRIMARY KEY NOT NULL,
    [Name]      VARCHAR(MAX) NOT NULL,
)

CREATE TABLE [dbo].[Books]
(
    [Id]        [INT] IDENTITY(1,1) PRIMARY KEY NOT NULL,
    [Category]  [INT] NULL FOREIGN KEY (Id) REFERENCES BookCategories(Id),
    [Title]     VARCHAR(MAX) NOT NULL,
    [Price]     MONEY NULL
)

CREATE TABLE [dbo].[Authors]
(
    [Id]        [INT] IDENTITY(1,1) PRIMARY KEY NOT NULL,
    [Name]      VARCHAR(MAX) NOT NULL,
)

CREATE TABLE [dbo].[BookAuthors]
(
    [Id]        [INT] IDENTITY(1,1) PRIMARY KEY NOT NULL,
    [Book]      [INT] NULL FOREIGN KEY (Id) REFERENCES Books(Id),
    [Author]    [INT] NULL FOREIGN KEY (Id) REFERENCES Authors(Id),
)

GO
USE [BookCatalog]

-- Book Categories
DECLARE @CategoryId1 INT
INSERT INTO BookCategories (Name) VALUES ('C#')
SET @CategoryId1 = SCOPE_IDENTITY()

DECLARE @CategoryId2 INT
INSERT INTO BookCategories (Name) VALUES ('Programming Practices')
SET @CategoryId2 = SCOPE_IDENTITY()

-- Authors
DECLARE @MartinId INT
INSERT INTO Authors (Name) VALUES ('Bob Martin')
SET @MartinId = SCOPE_IDENTITY()

DECLARE @Albahari1Id INT
INSERT INTO Authors (Name) VALUES ('Joseph Albahari')
SET @Albahari1Id = SCOPE_IDENTITY()

DECLARE @Albahari2Id INT
INSERT INTO Authors (Name) VALUES ('Ben Albahari')
SET @Albahari2Id = SCOPE_IDENTITY()

DECLARE @WagnerId INT
INSERT INTO Authors (Name) VALUES ('Bill Wagner')
SET @WagnerId = SCOPE_IDENTITY()

DECLARE @SkeetId INT
INSERT INTO Authors (Name) VALUES ('Jon Skeet')
SET @SkeetId = SCOPE_IDENTITY()

-- Books
DECLARE @BookId1 INT
INSERT INTO Books (Category, Title, Price) VALUES (@CategoryId1, 'Agile Principles, Patterns, and Practices in C#', 64.99)
SET @BookId1 = SCOPE_IDENTITY()

DECLARE @BookId2 INT
INSERT INTO Books (Category, Title, Price) VALUES (@CategoryId2, 'C# 3.0 in a Nutshell', 34.99)
SET @BookId2 = SCOPE_IDENTITY()

DECLARE @BookId3 INT
INSERT INTO Books (Category, Title, Price) VALUES (@CategoryId2, 'C# Core Langaue: Little Black Book', 20.00)
SET @BookId3 = SCOPE_IDENTITY()

DECLARE @BookId4 INT
INSERT INTO Books (Category, Title, Price) VALUES (@CategoryId2, 'C# In Depth', 44.99)
SET @BookId4 = SCOPE_IDENTITY()

--Book-Authors
INSERT INTO BookAuthors (Book, Author) VALUES (@BookId1, @MartinId)
INSERT INTO BookAuthors (Book, Author) VALUES (@BookId2, @Albahari1Id)
INSERT INTO BookAuthors (Book, Author) VALUES (@BookId2, @Albahari2Id)
INSERT INTO BookAuthors (Book, Author) VALUES (@BookId3, @WagnerId)
INSERT INTO BookAuthors (Book, Author) VALUES (@BookId4, @SkeetId)