Does increasing the length of your varchar to 19 solves the problem?

I was expecting that compression would be one of the answers.

I tested it on sqlfiddle.com and it worked...

I'm sure there's a commandment missing.

STUDY. You'll never finish to learn. There's always something else that you must learn and that's why studying is so important. When we're not moving...

Something like this?

SELECT 'Total' AS Dept,

SUM(CASE WHEN dept = 'A' THEN Total ELSE 0 END) AS A,

SUM(CASE WHEN dept = 'B' THEN Total ELSE 0 END) AS B,

...

Maybe something like this (you should read about sp_send_dbmail):

IF NOT EXISTS(

SELECT *

FROM RESTOREHISTORY

WHERE DESTINATION_DATABASE_NAME = 'intelligence'

...

Yes, I know. 😀

Thank you for sharing.

Are...

Sean Lange (9/18/2014)

---

waseemshaikh345 (9/18/2014)

---

Like for example lets say I Have 14 people who made payments to their account, I want to know in those 30 days of September how many...

Stefan Krzywicki (9/17/2014)

---

I know people who frequent this list will mention when they're looking for a new position. Does anyone happen to be looking for something in the Boston area...

Do I see some personal/professional growth in these words? I really hope so.

Do you need the space? You might need it in the future for DB growth so unless you really need it right now, you shouldn't try to release it. It...

Thank you for the feedback.

Now, something really important. Do you understand...

The simplest version I could think of.

declare @t table (Qty decimal(12,3),CF1 Decimal(12,3),CF2 Decimal(12,3),Flag TinyInt)

insert @t select 10,2,6,0

insert @t select 10,2,6,1

SELECT Qty* POWER(CF2/CF1, Flag)

FROM @t

EDIT: Unless someone proves me wrong, it...

You should read the discussion on this article. Of course, you must change the conditions a little bit for "C".

http://www.sqlservercentral.com/articles/T-SQL/88244/