Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 1,228 total)

  • RE: How can I get this selection in one TSQL run ?

    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...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 12:38 pm

    #1261325

  • RE: Need a little help with a date driven report

    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...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 12:36 pm

    #1261324

  • RE: How can I get this selection in one TSQL run ?

    Digs (12/11/2010)

    I remember the more friendly days...I am sure as hell NOT doing home work, I am an old fart struggle with TSQL !:cool:

    Come on be kind !

    Hey Digs, I...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 12:30 pm

    #1261322

  • RE: Need a little help with a date driven report

    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...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 11:34 am

    #1261311

  • RE: How can I get this selection in one TSQL run ?

    Check out ROW_NUMBER() in BOL.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 11:10 am

    #1261305

  • RE: Are the posted questions getting worse?

    GilaMonster (12/11/2010)

    ChrisM@home (12/11/2010)

    What's surprising me, today, is the number of folks lurking in here - you're not all avoiding the Christmas crowds now are you?

    Spent the morning doing a SAN...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 11:08 am

    #1261304

  • RE: Need a little help with a date driven report

    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...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 11:00 am

    #1261302

  • RE: Are the posted questions getting worse?

    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...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 9:52 am

    #1261290

  • RE: Quirky Update TSQL skill required on this calc

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

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 9:44 am

    #1261289

  • RE: Optimizing This Query

    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()...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 7:05 am

    #1261277

  • RE: time difference in hh.mm

    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.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 11, 2010 at 6:09 am

    #1261271

  • RE: FoxPro Book Givaway! (Sorry, Cont. U.S. only)

    mtillman-921105 (12/6/2010)

    ChrisM@home (12/6/2010)

    mtillman-921105 (12/6/2010)

    ChrisM@home (12/6/2010)

    Traitor.

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

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 6, 2010 at 2:30 pm

    #1259227

  • RE: FoxPro Book Givaway! (Sorry, Cont. U.S. only)

    mtillman-921105 (12/6/2010)

    ChrisM@home (12/6/2010)

    Traitor.

    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...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 6, 2010 at 1:44 pm

    #1259206

  • RE: FoxPro Book Givaway! (Sorry, Cont. U.S. only)

    Traitor.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 6, 2010 at 1:28 pm

    #1259201

  • RE: Short circuit SQL query

    You're checking the first six characters are digits, so why not:

    WHERE LEFT(RCD.Variable4, 4) BETWEEN '5011' AND '7999'

    which can potentially make use of an index?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    December 6, 2010 at 12:49 pm

    #1259187

Viewing 15 posts - 991 through 1,005 (of 1,228 total)