marksquall (5/3/2012)

---

Actually that is what I read already in other post that you cannot update/delete all tables with one single query, each table has it's own dedicated [font="Courier New"]UPDATE[/font] query...

I agree with you that CROSS JOIN being explicit is a superior syntax, for readability mainly. I don't use commas that way for that exact reason. But your...

Jeff Moden has a great article on this very subject. Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Drew

It clearly says,

or were you referring to not finding CROSS JOIN?

It doesn't specifically state anything about CROSS JOINS. ...

GSquared (5/2/2012)

---

Per what?

The Outer Join...

Cadavre (5/2/2012)

---

WITH CTE(n) AS(SELECT 1

...

Please don't start multiple threads on the same topic. It fragments the replies.

Please post in the original thread: http://www.sqlservercentral.com/Forums/Topic1293567-338-1.aspx.

Drew

I think that this is just a language problem. When Sean said to replace = with IN, he only meant the one in the WHERE clause, not all of...

You want to be careful here. Life isn't nearly as simple as your model implies. For example, someone could get married, divorced, and then re-married. Their current...

Sean Lange (4/26/2012)

---

Not sure what you mean by "It didn't like". 😛

I should be the same as...

It's actually very easy. It's simply concatenating two conditional expressions together. The SSRS equivalent would be something like the following

=IIf(InStr(VIEW_Creditors.DISCREPENCY_CODE.value, Parameters!Contingent_Code.value) > 0, Parameters!Contingent_Code.value, "") & IIf(InStr(VIEW_Creditors.DISCREPENCY_CODE.value, Parameters!Unliquidated_Code.value)...

The problem is that you're trying to do it all with one function, but you need separate functions for each week.

SELECT Resp_ID, Brand

,COUNT(DISTINCT CASE WHEN [Week] = 2 THEN Q5...

ColdCoffee (4/24/2012)

---

You would better off be writing it in IF...ELSE block. THat would produce a decent plan always.

But if u insist in using single query to do that, then u...

Here is how I would approach this.

WITH CTE AS (

SELECT DateValue, [Value], ROW_NUMBER() OVER( PARTITION BY DateValue, [Value] ORDER BY (SELECT 1) ) AS rn

FROM #tableOne

EXCEPT

SELECT DateValue, [Value], ROW_NUMBER() OVER(...

I agree with Lynn here. If you can't represent your problem with 50 or fewer records, then your problem is probably too complex to solve in a forum post.

Also,...