Forum Replies Created

Viewing 15 posts - 1,246 through 1,260 (of 2,462 total)

  • RE: Pivot, NestedPivot, unPivot?

    Luis beat me too it, I came up with the same crosstab solution that he did (his 1st query). I wanted to add that, as long as there are no...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 24, 2015 at 9:37 am

    #1829190

  • RE: SQL Query

    martyres (9/24/2015)

    I need to complicate this a bit more accurately to the data. Also assume that there are sometimes, only single entries existing already......and I do NOT want them...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 24, 2015 at 7:18 am

    #1829132

  • RE: Choosing values

    I have personally found CHOOSE to be completely worthless. I have never seen an article or example of where CHOOSE was better than the alternatives. It's slow. I just don't...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 23, 2015 at 10:12 pm

    #1829013

  • RE: Choosing values

    Ed Wagner (9/23/2015)

    Alvin Ramard (9/23/2015)

    Luis Cazares (9/23/2015)

    Manic Star (9/23/2015)

    patricklambin (9/23/2015)

    Stewart "Arturius" Campbell (9/22/2015)

    Interesting question, thanks Steve

    Another of the functions copied from Excel.

    I don't think so. These functions have been introduced...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 23, 2015 at 9:34 pm

    #1829009

  • RE: Choosing values

    Manic Star (9/23/2015)

    patricklambin (9/23/2015)

    Stewart "Arturius" Campbell (9/22/2015)

    Interesting question, thanks Steve

    Another of the functions copied from Excel.

    I don't think so. These functions have been introduced only to make easier the translation...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 23, 2015 at 9:17 pm

    #1829007

  • RE: SQL Query

    This can certainly be performance tuned but will work:

    -- easily consumable sample data

    DECLARE @table TABLE(ID int, value decimal (3,1))

    INSERT @table

    SELECT 1111,14.0 UNION ALL

    SELECT 1111,14.0 UNION ALL

    SELECT 2222,13.0 UNION ALL

    SELECT 2222,13.0...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 23, 2015 at 9:06 pm

    #1829006

  • RE: Calculating running totals for partitions of data

    @Wayne

    Was this your intended 2012 solution:

    -- SQL SERVER 2012 version:

    SET STATISTICS IO ON;

    SELECT

    RowID,

    CODE,

    COLUMN1,

    COLUMN2,

    RunningTotal =

    ...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 23, 2015 at 4:23 pm

    #1828969

  • RE: Calculating running totals for partitions of data

    kdejan87 (9/23/2015)

    What do you think about this:

    DECLARE @t1 TABLE (

    CODE nvarchar(20),

    COLUMN1 numeric(18, 2),

    COLUMN2 numeric(18, 2)

    )

    INSERT INTO @t1 (CODE, COLUMN1, COLUMN2)

    VALUES ('432',...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 23, 2015 at 4:03 pm

    #1828967

  • RE: Are the posted questions getting worse?

    Sean Lange (9/21/2015)

    WayneS (9/21/2015)

    Alan.B (9/21/2015)

    The homework assignment may dictate that the problem be solved with a cursor. Anyone who is good with cursors want to take a look at this?...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 21, 2015 at 5:45 pm

    #1828256

  • RE: Are the posted questions getting worse?

    The homework assignment may dictate that the problem be solved with a cursor. Anyone who is good with cursors want to take a look at this?

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 21, 2015 at 9:50 am

    #1828130

  • RE: How to find the first, last and the Highest (Peak Value) in a list

    ITU_dk2012 (9/20/2015)

    @Alan,

    Thank you for the code example. I am just learning T-SQL and don't know the advanced stuff in T-SQL. I am using Cursors to get the first value, the...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 21, 2015 at 9:48 am

    #1828129

  • RE: Best way to learn Data Warehousing Concepts?

    The Data warehouse toolkit that Louis mentioned is awesome - that has been the best book I have read about the whole data warehouse/BI life cycle. It's a shame that...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 20, 2015 at 3:10 pm

    #1827967

  • RE: Xpath SQL query help please

    kiril.lazarov.77 (9/18/2015)

    Thank you very much Alan.

    No problem.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 18, 2015 at 11:10 pm

    #1827873

  • RE: BI Internship help

    Koen Verbeeck (9/11/2015)

    Alan.B (9/10/2015)

    Kimball's The Microsoft Data Warehouse Toolkit, 2nd Edition[/url] is essential for any new BI developer. That's my BI bible.

    Did you read Star Schema The Complete Reference...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 18, 2015 at 8:40 am

    #1827758

  • RE: Script all Indexes

    Just ran across this script - it works quite nicely for me.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 17, 2015 at 9:46 pm

    #1827639

Viewing 15 posts - 1,246 through 1,260 (of 2,462 total)