Forum Replies Created

Viewing 15 posts - 61 through 75 (of 1,228 total)

  • RE: DUPLICATING A ROW BY NUMBER OF OCCURENCE OF A PARTICULAR FIELD IN ANOTHER TABLE

    JALLY - Thursday, February 2, 2017 12:53 PM

    Thanks everyone,

    I figured it out and used a while loop in a cursor.

    Thanks

    Jally, are you...

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

    February 2, 2017 at 2:06 pm

    #1926473

  • RE: join query bringing back null values

    junk.mail291276 - Thursday, February 2, 2017 11:06 AM

    Hello,

    I am trying to do a join that isn't bringing in the values as I'm...

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

    February 2, 2017 at 11:13 am

    #1926407

  • RE: possible combinations for all rows in table

    urbanromio2 (11/28/2016)

    Attributes X Y Z

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

    November 28, 2016 at 2:10 pm

    #1914828

  • RE: Recursion to iterate function

    Jeff Moden (11/28/2016)

    urbanromio2 (11/26/2016)

    Some one help me to convert the recursive method to iterative function.

    To be honest, I just don't have the time to try to science out what...

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

    November 28, 2016 at 11:15 am

    #1914797

  • RE: Coalesce and ISNULL not grabbing columns with NULL

    Matt.Altman (11/17/2016)

    Seems like this worked

    SELECT COALESCE (n.Application, k.Application) Application

    FROM Table1 n

    FULL OUTER JOIN Table2 k

    ON n.Application = k.Application

    GROUP BY COALESCE (n.Application, k.Application)

    Looks good to me, Matt.

    As a hardcore TSQL...

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

    November 17, 2016 at 4:00 pm

    #1913259

  • RE: Coalesce and ISNULL not grabbing columns with NULL

    Matt.Altman (11/17/2016)

    I am trying to combine data from two tables. 1 table has a column where a value could be NULL. When I run my select, I never...

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

    November 17, 2016 at 2:24 pm

    #1913242

  • RE: Computed Column in optimizing query returning large data

    comic_rage (11/16/2016)

    was able to improve the query by moving the isnull to the select and adding the column to a filtered index. Was able to reduce query time from 9+...

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

    November 16, 2016 at 1:04 pm

    #1912908

  • RE: Computed Column in optimizing query returning large data

    DesNorton (11/16/2016)

    deleted ... somehow my post was duplicated

    Because it needed saying twice?

    Assuming the gridview can handle this much data, it's got to get there down the wire then presumably...

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

    November 16, 2016 at 12:15 pm

    #1912904

  • RE: Computed Column in optimizing query returning large data

    comic_rage (11/16/2016)

    I am measuring the time on SSMS.

    What will consume the result set?

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

    November 16, 2016 at 11:25 am

    #1912885

  • RE: Computed Column in optimizing query returning large data

    comic_rage (11/16/2016)

    Hi,

    I have the following query that is returning 1.6 M rows and about 300 columns. I can't change this factor. Here is the current

    query

    select Column1 ... Column290

    from dob.table1

    where...

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

    November 16, 2016 at 11:08 am

    #1912877

  • RE: How to start up transactional replication after AlwaysOn failover

    Transnational replication has been postponed by Microsoft until 2027 and the widedescale introduction of quantum fibre, delayed by confusion regarding the identity of the next Dr Who. If however you...

    [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 27, 2016 at 1:55 pm

    #1909232

  • RE: lookup value for each row

    marc.corbeel (10/17/2016)

    On the sample data their were no indexes indeed, but on the db I tested the solutions, there are indexes on the currency id and on the date...

    That's very...

    [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 17, 2016 at 11:49 am

    #1906957

  • RE: Using SP in UDF

    Alaster07 (10/14/2016)

    I understand that an iTVF is better; however, I have no experience using them. I have read about them and attempted to implement it, but it was not...

    [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 14, 2016 at 1:50 pm

    #1906681

  • RE: insert into table with foreign key constraint

    dianerstein 8713 (10/12/2016)

    Is there a way to do the update I want to accomplish without dropping or disable the constraint? If so, how would you accomplish this goal?

    Yes. Collect the...

    [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 12, 2016 at 2:30 pm

    #1906207

  • RE: Using SP in UDF

    Alaster07 (10/12/2016)

    Correct me if I am wrong, but I am unable to use NEWID() and RAND() functions in UDFs.

    Try an inline table-valued function instead.

    [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 12, 2016 at 2:27 pm

    #1906206

Viewing 15 posts - 61 through 75 (of 1,228 total)