dt_PRODCAT (Used to map multiple categories and products)
I am having trouble getting my head around the subcategories. With this structure it is possible to have an infinite number of category nestings, through the use of the PARENTCATEGORY_ID field that points back to the dt_CATEGORY table.
Can someone please provide me with code to create the ADO hierarchical recordset, and code to display it also please?
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…