Forum Replies Created

Viewing 15 posts - 811 through 825 (of 1,228 total)

  • RE: Getting incorrect results from SELECT inside of a stored procedure.

    @Counter means different things in different places, Jim. Not easy to follow. Try this instead:

    SELECT...

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

    October 3, 2011 at 3:11 pm

    #1389852

  • RE: Calculating Moving Averages with T-SQL

    sushilb (10/3/2011)

    In the if condition i check whether am i getting the exact thirteen previous days(13 row) if count is less than 13 then i again subtracting the missing rows...

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

    October 3, 2011 at 2:22 pm

    #1389820

  • RE: Calculating Moving Averages with T-SQL

    Can you fully and accurately account for the missing days? Is it all sundays? Is it only sundays?

    The accuracy of the solution provided to you will reflect the accuracy...

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

    October 2, 2011 at 1:09 pm

    #1389230

  • RE: comparing ip addresses in sql

    R.P.Rozema (8/21/2011)

    I don't know how this will work out for IPV6 addresses, but based on the idea of taking the bytes from the ip numbers and converting these into one...

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

    August 21, 2011 at 12:05 pm

    #1371186

  • RE: Adding rows od data together

    Extend the links table, which would be better designed normalised like this:

    GroupName Name

    North_South North

    North_South South

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

    May 27, 2011 at 12:40 am

    #1330795

  • RE: Looking for reasons...

    Something similar: a data feed to a warehouse was comparing the 10M row DW orders table to the 10M row OLTP orders table then aggregating to obtain the most recent...

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

    May 25, 2011 at 2:21 am

    #1329524

  • RE: Are the posted questions getting worse?

    WayneS (5/24/2011)

    What's up with all the old threads being resurrected lately? I've seen several this week already... 🙁

    Don't you know Wayne - fashion comes and goes. Hotpants again this summer...

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

    May 24, 2011 at 8:51 am

    #1329121

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (5/24/2011)

    Stefan Krzywicki (5/24/2011)

    LutzM (5/23/2011)

    Regarding the specific situation: it might be better for the person in question to officially ask for support. Try to deal with the situation "undercover"...

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

    May 24, 2011 at 8:22 am

    #1329095

  • RE: How can i create a Unique constraint that allow multiple nulls values

    A couple of possibilities here[/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]

    May 24, 2011 at 4:05 am

    #1328911

  • RE: How can i create a Unique constraint that allow multiple nulls values

    Use a filtered unique index.

    Edit - quote captured wrong post.

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

    May 24, 2011 at 3:38 am

    #1328896

  • RE: urgent ....pls help..how to read variables values from a view and pass them to a stored procedure.

    It can be easily done but the performance will be poor. Your best option is to rework the stored procedure (or an alternative version of it, retaining the original) so...

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

    May 22, 2011 at 2:33 pm

    #1328242

  • RE: Remove cursors without using while loop

    Ninja's_RGR'us (5/20/2011)

    ChrisM@home (5/20/2011)

    Ninja's_RGR'us (5/20/2011)

    There's no way I'd ever do that job from a forum.

    Hire pro.

    It's not as tough as it looks Ninja - it's an INSERT from 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]

    May 20, 2011 at 7:20 am

    #1327668

  • RE: Remove cursors without using while loop

    Ninja's_RGR'us (5/20/2011)

    There's no way I'd ever do that job from a forum.

    Hire pro.

    It's not as tough as it looks Ninja - it's an INSERT from a SELECT, OUTPUTting...

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

    May 20, 2011 at 6:50 am

    #1327637

  • RE: Remove cursors without using while loop

    mahe2682 (5/20/2011)

    ...

    can u help me for this.

    ...

    Look up the OUTPUT clause in Books Online.

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

    May 20, 2011 at 6:40 am

    #1327623

  • RE: Need help tweaking a random query

    You're welcome, thanks for the feedback.

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

    May 20, 2011 at 5:32 am

    #1327565

Viewing 15 posts - 811 through 825 (of 1,228 total)