IgorMi, you can use http://extras.sqlservercentral.com/prettifier/prettifier.aspx.

I tend not to. If I'm about to spend a few minutes reading and understanding a chunk of code, reformatting it easily becomes part of the...

Perfectly reasonable so long as this is homework. If not, then do it properly:

UPDATE Outlet.tblProductMaster SET

Product_Status = CASE

WHEN Seller_No = @strSellerNo1...

If you're wondering what the variables are for in the UPDATE, they collect some column values as they are before any updates have been performed:

DROP TABLE #EXPORTMAIN

CREATE TABLE #EXPORTMAIN (

ID...

Same statement rewritten as UPDATE FROM, with nonsense logic commented out:

-- Formatted

DECLARE @tempS AS nvarchar(150)

DECLARE @tempW AS nvarchar(50)

DECLARE @tempQ As nvarchar(5)

UPDATE e SET

@tempS = SKU1, --...

Formatted for readability:

-- Formatted

DECLARE @tempS AS nvarchar(150)

DECLARE @tempW AS nvarchar(50)

DECLARE @tempQ As nvarchar(5)

UPDATE dbo.EXPORTMAIN SET

@tempS = SKU1,

@tempW = WHSELOC1,

@tempQ = QTY1,

SKU1 = Case

When...

lianvh 89542 (1/23/2014)

---

Thank you for the feedback. I am sorry for expressing myself incorrectly. Business wanted the data on screen more precisely ordered. It was up to Dev and the...

lianvh 89542 (1/23/2014)

---

Thank you for the feedback. There was a business requirement for the concatenated clustered index . The rank over was then needed to order the rows more accurately...

The examples are fine but the author of the article clearly knows little about CTE's and slips on a...

Before considering esoteric wait stats and such, your code would benefit from an overhaul to bring your join syntax up to date. Your first query equates to this:

UPDATE pro SET...

kbhanu15 (1/22/2014)

---

HI Thanks for your reply but the given query is present in a view

i think it wont work in views?

view details:

create view Screen_RatingsData_ProbabilityOfDefault_vw

as

select...

kbhanu15 (1/22/2014)

---

HI ,

the below query taking 5 minutes time, i want to rewrite this query ?

query details :

select pd.companyId, asOfDate as scoreDate, Convert(numeric(38,10),pd.PDValue) * 100 as zscore

from pdDataMarketSignal_vw...

Like Gail, I don't think this expression is going to have much impact on performance. Maintainability is another story - updating n queries to account for product changes leaves you...

mickyT (1/21/2014)

---

Thanks Chris, I missed that I had messed up the result. I made some changes for performance to what...

Start by reducing the noise to see what's going on:

SELECT

x.YearMonth,

[DEPTH] = (

SELECT

SUM(b.DEPTH)

FROM HOLELOCATION b

CROSS...

abhas (1/21/2014)

---

Thanks All,

I am doing the same.

SELECT

ROW_NUMBER() OVER (PARTITION BY t.CustomerName ORDER BY t.DateAdded DESC) AS RowNumber

from tblCustomer. but it is giving 1,2,3.....RowNumber.

I want again repeat RowNumber to each...