Shawon Amos

ALTER TRIGGER trgAfterContractDeedFileURLUpdate ON  [Contract] FOR UPDATE AS begin     declare @BusinessUnit nvarchar(50); declare @newContractDeedUrl nvarchar(250); declare @oldContractDeedUrl nvarchar(250);     set @BusinessUnit = 'Insert To ContractDeedUrlHistory if Contract Deed URL is updated.' select @newContractDeedUrl = ContractDeedUrl from inserted; select @oldContractDeedUrl = ContractDeedUrl from deleted; if(@newContractDeedUrl <> @oldContractDeedUrl) begin insert into ContractDeedUrlHistory(ContractNo,ContractDate, OwnerID,ContractDeedUrl,Entry_By,Entry_Date) SELECT ContractNo,ContractDate, OwnerID,ContractDeedUrl,Entry_By,Entry_Date FROM deleted end ;       end

CREATE TRIGGER trgAfterContractDeedFileURLUpdate ON  [Contract] FOR UPDATE AS begin     declare @BusinessUnit nvarchar(50)     set @BusinessUnit = 'Insert To ContractDeedUrlHistory if Contract Deed URL is updated.'     insert into         ContractDeedUrlHistory(ContractNo,ContractDate, OwnerID,ContractDeedUrl,Entry_By,Entry_Date)     SELECT         ContractNo,ContractDate, OwnerID,ContractDeedUrl,Entry_By,Entry_Date     FROM         deleted       end

Right click-Report-Group Expert-Select Date field you want to group-select Options-In common tab in "The Section will be  printed" dropdown changes to for each week .

DatabaseConnector connector = new DatabaseConnector();             connector.OpenConnection();             try             {                 DataTable dt = new DataTable();                 SqlDataAdapter da = new SqlDataAdapter(queryString, connector.Connection);                 da.SelectCommand.CommandTimeout = 0;                 da.Fill(dt);                 return dt;             }             catch (SqlException ex)             {                 return null;                           }  ...

var query = (from u in _StyleSizeRepository.GetAll()                     join p in _buyCentralRepository.GetAll() on u.Barcode equals p.BarCode into gj                     from x in gj.DefaultIfEmpty()                     select new StyleSize()                     {                         Barcode = u.Barcode,                         sBarcode = u.sBarcode,                         BTID = u.BTID,                         BTName = u.BTName,                               ...