Rank: Member
Joined: 1/30/2008(UTC)
Posts: 215
|
Is there an easy way to find orphan products that are not assigned to categories? Is there an easy way to create a report that would do this? promomanagers
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Try this:
select ProductName, PC.CategoryId from bvc_Product P
left join dbo.bvc_ProductXCategory PC on P.bvin = PC.ProductId
where PC.CategoryId is null
order by categoryid |
|
|
|
|
|
|
Rank: Member
Joined: 1/30/2008(UTC)
Posts: 215
|
Corneliu, would I just run that as a query?
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Yes, run that in SQL and you get the product names that have no categories assigned to them.
Regards,
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 1/30/2008(UTC)
Posts: 215
|
Huge, works great and once again you are an awesome resource Corneliu.
Our orphan rate was under 2%, but that's 2% that had little chance of staying indexed.
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Thanks HPros,
I was thinking about asking for salary from BVC for offering support :) hehehe
Regads,
Corneliu. |
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.