bluetea.55z (4/11/2013)

---

I need to do the following:

Write a query to display a daily report of all books sold this week including 0 sold, use temp tables.

Columns in the result...

If provided all requested, we should be able to test and compare changes to original code in small workable chunks, breaking the code down piece by piece.

Okay, this can be simplified but it isn't going to be easy. Some of this code is doing a lot more work than is needed. If you would...

tammyf (4/11/2013)

---

Can someone help me understand why this is happening:

If I put the following in a where clause:

CASEWHEN PATINDEX('%[^0-9 ]%',h.oe_po_no) = 0

THEN Cast(RTrim(LTrim(h.oe_po_no)) as BigInt)

ELSE 0

END =...

Jeff Moden (4/11/2013)

---

Lynn Pettis (4/11/2013)

---

Steve Jones - SSC Editor (4/11/2013)

---

Lynn Pettis (4/11/2013)

---

Jan Van der Eecken (4/11/2013)

---

Dunno, but it really looks...

Lowell (4/11/2013)

---

fantastic job providing the DDL and sample data!

i think you can use row_number() to get what you are after:

SELECT * FROM (

SELECT

ROW_NUMBER() OVER(PARTITION BY symbol ORDER BY quote_date...

I'd start by looking at the row_number() windowing function. This makes what you need simple, that and a CTE.

Why? ...

Here is another option:

SELECT

Audit_ID,

EntID,

Field_A,

Field_B,

ActionDate,

rn3 = ROW_NUMBER()...

As long as each backup file is independent (highly recommended whether you compression or not) as you can't mix compressed and uncompressed backups in the same file.

Steve Jones - SSC Editor (4/11/2013)

---

Lynn Pettis (4/11/2013)

---

Jan Van der Eecken (4/11/2013)

---

Dunno, but it really looks like he was dumped...

I would start by putting the indexes into a spread sheet grouped by tables. Start by comparing the order of the equality columns (your WHERE or ON clauses would...

Sounds fair.

I would not automate this. Each index suggested needs to looked at with a critical eye, not just at the individual index but at al the other indexes suggested...

Instead of deleting your question it would have been better to post what you found for others that may have a similar issue.