|
|
Feb
25
Written by:
Allen Berezovsky
2/25/2009 6:14 PM
A former colleague of mine called me the other day with a following problem. She needed to write some reports against a self referencing table. Her initial thought was that she needed to create a number of temp tables, and fill them with the data for each hierarchy level. Her problem also was that she had no idea how deep the hierarchy went. When she got tired of running all kinds of select statements to find out the depth of that hierarchy, she called me for advice. Here is the sample code that I sent her.
Feel free to run this against the AdventureWorks database, and check out the results. The HumanResources.Employee table has an EmployeeID column, and a ManagerID column that references the EmployeeID within the hierarchy. The only catch is, this will not work in SQL 2000 or below.
1: WITH CorpStructure(ManagerID,EmployeeID, Title, Level)
2: AS
3: (
4: SELECT Emp.ManagerID, Emp.EmployeeID, Emp.Title, 1 as Level
5: FROM HumanResources.Employee as Emp
6: WHERE ManagerID is NULL
7: UNION ALL
8: SELECT Emp.ManagerID, Emp.EmployeeID, Emp.Title, Corp.Level + 1
9: FROM HumanResources.Employee as Emp INNER JOIN CorpStructure as Corp
10: ON Emp.ManagerID = Corp.EmployeeID
11: )
12: SELECT ManagerID, EmployeeID, Title, Level
13: FROM CorpStructure
Tags:
105 comments so far...
Re: Hierarchy of a self referencing table
nice!
By John on
4/16/2009 9:38 PM
|
Re: Hierarchy of a self referencing table
Jouer casino remarquablement simple et convivial explication du complexe pour beaucoup de choses!
By aster on
1/15/2010 8:13 AM
|
Re: Hierarchy of a self referencing table
I have examined almost all the posts on your blogging resource and I would like to go on but I terribly want to sleep. It’s 4 a.m. Next day – new life. flash programming
By Leon on
2/5/2010 3:04 AM
|
Re: Hierarchy of a self referencing table
Astonishing! I am very glad that I dropped here today. I like your blog very much and I hope to read more of your writing as I think it is worth it!
flex chat
By James on
3/17/2010 2:41 AM
|
|
|
Re: Hierarchy of a self referencing table
Looking For discountchanel replica
Looking For discountchanel handbags
Looking For discountchanel
Beautifulgucci handbags for sale
Beautifulgucci for sale
The store online sells theBalenciaga bags
Balenciagafor sale
If you want to buylouis vuitton bag
If you want to buylouis vuitton
different kinds oflouis vuitton handbag for cheap
different kinds oflouis vuitton for cheap
louis vuitton bag
replica louis vuitton bag for Cheap Wholesalecheap
replica louis vuitton bag for for Cheap Wholesale
china Wholesale
replica louis vuitton
cheapreplica louis vuitton handbagsfor sale
chanel handbags
gucci handbags
louis vuitton shoesfor wholesale
cheap and nicegucci shoesfor sale
different kinds ofshoes
chanel bagsfor sale
chanel handbagsfor discount
large number discountchanel
By lv on
3/18/2010 10:29 PM
|
777777777777
[url=http://www.salelouboutin.com]christian louboutin[/url]
[url=http://www.buylouboutin.com]louboutin[/url]
[url=http://www.bestlouisvuitton.com]lv handbags[/url]
[url=http://www.sale-mbt.com]mbt shoes[/url]
[url=http://www.discount-christianlouboutin.com]christian louboutin[/url]
[url=http://www.sale-mbt.com/nike-shox-c-29.html]nike shoes[/url]
[url=http://www.sale-mbt.com/nike-shox-c-29.html]cheap nike shoes[/url]
[url=http://www.sale-mbt.com/nike-shox-c-29.html]discount nike shoes[/url]
[url=http://www.sale-mbt.com/nike-shox-c-29.html]nike shoes sale[/url]
[url=http://www.sale-mbt.com/moncler-women-c-19.html]moncler women[/url]
[url=http://www.sale-mbt.com/moncler-women-c-19.html]cheap moncler women[/url]
[url=http://www.sale-mbt.com/moncler-women-c-19.html]discount moncler women[/url]
[url=http://www.sale-mbt.com/moncler-women-c-19.html]moncler women sale[/url]
[url=http://www.sale-mbt.com/moncler-men-c-17.html]moncler men[/url]
[url=http://www.sale-mbt.com/moncler-men-c-17.html]cheap moncler men[/url]
[url=http://www.sale-mbt.com/moncler-men-c-17.html]discount moncler men[/url]
[url=http://www.sale-mbt.com/moncler-men-c-17.html]moncler men sale[/url]
[url=http://www.sale-mbt.com/moncler-kids-c-18.html]moncler kids[/url]
[url=http://www.sale-mbt.com/moncler-kids-c-18.html]cheap moncler kids[/url]
[url=http://www.sale-mbt.com/moncler-kids-c-18.html]discount moncler kids[/url]
[url=http://www.sale-mbt.com/moncler-kids-c-18.html]moncler kids sale[/url]
[url=http://www.sale-mbt.com/]cheap mbt shoes[/url]
[url=http://www.sale-mbt.com/]discount mbt shoes[/url]
By 33333333333 on
3/25/2010 5:57 PM
|
Re: Hierarchy of a self referencing table
By 33333333333 on
3/25/2010 6:09 PM
|
gucci shoes
lisa
Nike Air Force 1 Ones
Nike Air Jordan Shoes
Nike Shox
By gucci shoes on
4/7/2010 6:43 PM
|
hary This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball su
hary
This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball superstar Michael Jordan shoes:Air Jordan 3 III, Air Jordan 4 IV, By air-jordan on
4/12/2010 4:12 PM
|
hary This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball su
hary
This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball superstar Michael Jordan shoes:Air Jordan 3 III, Air Jordan 4 IV, By air-jordan on
4/12/2010 4:12 PM
|
hary This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball su
hary
This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball superstar Michael Jordan shoes:Air Jordan 3 III, Air Jordan 4 IV, By air-jordan on
4/12/2010 4:12 PM
|
hary This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball su
hary
This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball superstar Michael Jordan shoes:Air Jordan 3 III, Air Jordan 4 IV, By air-jordan on
4/12/2010 4:13 PM
|
110
April 2010 A grand finale wow cd keyended completely banal, aion cd keywith a scene, as wow time cardwe see them in every eve time cardhandball game a dozen times - aion time carda passing did not reach its xbox 360 live pointswow goldaddressee. The partisan crowd had wow goldprobably already begun to world of warcraft goldrejoice after 70 nail-biting wow power levelingwow time cardminutes on a Siebenmeterwerfen wow cdkeywow time cardas lions professional Olafur xbox live 12 month cardxbox 360 live pointsStefansson the ball over a few eve game cardguildwars cdkeyguild wars cd keymeters not zupasste call of duty 6 codepsn cardMr Uwe Gensheimer Playstation Network Cardmass effect 2 cdkeyfor possibly the last equalized mass effect 2 codessro goldthe extended playing time, silkroad online goldaion kinahaion powerlevelingbut a hamburger in the hands.wow goldwow goldThe Rhein-Neckar L?wen wow goldwow goldwow goldwaited consternation to a last chaos goldlastchaos goldreferee whistle in their favor, wow goldwow goldbut did not, it was very wow powerlevelingwow time carddifficult to say whether a foul had influenced playback or acceptance.
By bmx on
4/18/2010 9:59 PM
|
|
|
|
|
|
|
air-jordan
utopia
This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball superstar Michael Jordan shoes:Women Jordans ,Kids Jordans ,Air Jordan Fusions ,Jordan Fusion III ,Jordan Fusion IV ,the famous gucci shoes:Gucci Outlet Store ,Gucci Outlet Online ,Gucci outletin,Gucci Shoes For Men ,Discount Gucci Shoes,and the coach shoesCoach Belts ,Coach Jewelry ,Coach Bracelet ,Coach Necklace ,Coach Earrings ,MBT VOI ,MBT Sport,etc., in short, very grateful to the author provides us with this information.
By air-jordan on
4/25/2010 6:18 PM
|
air-jordan
utopia
This article is very good, describes some of the things I never know, there are many new things put in front of me, for example, a lot of valuable goods inside the Online Shop but others have no, there are several categories of shoes, a basketball superstar Michael Jordan shoes:Women Jordans ,Kids Jordans ,Air Jordan Fusions ,Jordan Fusion III ,Jordan Fusion IV ,the famous gucci shoes:Gucci Outlet Store ,Gucci Outlet Online ,Gucci outletin,Gucci Shoes For Men ,Discount Gucci Shoes,and the coach shoesCoach Belts ,Coach Jewelry ,Coach Bracelet ,Coach Necklace ,Coach Earrings ,MBT VOI ,MBT Sport,etc., in short, very grateful to the author provides us with this information.
By air-jordan on
4/25/2010 6:18 PM
|
Re: Hierarchy of a self referencing table
Very good article, thank you
casinos en ligne
By Maurice on
4/26/2010 6:33 AM
|
Re: Hierarchy of a self referencing table
Thank you for the information, it will surely help me a lot.
Cheers!!!
casino fr
By james lee on
4/26/2010 8:25 AM
|
Re: Hierarchy of a self referencing table
Do you knowkinah?if you play the online game,you will knowaion kinahis the game gold. In the game,if you had morebuy kinah,you will had a tall level. But if you wantaion gold,you can come here and spend a little money to boughtbuy aion kinah.
By siown on
5/2/2010 7:19 PM
|
http://www.dearwatches.com
watches replica
replica watches
replica Montblanc watches
By replica watches on
5/4/2010 5:58 PM
|
mbt shadow shoes
Everybody know mbt barabara black for Masai Barefoot Technology.The company that makes mbt maliza brown is Swiss Masai.This mbt chapa navy creates a natural, uneven walking surface and forces the body to use all the major and stabilsing muscle groups, thus training the whole body to move correctly.
By mbt shadow shoes on
5/9/2010 10:23 PM
|
Re: Hierarchy of a self referencing table
Do you knowAion Kinah?if you play the online game,you will knowAion Goldis the game gold. In the game,if you had morebuy Aion Gold,you will had a tall level. But if you wantbuy Aion Kinah,you can come here and spend a little money to boughtkinah.Quickly come here.
By siown on
5/10/2010 8:33 PM
|
|
|
Re: Hierarchy of a self referencing table
Hello everyone,welcome to our website,if you want to buy christian louboutin shoes,you can visit our website,there are have many Christian Louboutin Pumps,Christian Louboutin Sandals,Christian Louboutin SlingbacksandChristian Louboutin Boots.
The christian louboutin shoes sale is very good,Christian Louboutin Pumpsand Christian Louboutin Sandals are very nice,There are many styles of Christian Louboutin Slingbacks and Christian Louboutin Boots.
Customers of the christian louboutin shoes store are very high,this is a famous brand of Christian Louboutin Pumps,and Christian Louboutin Sandals buy are ver good,Christian Louboutin Slingbacks,Christian Louboutin Boots have good quality,thanks.
shredder
binding machine
By psot122 on
5/11/2010 12:20 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Hierarchy of a self referencing table
Birkenstock is the well-known German footwear brand. Birkenstock shoes, Birkenstock sandals and Birkenstock clogs all use environmentally-friendly process and proven craftsmanship, additionally, their unique design encourages overall human health.Representative products: Birkenstock Gizeh, Arizona and Boston clog,ect. Birkenstocks are crazily popular.
By discount birkenstock on
5/18/2010 10:49 PM
|
|
|
Re: Hierarchy of a self referencing table
What is mbt? Mbt shoes are one kind of fitness shoes. MBT discount season ,get one for walking,MBT Chapa is hot now
By mbt shoes on
5/24/2010 6:24 PM
|
Re: Hierarchy of a self referencing table
“blade soul online” is very popular. Recently my friend and I always play it. And it is my favorite game blade soul gold is very useful. As soon as you play this game, everquset 2 plat is necessary. I often use blade and soul gold to buy blade soul gold. My friends make money just through cheap blade soul gold, when they find someone want to sell their everquset 2 plat, they will buy cheap blade soul goldwith no hesitation.
By blade soul gold on
5/25/2010 9:50 PM
|
Re: Hierarchy of a self referencing table
rayban sunglasses is popular ,and ray ban wayfarer is the most famous brand with the super quality ,fashionable style ,competitively price.
rayban sunglasses, Harley-Davidson Motor and Zippo Lighter have already became the symbols of current American culture.
By rayban sunglasses on
5/26/2010 12:16 AM
|
|
|
Re: Hierarchy of a self referencing table
BEIJING, June 3(Xinhuanet) wow gold--2010 World Cup is coming! world of warcraft goldNational teams from 32 countries wow goldare ready for standing world of warcraft goldout to claim the title. Meanwhile, global soccer fans are eager for experiencing exciting moments and cheering for every goal of their favorite squads.
By make on
6/4/2010 12:23 AM
|
Re: Hierarchy of a self referencing table
PARIS, June 2 (Xinhua) -- wow goldThe men's singles third seed wow goldNovak Djokovic from Serbia wow goldand the women's singles top wow goldseed Serena Williams of the United States wow goldfailed to advance into the semifinals at the French Open on Wednesday.
Facing first time wow power levelingGrand Slam quarterfinalist wow cd keyJurgen Melzer, Djokovic took the first two setswow cd key easily in 6-3, 6-2, but lostcheap wow gold the following three to the 22nd seed cheap wow gold
Austrian in 6-2, 7-6 (3) and 6-4.
"I made a big mistake,cheap wow gold
you know, there. I made him wow gold kaufencome back into the match withwow gold my unforced errors, and then he wow goldcaught the momentum andworld of warcraft gold he was playing really well, world of warcraft goldespecially on his service games," wow power levelingsaid an extremely disappointed Djokovic.
"I'm very disappointed, wow power levelingobviously, to lose the match that I was in control of totally a set and a break. This is tennis, you know. This is Grand Slams. You always have to play up to the end, because these things happen, especially at this stage of tournament," said the 2008 Australian Open champion.
By make on
6/4/2010 12:23 AM
|
Re: Hierarchy of a self referencing table
I need to find a solution for the same task, found some articles, but still didn't choose which way to go...
May be these links might help you. If you find a good solution - please post it here. i'm not allowed to post more then 1 link - i will add some to next posts
pages de casinos virtuels
By bhavna on
6/4/2010 4:35 AM
|
Louis Vuitton handbags
I really like your blog very much and i hope you will continue this good work in the future as louis vuitton handbags well
By Louis Vuitton handbags on
6/6/2010 7:00 PM
|
Re: Hierarchy of a self referencing table
[URL=http://www.handbagdrop.com] coach purses [/URL]
By coach purses on
6/6/2010 11:32 PM
|
Re: Hierarchy of a self referencing table
coach purses
By coach purses on
6/6/2010 11:33 PM
|
Re: Hierarchy of a self referencing table
cheap handbags
cheap purses
coach purses
you are so kind , the picturese real nice , like it so much ...
By coach purses on
6/6/2010 11:34 PM
|
Re: Hierarchy of a self referencing table
true religion jeans
mens true religion jeans
the pictures very nice , , like the website ,,thank you for your advise ,
By true religion jeans on
6/6/2010 11:35 PM
|
thinksugg@hotmail.com
Ugg sale,classic cardy,ugg cardy boots,ugg classic boots,59-79 off all boots ugg knightsbridge sale from australia official site it comes in various styles and sizes for women.2010 spring/summer women's ugg sandals sale.when you put the ugg sandals on, you should thinks ugg australia.
By classic tall ugg boots on
6/8/2010 5:36 PM
|
uggglobal@hotmail.com
ugg global are original offical ugg boots online store, women's ugg sandals on sale, big discount UGG Brook Sandals,UGG Hazel Sandals,UGG Basil Sandals,all kind of ugg summer shoes,tall ugg boots chestnut can find on uggglobal.com.
100% sheepskin from offical ugg bailey button grey are cool in this hot summer.
By cheap uggs knightsbridge black on
6/8/2010 5:40 PM
|
enjoyeugg@hotmail.com
ATTENTION,Please! Enjoy biggest SALE now!All classic uggs tall boots ,kinted ugg boots ONLY cost $60!Free shipping on all items,ugg flip flops tasmina big discount, wow!Super Benefits!Time is limited,Ordering uggs knightbridge black,only can get this bartgin from enjoyeugg.com!qucikly! enjoy big bargin now!
By women's ugg bailey button on
6/8/2010 5:41 PM
|
380721027@qq.com
Because this confusion is layered device allowed without checking them in this chaotic unconsciously in public.Their trademark chaos, because it is Ugg classic tall sale,even boots is made in China. layered device need to do something in the market and ensure fast prevent chaos ugg short classic name dispute with instead of products together.Many people now decided to join the New UGG Knightbridge black the new trend,and relevant to your thinking of buying one
By ugg short classic on
6/8/2010 5:41 PM
|
380721027@qq.com
A man you buy your uggs bailey button fancy , ensure proper like them. When they water-proofing agent, you may want to treat them with water-proofing agent results, especially if you are not sure they are true. Spend time and assessment materials, then go. Once you try ugg mini sale, are you sure with or without falling in love.r cheap is vast. Unfortunately not all what they offer is true. The buyer has to prey on trust and sell their products by their statements ugg cardy, but actually JiaLie amounts of site.Do you think Uggs purchase from all of the boots includes very common classic Cardy types of If button or classic or new berry Argyle braided style is very tricky. In all your money before the handover, it is worth doing research into the fact for business.
By uggs bailey button fancy on
6/8/2010 5:42 PM
|
|
|
|
|
Re: Hierarchy of a self referencing table
air yeezy release date
nike air jordan flight 45
jordan ol school
jordan pro classics
By coogi jeans on
6/14/2010 12:22 AM
|
|
|
|
|
Re: Hierarchy of a self referencing table
hello,we are sale Official Christian Louboutin Slingbacks,if you want and ,you can contact us,and the Christian Louboutin Bootsis every cheap,Wholesale Christian Louboutin Bootsstore on sale,China Christian Louboutin Boots and Discount Christian Louboutin Boots,thanks.If you want to Cheap Christian Louboutin Boots,Authentic Christian Louboutin Boots,you must look at the Replica Christian Louboutin Boots,Youth Christian Louboutin Boots,Official Christian Louboutin Boots, andThese have good quality,thanks.
By daxue001 on
6/16/2010 5:02 PM
|
|
|
[url=http://www.unchristianlouboutin.com]christian louboutin[/url] [url=http://www.unchristianlouboutin.com]louboutin[/url] [url=http://www.unchristianlouboutin.com]christian louboutin shoes[/url] [url=http://www.unchristianlouboutin.com]christian loubout
[url=http://www.unchristianlouboutin.com]christian louboutin[/url]
[url=http://www.unchristianlouboutin.com]louboutin[/url]
[url=http://www.unchristianlouboutin.com]christian louboutin shoes[/url]
[url=http://www.unchristianlouboutin.com]christian louboutin sale[/url]
[url=http://www.unchristianlouboutin.com]christian louboutin discount[/url]
[url=http://www.louboutinshoesbox.com]christian louboutin[/url]
[url=http://www.louboutinshoesbox.com]louboutin[/url]
[url=http://www.louboutinshoesbox.com]louboutin shoes[/url]
[url=http://www.louboutinshoesbox.com]louboutin sale[/url]
[url=http://www.louboutinshoesbox.com]christian louboutin discount[/url]
[url=http://www.fivefingersonsale.com]Vibram FiveFingers[/url]
[url=http://www.fivefingersonsale.com]Vibram Five Fingers[/url]
[url=http://www.fivefingersonsale.com]FiveFingers[/url]
[url=http://www.fivefingersonsale.com]Five Fingers[/url]
[url=http://www.fivefingersonsale.com]Five Finger shoes[/url]
[url=http://www.jimmychoos.me]jimmy choo sale[/url]
[url=http://www.jimmychoos.me]jimmy choo[/url]
[url=http://www.jimmychoos.me]jimmy choo shoes[/url]
[url=http://www.jimmychoos.me]jimmy choo pumps[/url]
[url=http://www.jimmychoos.me]jimmy choo discount[/url]
[url=http://www.herveleger.bz]herve leger[/url]
[url=http://www.herveleger.bz]herve leger clothing[/url]
[url=http://www.herveleger.bz]herve leger dress[/url]
[url=http://www.herveleger.bz]herve leger wedding dress[/url]
[url=http://www.herveleger.bz]herve leger dress sale[/url]
[url=http://www.manoloblahniks.me]manolo blahnik[/url]
[url=http://www.manoloblahniks.me]manolo blahnik shoes[/url]
[url=http://www.manoloblahniks.me]manolo blahnik discount[/url]
[url=http://www.manoloblahniks.me]manolo blahnik sale[/url]
[url=http://www.manoloblahniks.me]manolo blahnik ebay[/url]
[url=http://www.canadagooses.com]canada goose[/url]
[url=http://www.canadagooses.com]canada goose sale[/url]
[url=http://www.canadagooses.com]canada goose coats[/url]
[url=http://www.canadagooses.com]canada goose jackets[/url]
[url=http://www.canadagooses.com]canada goose outerwear[/url]
[url=http://www.ourshoesbox.com/christian-louboutin-c-22.html]christian louboutin[/url]
[url=http://www.ourshoesbox.com/australia-c-28.html]UGG Boots[/url]
[url=http://www.ourshoesbox.com/chanel-c-45.html]chanel[/url]
[url=http://www.ourshoesbox.com/herve-leger-c-53.html]herve leger[/url]
[url=http://www.ourshoesbox.com/vibram-five-fingers-c-52.html]vibram five fingers[/url]
[url=http://www.canadagooses.com/canada-goose-parka-c-1.html]canada goose parka[/url]
[url=http://www.canadagooses.com/moncler-jackets-c-7.html]moncler jackets[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-boots-c-65.html]christian louboutin boots[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-pumps-c-67.html]christian louboutin pumps[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-sandals-c-66.html]christian louboutin sandals[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-evening-c-22.html]christian louboutin evening[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-wedding-c-77.html]christian louboutin wedding[/url]
[url=http://www.louboutinshoesbox.com/manolo-blahnik-shoes-c-73.html]manolo blahnik shoes[/url]
[url=http://www.louboutinshoesbox.com/manolo-blahnik-boots-c-78.html]manolo blahnik boots[/url]
[url=http://www.louboutinshoesbox.com/manolo-blahnik-wedding-c-79.html]manolo blahnik wedding[/url]
[url=http://www.louboutinshoesbox.com/tory-burch-c-75.html]tory burch[/url]
[url=http://www.louboutinshoesbox.com/alexander-mcqueen-c-71.html]alexander mcqueen[/url]
[url=http://www.louboutinshoesbox.com/chanel-c-76.html]chanel[/url]
[url=http://www.louboutinshoesbox.com/giuseppe-zanotti-c-72.html]giuseppe zanotti[/url]
[url=http://www.louboutinshoesbox.com/jimmy-choo-c-74.html]jimmy choo[/url]
[url=http://www.louboutinshoesbox.com/salvatore-ferragamo-c-70.html]salvatore ferragamo[/url]
[url=http://www.louboutinshoesbox.com/yves-saint-laurent-c-69.html]yves saint laurent[/url]
[url=http://www.louboutinshoesbox.com/vibram-five-fingers-c-80.html]vibram five fingers[/url]
[url=http://www.louboutinshoesbox.com/miu-miu-c-81.html]miu miu[/url]
[url=http://www.louboutinshoesbox.com/chloe-c-82.html]chloe[/url]
[url=http://www.louboutinshoesbox.com/rene-caovilla-c-83.html]rene caovilla[/url]
[url=http://www.louboutinshoesbox.com/lanvin-shoes-c-84.html]lanvin shoes[/url]
[url=http://www.fivefingersonsale.com/vibramfivefingerskso-c-65.html]vibram five fingers kso[/url]
[url=http://www.fivefingersonsale.com/vibramfivefingersclassic-c-67.html]vibram five fingers classic[/url]
[url=http://www.fivefingersonsale.com/vibramfivefingerssprint-c-66.html]vibram five fingers sprint[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-boots-c-65.html]christian louboutin boots[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-pumps-c-67.html]christian louboutin pumps[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-sandals-c-66.html]christian louboutin sandals[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-evening-c-22.html]christian louboutin evening[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-wedding-c-77.html]christian louboutin wedding[/url]
[url=http://www.unchristianlouboutin.com/manolo-blahnik-shoes-c-73.html]manolo blahnik shoes[/url]
[url=http://www.unchristianlouboutin.com/manolo-blahnik-boots-c-78.html]manolo blahnik boots[/url]
[url=http://www.unchristianlouboutin.com/manolo-blahnik-wedding-c-79.html]manolo blahnik wedding[/url]
[url=http://www.unchristianlouboutin.com/tory-burch-c-75.html]tory burch[/url]
[url=http://www.unchristianlouboutin.com/alexander-mcqueen-c-71.html]alexander mcqueen[/url]
[url=http://www.unchristianlouboutin.com/chanel-c-76.html]chanel[/url]
[url=http://www.unchristianlouboutin.com/giuseppe-zanotti-c-72.html]giuseppe zanotti[/url]
[url=http://www.unchristianlouboutin.com/jimmy-choo-c-74.html]jimmy choo[/url]
[url=http://www.unchristianlouboutin.com/salvatore-ferragamo-c-70.html]salvatore ferragamo[/url]
[url=http://www.unchristianlouboutin.com/yves-saint-laurent-c-69.html]yves saint laurent[/url]
[url=http://www.unchristianlouboutin.com/vibram-five-fingers-c-80.html]vibram five fingers[/url]
[url=http://www.unchristianlouboutin.com/miu-miu-c-81.html]miu miu[/url]
[url=http://www.unchristianlouboutin.com/chloe-c-82.html]chloe[/url]a[url=http://www.unchristianlouboutin.com]christian louboutin[/url]
[url=http://www.unchristianlouboutin.com]louboutin[/url]
[url=http://www.unchristianlouboutin.com]christian louboutin shoes[/url]
[url=http://www.unchristianlouboutin.com]christian louboutin sale[/url]
[url=http://www.unchristianlouboutin.com]christian louboutin discount[/url]
[url=http://www.louboutinshoesbox.com]christian louboutin[/url]
[url=http://www.louboutinshoesbox.com]louboutin[/url]
[url=http://www.louboutinshoesbox.com]louboutin shoes[/url]
[url=http://www.louboutinshoesbox.com]louboutin sale[/url]
[url=http://www.louboutinshoesbox.com]christian louboutin discount[/url]
[url=http://www.fivefingersonsale.com]Vibram FiveFingers[/url]
[url=http://www.fivefingersonsale.com]Vibram Five Fingers[/url]
[url=http://www.fivefingersonsale.com]FiveFingers[/url]
[url=http://www.fivefingersonsale.com]Five Fingers[/url]
[url=http://www.fivefingersonsale.com]Five Finger shoes[/url]
[url=http://www.jimmychoos.me]jimmy choo sale[/url]
[url=http://www.jimmychoos.me]jimmy choo[/url]
[url=http://www.jimmychoos.me]jimmy choo shoes[/url]
[url=http://www.jimmychoos.me]jimmy choo pumps[/url]
[url=http://www.jimmychoos.me]jimmy choo discount[/url]
[url=http://www.herveleger.bz]herve leger[/url]
[url=http://www.herveleger.bz]herve leger clothing[/url]
[url=http://www.herveleger.bz]herve leger dress[/url]
[url=http://www.herveleger.bz]herve leger wedding dress[/url]
[url=http://www.herveleger.bz]herve leger dress sale[/url]
[url=http://www.manoloblahniks.me]manolo blahnik[/url]
[url=http://www.manoloblahniks.me]manolo blahnik shoes[/url]
[url=http://www.manoloblahniks.me]manolo blahnik discount[/url]
[url=http://www.manoloblahniks.me]manolo blahnik sale[/url]
[url=http://www.manoloblahniks.me]manolo blahnik ebay[/url]
[url=http://www.canadagooses.com]canada goose[/url]
[url=http://www.canadagooses.com]canada goose sale[/url]
[url=http://www.canadagooses.com]canada goose coats[/url]
[url=http://www.canadagooses.com]canada goose jackets[/url]
[url=http://www.canadagooses.com]canada goose outerwear[/url]
[url=http://www.ourshoesbox.com/christian-louboutin-c-22.html]christian louboutin[/url]
[url=http://www.ourshoesbox.com/australia-c-28.html]UGG Boots[/url]
[url=http://www.ourshoesbox.com/chanel-c-45.html]chanel[/url]
[url=http://www.ourshoesbox.com/herve-leger-c-53.html]herve leger[/url]
[url=http://www.ourshoesbox.com/vibram-five-fingers-c-52.html]vibram five fingers[/url]
[url=http://www.canadagooses.com/canada-goose-parka-c-1.html]canada goose parka[/url]
[url=http://www.canadagooses.com/moncler-jackets-c-7.html]moncler jackets[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-boots-c-65.html]christian louboutin boots[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-pumps-c-67.html]christian louboutin pumps[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-sandals-c-66.html]christian louboutin sandals[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-evening-c-22.html]christian louboutin evening[/url]
[url=http://www.louboutinshoesbox.com/christian-louboutin-wedding-c-77.html]christian louboutin wedding[/url]
[url=http://www.louboutinshoesbox.com/manolo-blahnik-shoes-c-73.html]manolo blahnik shoes[/url]
[url=http://www.louboutinshoesbox.com/manolo-blahnik-boots-c-78.html]manolo blahnik boots[/url]
[url=http://www.louboutinshoesbox.com/manolo-blahnik-wedding-c-79.html]manolo blahnik wedding[/url]
[url=http://www.louboutinshoesbox.com/tory-burch-c-75.html]tory burch[/url]
[url=http://www.louboutinshoesbox.com/alexander-mcqueen-c-71.html]alexander mcqueen[/url]
[url=http://www.louboutinshoesbox.com/chanel-c-76.html]chanel[/url]
[url=http://www.louboutinshoesbox.com/giuseppe-zanotti-c-72.html]giuseppe zanotti[/url]
[url=http://www.louboutinshoesbox.com/jimmy-choo-c-74.html]jimmy choo[/url]
[url=http://www.louboutinshoesbox.com/salvatore-ferragamo-c-70.html]salvatore ferragamo[/url]
[url=http://www.louboutinshoesbox.com/yves-saint-laurent-c-69.html]yves saint laurent[/url]
[url=http://www.louboutinshoesbox.com/vibram-five-fingers-c-80.html]vibram five fingers[/url]
[url=http://www.louboutinshoesbox.com/miu-miu-c-81.html]miu miu[/url]
[url=http://www.louboutinshoesbox.com/chloe-c-82.html]chloe[/url]
[url=http://www.louboutinshoesbox.com/rene-caovilla-c-83.html]rene caovilla[/url]
[url=http://www.louboutinshoesbox.com/lanvin-shoes-c-84.html]lanvin shoes[/url]
[url=http://www.fivefingersonsale.com/vibramfivefingerskso-c-65.html]vibram five fingers kso[/url]
[url=http://www.fivefingersonsale.com/vibramfivefingersclassic-c-67.html]vibram five fingers classic[/url]
[url=http://www.fivefingersonsale.com/vibramfivefingerssprint-c-66.html]vibram five fingers sprint[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-boots-c-65.html]christian louboutin boots[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-pumps-c-67.html]christian louboutin pumps[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-sandals-c-66.html]christian louboutin sandals[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-evening-c-22.html]christian louboutin evening[/url]
[url=http://www.unchristianlouboutin.com/christian-louboutin-wedding-c-77.html]christian louboutin wedding[/url]
[url=http://www.unchristianlouboutin.com/manolo-blahnik-shoes-c-73.html]manolo blahnik shoes[/url]
[url=http://www.unchristianlouboutin.com/manolo-blahnik-boots-c-78.html]manolo blahnik boots[/url]
[url=http://www.unchristianlouboutin.com/manolo-blahnik-wedding-c-79.html]manolo blahnik wedding[/url]
[url=http://www.unchristianlouboutin.com/tory-burch-c-75.html]tory burch[/url]
[url=http://www.unchristianlouboutin.com/alexander-mcqueen-c-71.html]alexander mcqueen[/url]
[url=http://www.unchristianlouboutin.com/chanel-c-76.html]chanel[/url]
[url=http://www.unchristianlouboutin.com/giuseppe-zanotti-c-72.html]giuseppe zanotti[/url]
[url=http://www.unchristianlouboutin.com/jimmy-choo-c-74.html]jimmy choo[/url]
[url=http://www.unchristianlouboutin.com/salvatore-ferragamo-c-70.html]salvatore ferragamo[/url]
[url=http://www.unchristianlouboutin.com/yves-saint-laurent-c-69.html]yves saint laurent[/url]
[url=http://www.unchristianlouboutin.com/vibram-five-fingers-c-80.html]vibram five fingers[/url]
[url=http://www.unchristianlouboutin.com/miu-miu-c-81.html]miu miu[/url]
[url=http://www.unchristianlouboutin.com/chloe-c-82.html]chloe[/url]
[url=http://www.unchristianlouboutin.com/lanvin-shoes-c-84.html]lanvin shoes[/url]
[url=http://www.unchristianlouboutin.com/lanvin-shoes-c-84.html]lanvin shoes[/url]
By christian louboutin on
6/22/2010 6:46 PM
|
|
|
Re: Hierarchy of a self referencing table
Are you looking for the perfect shoes ? Come to our [url=http://www.brandshoes2trade.com]brand shoes[/url] store
which you can find most kinds of fashion sale with low price but the best quality, including
[url=http://www.brandshoes2trade.com/mens-shoes-k-swiss-mens-shoes-c-2_10/]K Swiss Shoes[/url]
[url=http://www.brandshoes2trade.com/mens-shoes-radii-mens-footwear-c-2_17/] Radii shoes[/url]
[url=http://www.brandshoes2trade.com/vibram-fivefingers-kso-c-221/] fivefingers kso[/url]
[url=http://www.brandshoes2trade.com/mens-shoes-gourmet-mens-shoes-c-2_15/] Gourmet Shoes[/url]
[url=http://www.brandshoes2trade.com/mens-shoes-nike-mens-shoes-c-2_4/]nike runing shoes [/url]
[url=http://www.brandshoes2trade.com/puma-first-round-s-mixid565-p-376/]Puma First Round S Mix[/url]
[url=http://www.brandshoes2trade.com/puma-mens-shoes-puma-mens-first-round-c-2_8_112/] Puma First Round[/url]
[url=http://www.brandshoes2trade.com/big-kids-shoes-air-jordans-shoesbig-kids-c-1_27/] Air Jordans Shoes(Big Kids)[/url]
[url=http://www.brandshoes2trade.com/nike-blazer-mid-big-kids-09-p-144/]K Swiss Big Kids Shoes [/url]
[url=http://www.brandshoes2trade.com/lovers-style-shoes-c-184/]Lovers Style Shoes [/url]
[url=http://www.brandshoes2trade.com/mens-shoes-gourmet-mens-shoes-c-2_15/]Gourmet Men's Shoes[/url]
[url=http://www.brandshoes2trade.com/gourmet-dieciid543-p-408/]Gourmet Dieci[/url]
[url=http://www.brandshoes2trade.com/mens-shoes-mens-pf-flyers-shoes-c-2_16/]Men's PF Flyers Shoes [/url]
[url=http://www.brandshoes2trade.com/nike-mens-sandals-c-210/]Nike Men's Sandals 2010 Style [/url]
[url=http://www.brandshoes2trade.com/nike-mens-sandals-nike-mens-acg-sandals-c-210_211/]Nike Men's ACG Sandals [/url]
[url=http://www.brandshoes2trade.com/nike-terminator-low-premium2id500-p-242/]Nike Terminator Low Premium[/url]
[url=http://www.brandshoes2trade.com/nike-zoom-soldier-33id420-p-264/]Nike Zoom Soldier 3[/url]
[url=http://www.brandshoes2trade.com/nike-womens-blazer-shoes-low13-p-712/]Nike Women's Blazer Shoes[/url]
[url=http://www.brandshoes2trade.com/mens-shoes-radii-mens-footwear-c-2_17/]radii shoes[/url]
[url=http://www.brandshoes2trade.com/air-jordan-flight-45-high-big-kids-style-384520164-p-115/]air jordan flight 45[/url]
[url=http://www.brandshoes2trade.com/nike-basketball-sport-mens-shoes-nike-zoom-kobe-c-2_4_38_147/]Nike Zoom Kobe [/url]
[url=http://www.brandshoes2trade.com/nike-basketball-sport-mens-shoes-nike-lebron-c-2_4_38_146/]Nike Lebron[/url]
[url=http://www.brandshoes2trade.com/mens-shoes-puma-mens-shoes-c-2_8/]puma shoes[/url]
[url=http://www.brandshoes2trade.com/mens-shoes-clae-mens-shoes-c-2_18/]clae casual shoes [/url]
[url=http://www.brandshoes2trade.com/nike-mens-shoes-nike-basketball-sport-mens-sho-c-2_4_38/]Nike Basketball Shoes [/url]
[url=http://www.brandshoes2trade.com/nike-mens-shoes-nike-air-force-1-mens-shoes-c-2_4_33/]Nike Air Force 1 Shoes[/url]
[url=http://www.brandshoes2trade.com/nike-air-max-mens-shoes-nike-air-max-1-c-2_4_35_135/]Nike Air Max shoes[/url]
[url=http://www.brandshoes2trade.com/nike-air-max-mens-shoes-nike-air-max-1-c-2_4_35_135/]Nike Air Max 1[/url]
[url=http://www.brandshoes2trade.com/nike-air-max-mens-shoes-nike-air-max-2003-c-2_4_35_196/]Nike Air Max 2003[/url]
[url=http://www.brandshoes2trade.com/nike-air-max-mens-shoes-nike-air-max-90-c-2_4_35_134/]Nike Air Max 90[/url]
[url=http://www.brandshoes2trade.com/nike-air-max-mens-shoes-nike-air-max-95-c-2_4_35_133/]Nike Air Max 95[/url]
[url=http://www.brandshoes2trade.com/nike-air-max-mens-shoes-nike-air-max-classic-bw-c-2_4_35_199/]Nike Air Max Classic BW[/url]
[url=http://www.brandshoes2trade.com/nike-air-max-mens-shoes-nike-air-max-tailwind-c-2_4_35_188/]Nike Air Max Tailwind[/url]
[url=http://www.brandshoes2trade.com/nike-air-max-mens-shoes-nike-air-max-wright-c-2_4_35_136/]Nike Air Max Wright[/url]
[url=http://www.brandshoes2trade.com/nike-air-max-mens-shoes-nike-air-structure-triax-91-c-2_4_35_198/]Nike Air Structure triax 91[/url]
If you are a male,[url=http://www.brandshoes2trade.com/mens-shoes-supra-mens-shoes-c-2_13/]Supra Men's Shoes [/url] may fit for you.
Everyone knows that supra shoes uk is the world-famous, an important factor is that [url=http://www.brandshoes2trade.com/supra-mens-shoes-supra-skytop-c-2_13_215/]Supra SkyTop[/url] and [url=http://www.brandshoes2trade.com/supra-mens-shoes-supra-tk-society-c-2_13_214/]Supra TK Society[/url] are so cool and comfortable.
You can see supra shoes online everywhere. But our is best.
We also have[url=http://www.brandshoes2trade.com/big-kids-shoes-air-jordans-shoesbig-kids-c-1_27/]Air Jordans Shoes(Big Kids)[/url] and
[url=http://www.brandshoes2trade.com/nike-mens-shoes-nike-zvezdochka-mens-shoes-c-2_4_225/]Nike Zvezdochka Shoes[/url].
Choose one before sale out, they are easy to match your clothes.
By asdf on
6/23/2010 7:01 PM
|
|
|
Re: Hierarchy of a self referencing table
10628021737PMMetin2 yang | Metin2 gold |
By dfsfgd rg on
6/27/2010 10:17 PM
|
Re: Hierarchy of a self referencing table
What do people think about mbt shoes?
With the development of the world economy, there are some kind shoes like air jordan shoes and chiristian louboutin are world legendary on tide souk. Just say mbt trainers shoes, people all over the world are more and more interested in them since 1996. And more and more people own their own cheap Air Jordan shoes.
What do people think about coach handbags? Different people have different opinions.
christian louboutin shoes look like a symbole of elegant and grace, however the gucci handbags could make you more charming and sensible.
By mbt shoes on
6/28/2010 7:03 PM
|
business
Have you ever heard five finger vibram shoes?they were seen everywhere, for example,hiding,climbing hills,travelling....do u want to enjoy yourself?yes,pls follow me to find your love!vibram five fingers,vibram,five fingers,vibram five,vibram five fingers classic,five fingers vibram,vibram shoes,vibram shoe,vibram five fingers flow,vibram fivefinger,vibram kso,fivefingers kso,Vibram Five Fingers Sprint,sheepskin boot,slippers boots,classic tall chestnut,ugg australia sale,sheep skin boots,ugg boats,celtic sheepskin company,sheepskin footwear,ugg australia online,australia classic tall,women's classic cardy,genuine uggboots,ugg 5815,ugg 5825,ugg 5803,ugg 5819,ugg 5833,ugg 5879,ugg 5854,ugg 5359,ugg 5325,ugg 5225,designer handbags sale,cheap designer bags,designer leather handbags,purses and handbags wholesale,fashion handbags wholesale,discount designer bags,handbags designers,cheap handbags wholesale,authentic designer handbag,wholesale designer bags,sell handbags,discounted designer handbags,discount designer handbag,designer handbag sale,designer handbags and purses,discount designer purses,buy designer handbags,leather handbags discount,wholesale hand bags,discount authentic designer handbags,designer handbags online,cheapest handbags,discount fendi handbags,designer handbags for sale,real designer handbags,wholesale authentic designer handbags,cucci handbags,wallet handbags,buy cheap handbags.this will keep you comfort and leasure.
By jolin on
7/1/2010 12:05 AM
|
cheap shoes
recently, i found an excellent online store,vibram five fingers,vibram,five fingers,vibram five,vibram five fingers classic,five fingers vibram,vibram shoes,vibram shoe,vibram five fingers flow,vibram fivefinger,vibram kso,fivefingers kso,Vibram Five Fingers Sprint,sheepskin boot,slippers boots,classic tall chestnut,ugg australia sale,sheep skin boots,ugg boats,celtic sheepskin company,sheepskin footwear,ugg australia online,australia classic tall,women's classic cardy,genuine uggboots,ugg 5815,ugg 5825,ugg 5803,ugg 5819,ugg 5833,ugg 5879,ugg 5854,ugg 5359,ugg 5325,ugg 5225,designer handbags sale,cheap designer bags,designer leather handbags,purses and handbags wholesale,fashion handbags wholesale,discount designer bags,handbags designers,cheap handbags wholesale,authentic designer handbag,wholesale designer bags,sell handbags,discounted designer handbags,discount designer handbag,designer handbag sale,designer handbags and purses,discount designer purses,buy designer handbags,leather handbags discount,wholesale hand bags,discount authentic designer handbags,designer handbags online,cheapest handbags,discount fendi handbags,designer handbags for sale,real designer handbags,wholesale authentic designer handbags,cucci handbags,wallet handbags,buy cheap handbags.pls feel free to contact with me!
By jolin on
7/1/2010 9:39 PM
|
|
|
|
|
nike shox
Nike Shox has driven the sale upsurge online, the cheap Nike Shox has large sum of customers base. We provide Nike shox running shoes that occupy the sports shoe field for a long time, for example, Nike Shox r4 and Nike Shox NZ. Womens Nike Shox is also very pervasive as more and more women like to go out for sports now. Nike shox on sale with lower cost and advantages of flexible reaction to the customers are appreciated by our clients. Shox NZ and Shox r4 are our featured products with the best sale performance this season. Mens Nike shox are all very classy with unique design and comfortable materials. The new arrival white Nike shox is especially for this summer. Nike Shox R4 Torch with torch pattern is very eye-catching and slap-up. In addition, we also provide kids Nike shox, which is the optimal choice for your children as the gift
By nike shox on
7/5/2010 5:32 PM
|
nike shox
Nike Shox has driven the sale upsurge online, the cheap Nike Shox has large sum of customers base. We provide Nike shox running shoes that occupy the sports shoe field for a long time, for example, Nike Shox r4 and Nike Shox NZ. Womens Nike Shox is also very pervasive as more and more women like to go out for sports now. Nike shox on sale with lower cost and advantages of flexible reaction to the customers are appreciated by our clients. Shox NZ and Shox r4 are our featured products with the best sale performance this season. Mens Nike shox are all very classy with unique design and comfortable materials. The new arrival white Nike shox is especially for this summer. Nike Shox R4 Torch with torch pattern is very eye-catching and slap-up. In addition, we also provide kids Nike shox, which is the optimal choice for your children as the gift
By nike shox on
7/5/2010 5:32 PM
|
vibram five finger
Had been thinking about Lindsey's new vibram fivefingers ever since she posted about them on this blog. When she first sent me a photo of these bizarre looking vibram five,I just laughed at their vibram fivefingers ridiculousness, thinking 'no way I'll ever put those things on my five finger feet!' But alas, once I saw them and read about them, I just couldn't stop thinking about them! I had to try them for myself. Last week I went to Blue | |