Grandparent, parent and child hierarchy SQL server or Bread Crumb

[@PicnicError]

Great explanation. I was able to take your example and move it to a Linq to SQL and then to an OData query. Thank you for taking the time to upload this tutorial.

[@techsapphire]

+PicnicError Thanks its great to know that lecture helped you. Check this lecture too and you will see you don't even need structural hierarchy to maintain hierarchies. And also share your feedback. Also please share my videos you like. kzbin.info/www/bejne/oaCsYWusbK2qmpo

[@jesiahtony6489]

you prolly dont give a shit but if you're stoned like me during the covid times you can watch pretty much all of the latest movies and series on InstaFlixxer. Have been binge watching with my brother for the last days :)

[@anthonyjudah472]

@Jesiah Tony Definitely, I have been watching on InstaFlixxer for years myself :)

[@Sonny0276]

Great Video. Thank you for posting.

[@techsapphire]

Thank you for your comment.

[@moazaslam453]

sir can we differentiate parents by some means

[@Owsryudie]

Hi Sir, I got a question. I have a table Category with recursive relationship (attributes: PK categoryname, FK Parentcategory) I want to fire a SQL Trigger for: One Parentcategory may have 4 childcategory's (categoryname). Do you have any idea how I can do this?

[@techsapphire]

Massives yes you can do and play around data.

[@techsapphire]

Massives send me sample data and expected output on my email. I will respond back you with solution by Monday.

[@Owsryudie]

Thank you, I'm sending you a mail

[@Owsryudie]

I sent the email, I hope I could explain the situation. Thanks!

[@Owsryudie]

I forgot to to write in my example that Test1 is inserted: 'Test1', null

[@cococnk388]

Hello sir, thanks for the video Can you further explain this line of code "CAST(id AS varbinary(MAX)) i am lost...

[@techsapphire]

kindly rephrase your question

[@gopinathrajamanickam9475]

how to derive parent child relationship in case of multiple parents . I am trying to form a object dependency matrix . so in case of views there are many base tables involved in forming the view so these base tables can be considered as parent for the view and this view will be used in another view definition.

[@techsapphire]

Please mail me you dataset and expected output you want. [e-mail]

[@neharaina7357]

Did you get solution for this ? trying to do similar thing.

[@nivas143srinivas]

Great work

[@techsapphire]

Thanks

[@pavandengle917]

Hii am getting error as invalid column name 'id' and the multipart identifier "h1.id' could not be found please help

[@techsapphire]

you are using same dataset?

[@pavandengle917]

I am creating view and the above issue is resolved but I am not able to get the data of level 3.. Using DTree table

[@Algedibarrios]

Thank you

[@techsapphire]

You're welcome

[@arvindmaurya2173]

Your speed is quite higher side..

[@76900aakhtar]

excellent!

[@mhmdhussein7739]

Hi I'd like to thank you for your efforts and I need your urgent help. I saw this tutorial and it was so close to the result that I excpect but I had difficult in writing the query to get the result i want it . I'm asking you to let me know your E-mail so i could send you the database to be more clear for you and hopfully to help me and I'd be so thankful to you

[@devloperuniversal845]

feel free to [e-mail]

[@vanustonintelligence6457]

hi sir, Grandparent, parent and child hierarchy videos very nice i got some ideas and can i get data from this site (www.icd10data.com/ICD10CM/Codes) like tree structure using same hierarchy structure help me please give some ideas sample table structure or queries

[@techsapphire]

Please contact me on skype kingconspiracy is my id. Will discuss there.

[@santamayengbam1430]

Bla bla ah ahm ah ahm

[@harbanskaur4240]

Too much confusion. Bad teacher

[@techsapphire]

Sorry to hear that

[@saktibiswal6445]

We can atleast appreciate the effort. If You could do better please go ahead and upload your video.