Do you want to delete or insert or both?

You can tweak ur merge to perform all 3 operations in one statement. Please throw some more light on your requirement

Try this:

Create procedure Get_Dept_Details

(

@pCode nvarchar(10),

@pDesc nvarchar(50) output,

@pRemarks nvarchar(50) output

)

as

select @pDesc = description,@pRemarks = Remarks from dept where code = @pCode;

I just moved the columns to get assigned to the...

Isnt it straight forward UPDATE?

Update t1

set finalprice = price * 100

y'r welome 🙂

If u r using SQL 2008, use this:

SELECT * FROM #Destination;

BEGIN TRAN ;

MERGE #Destination TGT

USING #Staging SRC

ON TGT.Account = SRC.Account...

Desired result is same as the Destination table! :pinch:

Question is a paradox 😀

How about multiple REPLACEs?

select replace( replace( replace( replace( replace( replace (Numb, '.','') , '-','' ) , '/','') , ' ','') , ')','') , '(','')

from

(

...

You very well can, as long as the statement you are using after the THEN clause does not return more than 1 value (1 column 1 row)

atchristian, please have a look at the following article to follow the forum etiquettes : http://www.sqlservercentral.com/articles/Best+Practices/61537/.

We need to get more info on effectively give you an answer.

You requirement may...

I must also ask a question here. What should happen if there are 2 LocationIDs with same number of appearances for a particular OrgID ?

Not at all Cadavre! Awesome explanation! Thanks for that. Hope the...

Whooops.. MVJ beat me to it...

Try this:

SELECT DATES

, CrsApp2.DtAd WeekStart

, DATEADD(DD, 6, CrsApp2.DtAd) WeekEnd

FROM dt

CROSS APPLY ( SELECT DATEDIFF(WK,0,DATES) ) CrsApp...

Hello Anjali..

Can you be more specific on your ask? I see some anamolies. The query you provided wont work.

Here is the set-up. Play with it and give exactly how...

i am unclear with your requirement? what value u wnat to update the weekrange with?

Follow this post for Forum Etiquettes : Forum Etiquettes[/url]