P
patryk78
hello , i have a table ARTICLES where are columns ID_ARTICLE and NAME, there
is also a CONTRACTOR table with ID_CONTRACTOR and many tables with prices
( group price, individual price, article price) and i found a function that
return resultset : netto_price and brutto_price, discount of article for one
contractor, function
getprice(id_article, id_contractor)
how to get prices for all articles (get all rows and put to function) for
one contractor lets say id_contractor is const = 1 using this function
there is somethin like dominant price which mean that ndividual price is
first, group price is second, and article price is last and there are
discounts too. i dont know how to write so huge slq select to get the right
price.......but the right price is returned by function getprice
i must get dominant price because that will be a order form system for
contractor based on database from sales program
maybe there is a solution using dataset or datareader ???????
i cant modify structure of that database beacuse its not mine
Pat
is also a CONTRACTOR table with ID_CONTRACTOR and many tables with prices
( group price, individual price, article price) and i found a function that
return resultset : netto_price and brutto_price, discount of article for one
contractor, function
getprice(id_article, id_contractor)
how to get prices for all articles (get all rows and put to function) for
one contractor lets say id_contractor is const = 1 using this function
there is somethin like dominant price which mean that ndividual price is
first, group price is second, and article price is last and there are
discounts too. i dont know how to write so huge slq select to get the right
price.......but the right price is returned by function getprice
i must get dominant price because that will be a order form system for
contractor based on database from sales program
maybe there is a solution using dataset or datareader ???????
i cant modify structure of that database beacuse its not mine
Pat