How do i create and add filters to the aspdnsf_RecentAdditions sproc ?


in MultiStore by (225 points)

1 Answer

0 votes
Yes, this is an old post, but here goes.

I think this post hasn't gotten a response because it will require a large amount of base development knowledge that is out of scope for a forum post.

If the following is unfamiliar a dev partner could help you out with this pretty easily.

- how to connect to a database

- how to use sql server management studio

- how to modify a SQL stored procedure.

- how to write SQL.


That being said, to filter products that have a ProductType of "blog", you would update the aspdnsf_RecentAdditions sproc with something like this:

WHERE p.ProductTypeID <> (SELECT ProductTypeID FROM ProductType WHERE ProductType.Name = 'blog')
by (780 points)