got it thanks for the clarification . I should have observed i am sorting based on year and month.

thanks hguys

Have solved the issue made some security settings in SSMS. It worked. Thanks for your help

Thanks for the inputs I have resolved the deployment issue. Now  I am faced with another issue when I process the Cube  getting this error message

OLE DB error: OLE DB...

Got it resolved

ISNULL( MiddleName )? FirstName + " " + LastName :FirstName + " " + MiddleName + " " + LastNameISNULL( MiddleName )? FirstName + " " + LastName...

Awesome. It worked. Thank you Fonseca. appreciate that

Can this be achieved without using ranking function

Correct how can I pass multiple values and get results

I figured the problem. Now I have another problem that I need to figure

DECLARE@MGR_NAMENVARCHAR(100)='Okray, Lupe'

SELECT*FROM#QLOGIC

WHERECOUNTRYIN('US')ANDSEGMENTIN('HCLS')

AND[TSR_MGR_NAME]IN(@MGR_NAME)OR[EI_TSR_MGR_NAME]IN(@MGR_NAME)

It pulls all the rows related 'Okray, Lupe' ideally...

Please script as below

CREATE TABLE #QLOGIC

(

[ACCT_ID] NVARCHAR(255),

[COUNTRY] NVARCHAR(255),

[SEGMENT] VARCHAR(255),

[TSR_REP_NAME] NVARCHAR(100),

[TSR_REP_BADGE_NUM] NVARCHAR(255),

[TSR_MGR_NAME] NVARCHAR(100),

[TSR_MGR_BADGE_NUM] NVARCHAR(255),

[EI_TSR_REP_NAME] NVARCHAR(100),

[EI_TSR_REP_BADGE_NUM] NVARCHAR(255),

[EI_TSR_MGR_NAME] NVARCHAR(100),

[EI_TSR_MGR_BADGE_NUM] NVARCHAR(255)

)

INSERT INTO #QLOGIC

VALUES('727386973','US','US LI CORP CHANNELS','Jennings, Phillip','606600','Betts, Brian','21589','Soto, Andrea A','589171','Okray, Lupe','598284')

INSERT INTO #QLOGIC

VALUES('725395506','US','HCLS','Dallmeier,...

help request ideally rep_name data set should return only three records. It is pulling 5 records. It is pulling 3 records as tsr_rep_name and records as

ei_tsr_rep_name and in the rep_name...

Yes you are correct

LEFT(CAST(ROUND([Val],0,0) as nvarchar(10)),2) + '%' AS [val]

to get the results some like this

34.100 34.000 ->34%

39.800 40.000 ->40%

35.400 35.000 ->35%

But this does not holds good...

thanks for the reply.

Can make it as below

34.000->34%

40.000->40%

35.000->35%

guys I searched in Teradata forums I did not get any concrete answers. Any sql pundits can tell me how it can be done

need to check Report execution status in the executionlog3 table to nail it to the core.