I am very new to editing the sql query in an XML package in order to change the output. Below is the query to execute the aspdnsf_GetProducts Stored Procedure.
Can I edit this to sort the results by SKU number?
<sql>
<![CDATA[
exec dbo.aspdnsf_GetProducts
@categoryID = @CatID,
@sectionID = @SecID,
@manufacturerID = @ManID,
@distributorID = @DistID,
@genreID = @GenreID,
@vectorID = @VectorID,
@localeName = @locale,
@CustomerLevelID = @CustLevelID,
@affiliateID = @AffID,
@ProductTypeID = @ProdTypeID,
@ViewType = 1,
@pagenum = @pgnum,
@pagesize = null,
@StatsFirst = 0,
@publishedonly = 1,
@ExcludePacks = 0,
@ExcludeKits = 0,
@ExcludeSysProds = 0,
@InventoryFilter = @InvFilter,
@sortEntityName = "SKU",
@storeID = @StoreID,
@filterProduct = @FilterProduct
]]>
</sql>
Thanks,
J