Error: The type of column enq conflicts with the type of other columns specified in the UNPIVOT list
ALTER PROCEDURE [dbo].[AnnualAnalysisChart]
-- Add the parameters for the stored procedure here
@UserId int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
if @UserId = 0
Begin
IF OBJECT_ID('tempdb..#tempt') IS NOT NULL DROP TABLE #tempt
select SUM( cast (Target AS bigint)) as Tar,COUNT( cast (EnquiryId AS bigint)) as enq,count( cast(BookingId AS bigint )) as bkg into #tempt from tblUser u
inner join tblEnquiry e on u.UserId=e.UserId
inner join tblBooking b on u.UserId=b.UserID
WHERE DatePart(Year,(u.[CreatedOn]))=DatePart(Year, GETDATE())
AND DatePart(Year,(e.[CreatedOn]))=DatePart(Year, GETDATE())
AND DatePart(Year,(b.[CreatedOn]))=DatePart(Year, GETDATE())
select
Description,
value
from #tempt
unpivot
(
value
for Description in (Tar, enq, bkg)
) unpiv;
End
Else
BEGIN
IF OBJECT_ID('tempdb..#tempt2') IS NOT NULL DROP TABLE #tempt2
select Target,COUNT(EnquiryId) as enq,count(BookingId) as bkg into #tempt2 from tblUser u
inner join tblEnquiry e on u.UserId=e.UserId
inner join tblBooking b on u.UserId=b.UserID
WHERE u.UserId=@UserId
AND DatePart(Year,(u.[CreatedOn]))=DatePart(Year, GETDATE())
AND DatePart(Year,(e.[CreatedOn]))=DatePart(Year, GETDATE())
AND DatePart(Year,(b.[CreatedOn]))=DatePart(Year, GETDATE())
group by Target
select
Description,
value
from #tempt2
unpivot
(
value
for Description in (Target, enq, bkg)
) unpiv;
END
END