Forum Replies Created

Viewing 15 posts - 406 through 420 (of 2,463 total)

  • RE: Ideas to accomplish desired results in my query

    camiloecheverry11 (10/20/2016)

    I need a query where I can get the results from column qty hand, qty allocated and qty backordered.

    Without any DDL, sample data or anything about your data...

    "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

    October 20, 2016 at 1:24 pm

    #1907760

  • RE: Hide rows such as 4, 8, 14, 18, 24, 28 and so on

    Taking what Luis put together, you can hide these rows by adding an isVisable column to your dataset. Then, for the Row Viability setting in SSRS use an expression 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

    October 20, 2016 at 11:38 am

    #1907732

  • RE: Get the row count displayed in the page header

    Easy.

    Add a text box and for it's value use this expression:

    =COUNT(Fields!{some non-nullable field from your dataset}.Value, "{your dataset}")

    "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

    October 19, 2016 at 1:37 pm

    #1907529

  • RE: need suggestions on converting cognos cubes to ssas cubes

    I know that this is a few weeks old but since there was no answer:

    So will it be easier if I translate Cognos SQL queries and create SQL views...

    "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

    October 19, 2016 at 1:23 pm

    #1907523

  • RE: SQL query running slow after upgrading from 2005 to SQL 2012

    Sqlsavy (10/19/2016)

    Thank you all for the responses.

    I've attached query plan with resrticated and unlimitted memory please have a look.

    Thanks

    query:

    UPDATE dbo.table1

    SET table1.field = somevalue

    FROM dbo.table1 AS ABC

    INNER JOIN dbo.table2 AS xyz...

    "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

    October 19, 2016 at 9:46 am

    #1907457

  • RE: Deleted

    chocthree (10/16/2016)

    1) Which type of BI will provide the most job security (i.e. MS, Hadoop, etc)? Not fussed about high salary but just the demand of jobs.

    SSAS, Hadoop and...

    "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

    October 18, 2016 at 8:20 pm

    #1907309

  • RE: Talking baseball

    Ray K (10/14/2016)

    Tried to stay up last night to watch Dodgers vs. Nationals Game 5. I made it to the 8th inning before I finally gave up and went...

    "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

    October 14, 2016 at 5:36 pm

    #1906729

  • RE: Today's Random Word!

    djj (10/14/2016)

    whereisSQL? (10/14/2016)

    ThomasRushton (10/14/2016)

    djj (10/14/2016)

    Lynn Pettis (10/14/2016)

    Kaye Cahs (10/14/2016)

    djj (10/14/2016)

    Grumpy DBA (10/14/2016)

    djj (10/14/2016)

    crookj (10/13/2016)

    Bang

    Drum

    Slowly (anyone get this reference?)

    Book

    Worm

    Fish

    Fry

    Day

    Happy

    Excited

    incited

    "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

    October 14, 2016 at 10:25 am

    #1906626

  • RE: Split String On Delimiter

    Luis Cazares (10/14/2016)

    Here's a simple option using the DelimitedSplit8k that can be found here along with its explanation: http://www.sqlservercentral.com/articles/Tally+Table/72993/

    A specific function could be made to split only on the 7th...

    "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

    October 14, 2016 at 8:32 am

    #1906581

  • RE: Select all child nodes

    Jeff Moden (10/6/2016)

    Alan.B (10/6/2016)

    No need to use the Query method, it would be more efficient to just use value like this:

    SELECT Id ,

    ...

    "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

    October 7, 2016 at 2:01 pm

    #1905460

  • RE: Talking baseball

    "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

    October 7, 2016 at 11:57 am

    #1905441

  • RE: Splitting a multi-delimiter string and update

    Mike-342950 (10/6/2016)

    This is great! I have one question. Since the values are in a table already, would I still need a temp table?

    No. The temp table is just so you...

    "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

    October 6, 2016 at 1:05 pm

    #1905258

  • RE: Good hardware-slow performance. Possibly misconfigured.

    Mostly one Filegroup has one Data File.

    Log file is on L:\ drive

    But one huge 563 GB data file 'Scene_Data2' also lives in L:\ drive.

    Probably interfering with Log file.. or it...

    "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

    October 6, 2016 at 1:00 pm

    #1905257

  • RE: Can I allow a user to select nothing a multi-valued parm?

    This is pretty simple. You would just add a <None> option to your parameter drop-down; have a look at this:

    -- table that provides the parameter options

    DECLARE @yourtable TABLE (val...

    "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

    October 6, 2016 at 12:02 pm

    #1905243

  • RE: Talking baseball

    Ray K (10/6/2016)

    calvo (10/6/2016)

    Any last thoughts before these series begin to play out?

    I'm rooting for anyone except Boston! 😛 😀

    Good. You a Cubs fan now. Go Cubs!

    "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

    October 6, 2016 at 10:19 am

    #1905219

Viewing 15 posts - 406 through 420 (of 2,463 total)