GilaMonster (12/11/2010)

---

ChrisM@home (12/11/2010)

---

GilaMonster (12/11/2010)

---

Spent the morning doing...

Jeff Moden (12/11/2010)

---

Digs (12/11/2010)

---

What for... I have ID as a count down, How's ROW_NUMBER() gonna make a diff ???

All I need is a guru to spend 1 sec of his...

bickling77 (12/11/2010)

---

Ok , but I have no Idea what you have just written. LOL. I have never seen a select statement yet with # symbols in it. SO I have...

Hey Digs, I...

Thanks for being candid.

Try something like this to start:

SELECT p.*, '#' AS '#', s.* -- # is a 'wall' between s-columns and p-columns - a dev trick

FROM PROGRAM p

INNER JOIN...

Check out ROW_NUMBER() in BOL.

GilaMonster (12/11/2010)

---

Spent the morning doing a SAN...

Consuming the joins from the WHERE clause into ansi-style joins shows that your query will produce a cartesian product:

--CREATE VIEW PROG_LINEUP AS

SELECT DISTINCT

S.PROGTIME AS "SHOWTIME",

S.PROGNAME AS "PROGRAM TITLE",

C.CHNUM...

Craig Farrell (12/10/2010)

---

WayneS (12/10/2010)

---

Is it just me, or do others also see that the quantity of technical posts has dropped considerable lately? I know all the schools are closed, but...

ix_goog? Sounds familiar - take a peek at this[/url].

The source table is small (at this point, assume it will grow) so I'd do some preprocessing into a temp table then query from that, something like:

SELECT seq = ROW_NUMBER()...

Please provide ddl (CREATE TABLE...) script and dml (INSERT INTO...) script which when run will create and populate a table with a few rows of representative data.

mtillman-921105 (12/6/2010)

---

ChrisM@home (12/6/2010)

---

mtillman-921105 (12/6/2010)

---

Ha! 'Not sure what you mean by that. Traitor to FoxPro? If you mean FoxPro, I really liked it, but keeping a job...

mtillman-921105 (12/6/2010)

---

Ha! 'Not sure what you mean by that. Traitor to FoxPro? If you mean FoxPro, I really liked it, but keeping a job using FoxPro...

Traitor.