Easy Question..!!

But, When you provide Alias Name, it should be "YearMonth" because CTE has Where Clause for YearMonth Column.

Thanks for sharing. This is very helpful and much needed feature.

Jeff Moden (2/14/2015)

---

Luis Cazares (2/14/2015)

---

Basically, you want to divide the proportion by the running total of proportion.

Quick question. How do you define the order? I think I know the answer...

Guys, Please Help with the problem , let me know if the problem is not well drafted Here.

CASE STATEMENT is an expression while ISNULL is a function.

In case provided by you, i will say it depends on the Data, if its some few hundred or thousand rows...

Easy Question.

2012 has SSDT,not BIDS

SELECT CODE, COUNT(Name) AS Name

FROM TABLENAME

GROUP BY CODE

Only ORDER BY Clause can guarantee the ordered display of records, index cannot guarantee ResultSet display.

Hi,

For the time being you may use this

DECLARE @table TABLE (colA INT)

INSERT INTO @table

SELECT 1

UNION ALL

SELECT -1

UNION ALL

SELECT 2

UNION ALL

SELECT -2

SELECT A.colA,-(B.colA) AS ColB FROM @table AS A

INNER JOIN...

Very Easy 🙂

Option 1 and 4 are identical.

🙂

Basic Interview question.

Easy ..!!

Easy One

Easy....