While we are making things more complicated, you could...

I see what you did there 😉 😀

I asked Matt Masson about this...

CASEWHEN [Post Cost] IS NULL OR [Pre Cost] IS NULL

THEN 1

WHEN [Pre Cost] = 0 -- avoid divide by zero error

THEN 0

ELSE [Post Cost] / [Pre Cost]

END

I wonder if there are rainbow kilts?

At second sight another CASE is not needed necessarily, just another WHEN will suffice.

,CASEWHEN CAST(CAST(ROUND(((T0.LineTotal - T0.StockValue) / NULLIF(T0.StockValue, 0)) * 100, 2) AS DECIMAL(10,2)) AS VARCHAR(30)) = '0.00'

THEN 'N/A'

WHEN...

Which deployment model? How do you deploy?

The commented line should be preceded with a new CASE.

If you would have posted your code as regular text instead of a screenshot, I could have modified it 😉

In such critical situation you...

Method 1 seems more easy to set-up than method 2.

Is it a big data load?

sqlfriends (8/12/2014)

---

After we upgrade some of servers from SQL server 2008 to 2012, I found it is harder to use 2012 SSMS to restore database compared with 2008 SSMS.

Anyone else...

The SSISDB is the database that contains all the objects for the SSIS catalog. So yes, it is perfectly normal that this database is created.

I am not sure how this...

Great question, and a fine example of why sp_rename should be avoided.

ps_vbdev (8/12/2014)

---

Ive been reading a bit further into my kmibal book. in this scenario could the color and size be considered as degenerate dimension ie. not bother have them in...

GilaMonster (8/12/2014)

---

So three days after implementing replication, I have a pile or replication-related errors on my desk (cannot truncate table because it's replicated, lob size exceeds max replicated text size)

How...