Database

CREATE TRIGGER myTrigger<br />
ON myTable<br />
FOR INSERT <br />
AS<br />
  /* here check the count of rows and delete smaller id*/<br />
  BEGIN<br />
     DECLARE @count int;<br />
     SELECT @count = COUNT(*) FROM myTable<br />
     IF(@count>60)<br />
     BEGIN<br />
      DECLARE @first int;<br />
      SELECT @first = MIN(ID) FROM myTable<br />
      DELETE FROM myTable WHERE ID=@first<br />
     END<br />
  END<br />

ALTER TABLE MyTable<br />
ADD CONSTRAINT PK_KeyName primary key clustered (FieldName).

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it!

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 ;