Database

create table bkPhone
(
    phoneNo nvarchar(20),
    firstName nvarchar(20),
    lastName nvarchar(20)
)
GO

insert bkPhone values('0783313780','Brady','Kelly')
insert bkPhone values('0845319792','Mark','Smith')
insert bkPhone values('0834976958','Bill','Jones')
insert bkPhone values('0845319792','Mark','Smith')
insert bkPhone values('0828329792','Mickey','Mouse')
insert bkPhone values('0834976958','Bill','Jones')

alter table bkPhone add phoneId int identity

delete from bkPhone
where phoneId not in
(
    select min(phoneId)
    from bkPhone
    group by phoneNo,firstName,lastName
    having  count(*) >= 1
)

<br />
USE AuditDB<br />
go<br />
<br />
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Log]') AND type in (N'U'))<br />
DROP TABLE [dbo].[Log]<br />
<br />
CREATE TABLE [dbo].[Log] (<br />
    [Id] [bigint] IDENTITY (1, 1) NOT NULL,<br />
    [Date] [datetime] NOT NULL,<br />
    [Thread] [varchar] (255) NOT NULL,<br />
    [Level] [varchar] (50) NOT NULL,<br />
    [Logger] [varchar] (255) NOT NULL,<br />
    [Message] [varchar] (4000) NOT NULL,<br />
    [Exception] [varchar] (2000) NULL<br />
)<br />

set ANSI_NULLS ON
go
set QUOTED_IDENTIFIER ON
go

CREATE FUNCTION [dbo].[fcn_computecosts]
( @ProjectID int, @userID int, @startDate datetime, @enddate datetime, @quarter tinyint, 
@Cost money, @percent int, @totalDays int, @totalcost)

RETURNS @ComputeCosts TABLE
( ProjectID int, userID int, startDate datetime, enddate datetime, quarter tinyint, 
Cost money, percent int, totalDays int, totalcost)

AS
BEGIN
SELECT
 P.ProjectID, P.userID, P.startDate, P.enddate, C.quarter,P.Cost, P.percent,
COUNT(C.date) AS totalDays, ((percent/100)*totaldays*Cost*8) AS totalcost

FROM Project AS P INNER JOIN Calendar AS C ON Calendar.date >P.startDate AND Calendar.date <=
P.enddate
WHERE (C.isWeekday =1) AND (C.isHoliday=0)
GROUP BY P.ProjectID, P.userID, P.startDate, P.enddate, C.quarter,P.Cost, P.percent,
 totalDays,  totalcost
ORDER BY P.ProjectID
RETURN
END