Forum Replies Created

Viewing 15 posts - 7,156 through 7,170 (of 8,761 total)

  • RE: Concatenate fields and insert comma between: how to handle nulls

    mario17 (9/5/2014)

    Hi,

    I thought it's easy but somehow got lost, what is the good way to insert that bloody Comma intelligently, depending if any of var value is NULL.

    This is...

    September 6, 2014 at 2:40 pm

    #1743689

  • RE: Operator used tempdb to spill data during execution with spill level 1

    Here is another addition to the code, identifying the gaps more efficiently.

    😎

    USE TESTDB;

    GO

    ;WITH BASE_DATA AS

    (

    SELECT

    ST.STG_ID

    ...

    September 6, 2014 at 12:53 pm

    #1743684

  • RE: xml

    sakthikarajen (9/4/2014)

    Bunch of thanks for your fast reply....

    1.2008 r2

    2.don hav XSD file..

    suppose if we index an Xml data....how do we can view those indexes????

    There are few options and which is...

    September 6, 2014 at 10:49 am

    #1743677

  • RE: Help with the query

    Not much of a change needed from last time, adding a second conditional in the last part to allow for missing HardDrink did the trick.;-)

    😎

    USE tempdb;

    GO

    CREATE TABLE #TEMP (UserName varchar(20),Drink...

    September 6, 2014 at 9:10 am

    #1743676

  • RE: Adding a number to a string to create series

    ChrisM@Work (9/5/2014)

    Eirikur Eiriksson (9/5/2014)

    ChrisM@Work (9/5/2014)

    Meatloaf (9/3/2014)

    Hello,

    I trying to figure out the logic to add a number to the end of an ID to create a series.

    For example, I have an...

    September 6, 2014 at 7:03 am

    #1743674

  • RE: My SQL vs SQL

    Grant Fritchey (9/5/2014)

    So, Eirikur, if you used DATE instead of DATETIME would that also solve the issue? Just asking. I don't know MySQL from MyElbow.

    It is more a question of...

    September 6, 2014 at 6:15 am

    #1743673

  • RE: Need help with performance issue with a script

    Quick question, can you post the two execution plans?

    😎

    September 6, 2014 at 3:49 am

    #1743668

  • RE: help parsing a text field

    More for fun, I'm tossing three more spanners in the works

    😎

    USE tempdb;

    GO

    /********************************************************************

    Sample data

    ********************************************************************/

    DECLARE @SAMPLE_DATA TABLE

    (

    SD_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

    ...

    September 6, 2014 at 3:14 am

    #1743665

  • RE: Select Parent and Child with HiearchyID

    Here is a quick sample, should get you passed the hurdle.

    😎

    USE tempdb;

    GO

    CREATE TABLE #BOMTbl

    (

    ItemNo HIERARCHYID NOT NULL,

    Lvl AS ItemNo.GetLevel() PERSISTED,

    MatID VARCHAR(25)...

    September 6, 2014 at 2:43 am

    #1743662

  • RE: Are the posted questions getting worse?

    GilaMonster (9/5/2014)

    Grant Fritchey (9/4/2014)

    You never know. I get stumped all the time. That's why Gail's here.

    Wha?

    Well, at least I have a purpose in life...

    Looks like you have been "Granted" a...

    September 5, 2014 at 12:15 pm

    #1743595

  • RE: Adding a number to a string to create series

    ChrisM@Work (9/5/2014)

    Meatloaf (9/3/2014)

    Hello,

    I trying to figure out the logic to add a number to the end of an ID to create a series.

    For example, I have an EventID that may...

    September 5, 2014 at 5:23 am

    #1743474

  • RE: Data from one Table to Two Columns

    Quick thought, use aggregation and group by to eliminate the nulls (cross tab style)

    😎

    September 5, 2014 at 2:20 am

    #1743431

  • RE: View results not displaying nil columns

    Phil Parkin (9/5/2014)

    cstrati (9/5/2014)

    Hi Phil

    Thanks for your reply.

    Unfortunately I've ran your script and I'm getting the same 4 results.

    It doesn't appear that the columns that are emtpy display when...

    September 5, 2014 at 1:44 am

    #1743426

  • RE: Adding a number to a string to create series

    Jeff Moden (9/5/2014)

    Eirikur Eiriksson (9/4/2014)

    Jeff Moden (9/4/2014)

    I guess my question would be, if you recognize it as not being a good practice, why would you post the technique? We...

    September 5, 2014 at 12:52 am

    #1743411

  • RE: Adding a number to a string to create series

    Jeff Moden (9/4/2014)

    I guess my question would be, if you recognize it as not being a good practice, why would you post the technique? We just don't know what...

    September 4, 2014 at 11:52 pm

    #1743394

Viewing 15 posts - 7,156 through 7,170 (of 8,761 total)