get hierarchical values

    USE [SQLTest]
    GO
    /****** Object: Table [retail].[Category] Script Date: 9/10/2015 5:24:17 AM ******/

    SET ansi_nulls ON
    GO
    SET quoted_identifier ON
    GO
    SET ansi_padding ON
    GO

    CREATE TABLE [retail].[Category] (
        [CategoryID] [INT] IDENTITY(1, 1) NOT NULL
        ,[CategoryName] VARCHAR NOT NULL
        ,[fParentCategoryID] [INT] NULL
        ,CONSTRAINT [PK_Category] PRIMARY KEY clustered ([CategoryID] ASC) WITH (
            PAD_INDEX = off
            ,STATISTICS_NORECOMPUTE = off
            ,IGNORE_DUP_KEY = off
            ,ALLOW_ROW_LOCKS = ON
            ,ALLOW_PAGE_LOCKS = ON
            ) ON [PRIMARY]
        ) ON [PRIMARY]
    GO

    SET ansi_padding off
    GO
    SET identity_insert [retail].[Category] ON

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        325
        ,N'Accessories'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        326
        ,N'After Sun Care'
        ,448
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        327
        ,N'Aftershave'
        ,410
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        328
        ,N'Baby'
        ,414
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        329
        ,N'Bags & Cases'
        ,404
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        330
        ,N'Bath & Body'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        331
        ,N'Bath & Body Gifts'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        332
        ,N'Bath & Spa'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        333
        ,N'BB & CC Creams'
        ,372
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        334
        ,N'Beauty-Supersized'
        ,377
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        335
        ,N'Blush'
        ,372
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        336
        ,N'Body & Hand Care'
        ,439
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        337
        ,N'Bronzer & Highlighters'
        ,372
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        338
        ,N'Brow & Lash Tools'
        ,343
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        339
        ,N'Brows'
        ,371
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        340
        ,N'Brush Cleaner'
        ,343
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        341
        ,N'Brush Sets'
        ,343
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        342
        ,N'Brushes & Combs'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        343
        ,N'Brushes & Tools'
        ,404
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        344
        ,N'Bubble Bath & Oil'
        ,332
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        345
        ,N'Butters & Creams'
        ,413
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        346
        ,N'By Category'
        ,381
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        347
        ,N'By Recipient'
        ,381
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        348
        ,N'Candles'
        ,377
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        349
        ,N'Child'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        350
        ,N'Cleansers'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        351
        ,N'Clippers'
        ,453
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        352
        ,N'Clips & Bobby Pins'
        ,325
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        353
        ,N'Cologne'
        ,410
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        354
        ,N'Concealer'
        ,372
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        355
        ,N'Conditioner'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        356
        ,N'Contouring'
        ,372
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        357
        ,N'Cream'
        ,387
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        358
        ,N'Curling Irons'
        ,388
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        359
        ,N'Cuticle Care'
        ,416
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        360
        ,N'Deodorant'
        ,463
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        361
        ,N'Dry Shampoo'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        362
        ,N'Dryers'
        ,388
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        363
        ,N'Elastics'
        ,325
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        364
        ,N'Exfoliators & Masks'
        ,439
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        365
        ,N'Eye Care'
        ,439
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        366
        ,N'Eye Lashes'
        ,371
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        367
        ,N'Eye Liner'
        ,371
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        368
        ,N'Eye Makeup Remover'
        ,371
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        369
        ,N'Eye Palettes'
        ,371
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        370
        ,N'Eye Shadow'
        ,371
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        371
        ,N'Eyes'
        ,404
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        372
        ,N'Face'
        ,404
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        373
        ,N'Facial Treatments'
        ,440
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        374
        ,N'Files'
        ,453
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        375
        ,N'Flat Irons'
        ,388
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        376
        ,N'Foundation'
        ,372
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        377
        ,N'Fragrance'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        378
        ,N'Fragrance Gift Sets'
        ,377
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        379
        ,N'Fragrance Gifts'
        ,346
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        380
        ,N'Gel Manicure'
        ,420
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        381
        ,N'Gifts'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        382
        ,N'Gifts with Purchase'
        ,381
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        383
        ,N'Hair'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        384
        ,N'Hair Color'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        385
        ,N'Hair Extensions'
        ,325
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        386
        ,N'Hair Gifts'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        387
        ,N'Hair Removal'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        388
        ,N'Hair Styling Tools'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        389
        ,N'Haircare'
        ,409
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        390
        ,N'Headbands'
        ,325
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        391
        ,N'Hi-Tech Tools'
        ,388
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        392
        ,N'Hot Rollers'
        ,388
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        393
        ,N'Kid''s Haircare'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        394
        ,N'LED Lights'
        ,453
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        395
        ,N'Like A Mom'
        ,347
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        396
        ,N'Lip Care'
        ,439
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        397
        ,N'Lip Gloss'
        ,400
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        398
        ,N'Lip Liner'
        ,400
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        399
        ,N'Lip Stain'
        ,400
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        400
        ,N'Lips'
        ,404
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        401
        ,N'Lipstick'
        ,400
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        402
        ,N'Lotion'
        ,413
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        403
        ,N'Lotion & Gel'
        ,463
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        404
        ,N'Makeup'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        405
        ,N'Makeup Brushes'
        ,343
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        406
        ,N'Makeup Gifts'
        ,404
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        407
        ,N'Manicure & Pedicure'
        ,419
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        408
        ,N'Mascara'
        ,371
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        409
        ,N'Men'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        410
        ,N'Men''s Fragrance'
        ,377
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        411
        ,N'Mirrors'
        ,343
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        412
        ,N'Mist'
        ,463
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        413
        ,N'Moisturizers'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        414
        ,N'Mother & Baby'
        ,439
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        415
        ,N'Nail Appliques'
        ,420
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        416
        ,N'Nail Care'
        ,420
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        417
        ,N'Nail Gifts'
        ,420
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        418
        ,N'Nail Polish'
        ,420
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        419
        ,N'Nail Sets'
        ,420
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        420
        ,N'Nails'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        421
        ,N'Oils'
        ,413
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        422
        ,N'Perfume'
        ,463
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        423
        ,N'Powder'
        ,372
        ) GO

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        424
        ,N'Pregnancy'
        ,414
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        425
        ,N'Primer'
        ,371
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        426
        ,N'Removers'
        ,404
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        427
        ,N'Rollerballs & Purse Sprays'
        ,463
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        428
        ,N'Salon Professional'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        429
        ,N'Salts'
        ,332
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        430
        ,N'Scrubs & Exfoliants'
        ,350
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        431
        ,N'Self-Tanning & Bronzing'
        ,448
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        432
        ,N'Sets'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        433
        ,N'Shampoo'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        434
        ,N'Sharpeners'
        ,343
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        435
        ,N'Shave'
        ,387
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        436
        ,N'Shaving & Grooming'
        ,440
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        437
        ,N'Shine Control'
        ,372
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        438
        ,N'Shower Gel'
        ,410
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        439
        ,N'Skin'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        440
        ,N'Skin Care'
        ,409
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        441
        ,N'Soap'
        ,350
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        442
        ,N'Spa Essentials'
        ,332
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        443
        ,N'Specialty Irons'
        ,388
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        444
        ,N'Sponges & Applicators'
        ,343
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        445
        ,N'Styling'
        ,471
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        446
        ,N'Styling Accessories'
        ,325
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        447
        ,N'Styling Products'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        448
        ,N'Suncare'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        449
        ,N'Sunscreen'
        ,448
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        450
        ,N'Supplements'
        ,439
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        451
        ,N'Teeth Whitening'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        452
        ,N'Toner'
        ,439
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        453
        ,N'Tools'
        ,420
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        454
        ,N'Tools & Accessories'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        455
        ,N'Top & Base Coats'
        ,416
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        456
        ,N'Travel'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        457
        ,N'Treatment'
        ,383
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        458
        ,N'Treatment & Serums'
        ,439
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        459
        ,N'Treatments'
        ,416
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        460
        ,N'Treatments & Balms'
        ,400
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        461
        ,N'ULTA Collection'
        ,NULL
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        462
        ,N'Wax'
        ,387
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        463
        ,N'Women''s Fragrance'
        ,377
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        464
        ,N'ULTA Gifts'
        ,461
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        465
        ,N'Skin Gifts'
        ,439
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        466
        ,N'Bath & Body by ULTA'
        ,461
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        467
        ,N'Brushes & Tools by ULTA'
        ,461
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        468
        ,N'Diffusers'
        ,472
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        469
        ,N'Gift Cards'
        ,381
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        470
        ,N'Gifts for Him'
        ,381
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        471
        ,N'Hair by ULTA'
        ,461
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        472
        ,N'Home'
        ,377
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        473
        ,N'Luxury Nail'
        ,420
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        474
        ,N'Makeup by ULTA'
        ,461
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        475
        ,N'Men by ULTA'
        ,461
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        476
        ,N'Post-Partum'
        ,414
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        477
        ,N'Self Tanning'
        ,330
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        478
        ,N'Sets by ULTA'
        ,461
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        479
        ,N'Mens '
        ,333
        )

    INSERT [retail].[Category] (
        [CategoryID]
        ,[CategoryName]
        ,[fParentCategoryID]
        )
    VALUES (
        480
        ,N'Whitening'
        ,479
        )

    SET identity_insert [retail].[Category] off

    ALTER TABLE [retail].[Category]
        WITH CHECK ADD CONSTRAINT [FK_Category_Category] FOREIGN KEY ([fParentCategoryID]) REFERENCES [retail].[Category]([CategoryID])
    GO

    ALTER TABLE [retail].[Category] CHECK CONSTRAINT [FK_Category_Category]
    GO