Thanks it worked

Hi Gail,

One more question if I want multiple users to receive the email.how would I go about scripting it?

Thank you Gail!!:-D

Hi Koen Verbeeck

It worked changed my datatype to nvachar..thanks a lot.

Latin1_General_CI_AS

Thanks it worked..

Hi guys,

I'm have same issue:

Msg 468, Level 16, State 9, Procedure RPT_MTX_CDR_CostBreakdown_PerMsisdn, Line 142

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

I have the query...

I need my finmonth column to be generic that's why I'm not using it.I use CASE because I'm given dates to use for Finmonth.

DECLARE @startdate DATETIME,

@enddate VARCHAR(50),

@accountno...

Thanks I will implement the changes and let you know.By way in future i post the error message too.

Nope the data type is int???

Hi SSC-Insane,

What I have here is a DB sitting on SQL server 2000 and I'm currently using SQL server 2012.The design of the DB is so bad..you can work on...

Thanks mil got it:-D..

Thanks will in future,I did finish the join and put in alias but I'm getting two errors:1 next to alias h I the following error "An expression of non-Boolean type...

Hi guys I'm also getting the same error:This is my query please assist:

Select

a.ApplicantName

,a.ApplicationUniqueNumber

,a.MeetingDate as DateOfApproval

,a.ProjectSICDescription as Sector

,b.Description as Product

,a.Province

,a.Investment

,a.GrantAmount

,g.FIG

,dbo.fn_ProjectSize(c.TotalIncentive)as ProjectSize

,d.status

,dbo.fn_GetProjectJobsNew(e.id) as NewJobs

,dbo.fn_GetProjectJobsExisting(e.ID) as JobsExisting

,(f.BFemale +f.CFemale +...