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

UPDATE DW.ProgramScores_T4_P

SET

SPI=null ...

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

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

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

Nice Chris.

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

Got it

I have another requirement

i need to embed another data set to the existing what i you have proposed

SELECT COMPANY_SK,CUSTOMER_DESC,CUSTOMER_SHORT_DESC,OUTSTANDINGAMOUNTFORBILLING,OUTSTANDINGAMOUNTCASHRECEIVED,

OUTSTANDINGAMOUNTDEBT FROM (

SELECT first_select.Company_SK

, first_select.CUSTOMER_SHORT_DESC

...

Thanks a lot. It worked for me

Thanks guys all your input. Tuning of query is given to me in the morning, i have no idea about the query and database involved. Thank fully i went for...

please find the query as below

DECLARE @DrillSelected VARCHAR(100)

if @DrillSelected is null

begin

select D.BUSINESSDIVISION,

(SUM((nL.baseval)*CASE WHEN CURR.RATE IS NULL THEN 1 ELSE CURR.RATE END)) OUTSTANDINGAMOUNT

FROM

vw_fact_nltrans nl

INNER JOIN

VW_DIM_COMPANY C

ON nl.COMPANY_sk=C.COMPANY_sk

INNER JOIN DIVISIONMAPPING D

ON...

Have checked the Execution Log. It says the same thing. Apart from this any thing I can do to improve

please this is not job site please do not send. u r wasting people's time

Hey Steve sorry to bother you again . Please give me the query my brain has drained out if you could

Could you please specify. What more measure expression i have to come up. Please if you could help would be great

Another query

I have data type NUMBER(10) What i can use in Sql