Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 1,228 total)

  • RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

    Lynn Pettis (1/10/2010)

    Do you think you could edit your post and put the [ url ] [ /url ] (no spaces inside the brackets) around the url's? This would...

    [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]

    January 10, 2010 at 1:31 pm

    #1101566

  • RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

    See also http://www.sqlservercentral.com/Forums/FindPost844653.aspx

    See also http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/50ebe46e-2ef5-41d9-b915-b4405ed4a15f

    See also http://forums.asp.net/t/1447537.aspx :w00t:

    See also http://sjc.ironspeed.com/post?id=3575239&goto=nextnewest

    The earliest of these posts is six months ago.

    Surely it's worth spending fifteen minutes setting up a little...

    [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]

    January 10, 2010 at 12:55 pm

    #1101552

  • RE: Insert character question

    hansontd (1/10/2010)

    I had tried utilzing REVERSE() with stuff but for whatever reason I guess I wasn't utilizing it correctly as I never got teh results I was after...but thank for...

    [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]

    January 10, 2010 at 8:21 am

    #1101510

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (1/9/2010)

    Take a look at this one

    http://www.sqlservercentral.com/Forums/Topic844889-392-1.aspx

    It is one of the worst I have seen on SSC in a long long time.

    Lynn - I must compliment you on your restraint...

    [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]

    January 10, 2010 at 2:49 am

    #1101477

  • RE: selecting TOP row from a result set

    SQL Learner-684602 (1/9/2010)

    [font="Comic Sans MS"]Hi all.

    I have question in a query that is returning me a set of data....with following columns:

    account_no / emply_no / dept_no / address / Balance /...

    [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]

    January 10, 2010 at 2:29 am

    #1101472

  • RE: Are the posted questions getting worse?

    Sheesh...check this one out.

    Ten foot pole hey? A newspaper contributor recently described Roman Polanski as "The five foot Pole you wouldn't want to touch with a ten foot pole" 😀

    When...

    [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]

    January 9, 2010 at 1:49 pm

    #1101432

  • RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

    How about some sample data, Ifila? You've visited here 399 times, you must know the drill by now 😛

    [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]

    January 9, 2010 at 1:01 pm

    #1101429

  • RE: Insert character question

    hansontd (1/9/2010)

    I've used the STUFF function numerous times in the past but just couldn't wrap my mind around how to work it in this case....I've always dealth with strings and...

    [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]

    January 9, 2010 at 12:59 pm

    #1101428

  • RE: need help with parsing string

    is250sp (1/8/2010)

    I have a script that finds the 2nd period and returns the first and second nodes in a string. It works fine as long as there is a...

    [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]

    January 9, 2010 at 3:38 am

    #1101345

  • RE: Complicated Query Help (for a relative beginner)

    Hi Mitch

    Looks like your problem could be solved by using a recursive CTE.

    If you set up sample table scripts and data insertion scripts as Gail suggests, you will 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]

    January 9, 2010 at 3:14 am

    #1101342

  • RE: Using DATEPART without Select

    Robert Lassiter (1/8/2010)

    I have created tables named for each month. January, February etc. Once per month I will delete all records in the current months table because...

    [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]

    January 9, 2010 at 3:10 am

    #1101339

  • RE: Want to use WHILE loop in Stored procedure

    Jeff Moden (12/31/2009)

    lobbymuncher (12/31/2009)

    ...and it's too early for beer!

    NEVER! 😀

    LOL! Happy New Year Jeff!

    [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]

    January 1, 2010 at 5:52 am

    #1098079

  • RE: Are the posted questions getting worse?

    Luke L (12/31/2009)

    Bru Medishetty (12/31/2009)

    Wishing you all a Very Happy, Prosperous and Safe New Year 2010.

    I had few horrific moments :w00t: today morning driving to work. So all those...

    [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 31, 2009 at 11:49 am

    #1097985

  • RE: Want to use WHILE loop in Stored procedure

    lmu92 (12/31/2009)

    lobbymuncher (12/31/2009)

    ...

    You're on European time? I'll try not to clash with you this morning. I'm bored and it's too early for beer!

    Cheers

    ChrisM@home

    Yep, I live in Germany. Right now...

    [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 31, 2009 at 4:40 am

    #1097832

  • RE: Want to use WHILE loop in Stored procedure

    lmu92 (12/31/2009)

    lobbymuncher (12/31/2009)

    Don't do it like this. Write a query which works, then encapsulate it into a stored procedure. A stored procedure is a query (or set of statements) which...

    [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 31, 2009 at 4:07 am

    #1097816

Viewing 15 posts - 1,201 through 1,215 (of 1,228 total)