Ed Wagner (9/14/2016)

---

Hugo Kornelis (9/14/2016)

---

Eirikur Eiriksson (9/14/2016)

---

Makes you wonder what the purpose is...

How would somebody respond to this? The last statement of the OP is a cruel joke.

http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx

You are probably missing a set of parenthesis in the 3rd line of your pasted code

should be

AND ( LessonPlanActivity.[weight] IS NULL OR LessonPlanActivity.[weight]...

Anandkumar-SQL_Developer (9/9/2016)

---

Dear Kingston Dhasian ,

really your coding is really fantastic. (i was...

The below code should work on any version starting from 2005.

; WITH cte_diff AS

(

SELECT ROW_NUMBER() OVER( PARTITION BY model_key, brand, model ORDER BY created_date DESC...

This should help..

; WITH cte_diff AS

(

SELECT ROW_NUMBER() OVER( PARTITION BY model_key, brand, model ORDER BY created_date DESC ) AS RN,

...

Something like this..

SELECT Column2, SUM( CASE WHEN Column1 IS NULL THEN 1 ELSE 0 END ) AS NullCount

FROM TableName

GROUP BY Column2

HAVING SUM( CASE WHEN...

I am not sure what you mean by 35 combinations and your description is not detailed enough either.

Your request doesn't seem too complex and I am sure you will get...

For Period = 1 and Debnr = 1001, how do you decide that "Article A" should come under Summary1 and not Summary2 or something else?

Do you have any other column(...

You can use a CROSS APPLY as well

SELECT M.member_name,

M.member_plan,

LS.ncqa_code

FROM #member M

CROSS APPLY (

...

As John said above, this looks pretty straight-forward

I will give you some hints to get you started though

1. Have a look at INNER JOIN's and LEFT OUTER JOIN's in BOL...

Actually its an article...

Change MAX(transactionid) to MAX( Value ) in your query

The below method is another way to accomplish the same

SELECT TT.TransactionId,

MAX(...

You will need a string splitting function.

I am assuming the existence of one such function, "DelimitedSplit8K" whose script in given below for reference.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

DECLARE @String VARCHAR(1000)

SET @String =...

Something like this. The below mentioned link has a good explanation on the method used.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

SELECT E.StaffNumber,

STUFF( (

...