Database

amit_logicon wrote:

VCode to differentiate in queries that it is Code of Vendor

amit_logicon wrote:

I have kept address of different entities in different table, i.e., Address of Vendors, Branches in respective tables

amit_logicon wrote:

I was asking for your review because I am having really great difficulties in creating queries.

SELECT A.* FROM ProductPriceHistory A
INNER JOIN (
  SELECT C.PCode, Min(C.EffectiveDate) AS EffectiveDate
  FROM ProductPriceHistory C
  WHERE C.EffectiveDate < MyPriceDate
  GROUP BY C.PCode
) B
ON B.PCode = A.Pcode
AND B.EffectiveDate = A.EffectiveDate
ORDER BY A.PCODE ;

select T1.Id, T2.Id,
   case
     when T1.Id is null then 'Record only exists in T2'
     when T2.Id is null then 'Record only exists in T1'
     when IsNull(T1.MyString, '') <> IsNull(T2.MyString, '') then 'MyString is different'
     when IsNull(T1.MyNumber, -999) <> IsNull(T2.MyNumber, -999) then MyNumberis different'
     --other when clauses to compare other columns
     else 'Records are the same'
   end
from T1
full outer join T2
on T2.Id = T1.Id

select Vendor.VCode,
   (select sum(SalesLine.Quantity) from SalesLine
   inner join SalesLine
     on SalesLine.SaleCode = Sale.SaleCode
   where Sale.VCode = Vendor.Vcode) as SumProductQty
   --other sub-selects go here
from Vendor
order by Vendor.VCode