He means what are the business rules to get that?...

Using the ddl that Luis posted and changing a couple column names there are lots of NULLs in this data. I am willing and able to help. I just need...

Can you post your sample data as inserts? That let's us work on the issue instead of turning your data into something we can use.

JAZZ Master (6/4/2014)

---

Ed Wagner (6/4/2014)

---

Sean Lange (6/4/2014)

---

SQLRNNR (6/4/2014)

---

crookj (6/4/2014)

---

Sean Lange (6/4/2014)

---

SQLRNNR (6/4/2014)

---

Sean Lange (6/4/2014)

---

crookj (6/4/2014)

---

whereisSQL? (6/4/2014)

---

Sean Lange (6/4/2014)

---

SQLRNNR (6/4/2014)

---

Ed Wagner (6/3/2014)

---

jasona.work (6/3/2014)

---

Ed Wagner (6/3/2014)

---

Sean Lange (6/3/2014)

---

crookj (6/3/2014)

---

jasona.work (6/3/2014)

---

JAZZ Master (6/3/2014)

---

SQLRNNR...

dquirion78 (6/4/2014)

---

Who cares what language the columns names are in? We can't offer much help because we can't see your screen, have no idea what your data structures are like,...

dquirion78 (6/4/2014)

---

cte1

as

select table2.field1, table2.field2

from table2

where...

--table3.field1 not the same value than table2.field1

cte2

as

select table3.field1, table3.field2

from table3

inner join CTE1

union table3.field2 on CTE1.FIELD2

where ...

select cte1.field1,cte1.field2

from cte1

union all

select cte2.field1,cte2.field2

from...

prepaess (6/4/2014)

---

hi all did any one know how can i make pies by select means for example i have two country and i will calculate number of women and man...

SQLRNNR (6/4/2014)

---

crookj (6/4/2014)

---

Sean Lange (6/4/2014)

---

Haven't...

Not sure why the previous posted used partition by on the aggregate columns. That forced them to use a distinct. The logic was 99% done for you. All you need...

Haven't played WoW in a...

dquirion78 (6/4/2014)

---

I'm not showing my code is because it's so much long and Field are in french.

Basically

I want to select cte1 union all cte2 but cte2 uses cte1 and...

WoW

Hungry

djj (6/4/2014)

---

dquirion78 (6/4/2014)

---

Hi

I'm using Sql server 2012

On my stored procedure I declare table variable but I have an error "must declare @temptable in my cte" How I can...

dquirion78 (6/4/2014)

---

Hi

Sorry to ask 2 questions so fast... I'm just learning...

I want to fill a table variable with 2 differents cte. but I got this error : Invalid object name...