Al Zahia Inbound Campaign

select * from Inbound_Calllist_Zahia where CONVERT(VARCHAR(12), cast(DATE_OF_CALL as DATE), 101)=CONVERT(VARCHAR(12), GETDATE(), 101) and ISFOLLOWUP <> 'FollowUp' order by DATE_OF_CALL

Al Zahia

Survey Report(mm/dd/yyyy)
From	To

Total Report

Sr No.

URN

CUSTOMER_NAME

INBOUND_NUMBER

MOBILE

ALTERNATE_MOBILE

EMAIL

ADDRESS

NATIONALITY

DATE_OF_CALL

CALLSTATUS

TYPE_OF_PROPERTY

SOURCE

CHANNELTYPE

CHANNELNAME

DETAILS_OF_SOURCE

REASON

TYPE_OF_CALL

CUSTOMER_TYPE

USERID