Forum Replies Created

Viewing 15 posts - 1 through 15 (of 116 total)

  • RE: Query help please

    Correct how can I pass multiple values and get results

  • RE: Help urgent please

    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...

  • RE: Help urgent please

    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,...

  • RE: Help urgent please

    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...

  • RE: Help urgent please

    Yes you are correct

  • RE: round the value to the nearest

    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...

  • RE: round the value to the nearest

    thanks for the reply.

    Can make it as below

    34.000->34%

    40.000->40%

    35.000->35%

  • RE: Get the rows based on the current quarter

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

  • RE: SSRS Report slow

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

  • RE: Performance related question

    I am posting the query suggest me if any performance improvements can be made

    UPDATE DW.ProgramScores_T4_P

    SET

    SPI=null ...

  • RE: Query regarding Update the data using application

    Sorry, it's typo mistake from my side

    I have come up with this stored procedure to be binded with the application layer

    CREATE PROCEDURE UpdateDescription

    @ManualDescription VARCHAR(2000),

    @ProjectId INT

    AS

    BEGIN

    UPDATE [Core.Projects]

    SET ManualDescription= @ManualDescription

    WHERE ProjectId= @ProjectId

    END

    Correct...

  • RE: Query regarding Update the data using application

    This will be new update statement that will be binded. In my case

    UPDATE Projects Set Description = '(Should this be blank or what should i input) '

    WHERE ProjectId=@ProjectId

    First What i...

  • RE: Query regarding Update the data using application

    Sorry to disturb you guys. Regarding update

    UPDATE [YOURTABLE]

    SET Description1 = 'Your new description text'

    WHERE ContactID = @ContactID

    How can i bind this with the code. I am still confused with

    SET...

  • RE: Derived column question with ISNULL

    ISNULL( MiddleName)? FirstName + LastName:FirstName+MiddleName+LastName

    Got it

Viewing 15 posts - 1 through 15 (of 116 total)