Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 8,731 total)

  • RE: Latin small letter u with diaeresis

    Is the code page the same for source and destination? Is the ETL tool doing some kind of data conversion?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 12, 2016 at 7:01 am

    #1917368

  • RE: How to identify that Dynamic Sql fail?

    You've already got an example on how to parametrize your dynamic sql, but you kept using the string concatenation. That's a basic NONO in my ruleset.

    Why do you want to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 12, 2016 at 5:54 am

    #1917350

  • RE: Today's Random Word!

    Revenant (12/9/2016)

    djj (12/9/2016)

    crookj (12/9/2016)

    Ed Wagner (12/9/2016)

    Stuart Davies (12/9/2016)

    Manic Star (12/8/2016)

    Alan.B (12/8/2016)

    Gravitational

    Threshold

    Boundary

    Border

    Line

    Vector

    Algebra

    Calculus

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 9, 2016 at 9:42 am

    #1917108

  • RE: Help with query to find duplicate fields from one column and return relevant information

    sgmunson (12/9/2016)

    Luis Cazares (12/9/2016)

    I'd suggest that you read Thom's comments. However, this is a shot in the dark to show what you might need.

    SELECT bk.CustomerNumber,

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 9, 2016 at 6:48 am

    #1917045

  • RE: Help with query to find duplicate fields from one column and return relevant information

    I'd suggest that you read Thom's comments. However, this is a shot in the dark to show what you might need.

    SELECT bk.CustomerNumber,

    cal.Day_Uid,

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 9, 2016 at 6:30 am

    #1917041

  • RE: Performance issue with nested query

    rgp151 (12/8/2016)

    Yeah, I can't figure this out. But it is the case that if I simply insert the result of the nested query into a temp table first, then select...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 8, 2016 at 2:05 pm

    #1916902

  • RE: Anti Join question

    Would a FULL OUTER JOIN help?

    I changed your sample data to get some results.

    -- sample data

    DECLARE @table1 TABLE (id int identity, content int NOT NULL, primary key(id, content));

    DECLARE @table2 TABLE...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 8, 2016 at 1:33 pm

    #1916895

  • RE: MCSA 2012 or 2016?

    Thom A (12/8/2016)

    Repeat of post http://www.sqlservercentral.com/Forums/Topic1841367-2799-1.aspx under different account?

    Try to keep one topic per questions 🙂 😎

    You linked to this thread.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 8, 2016 at 12:50 pm

    #1916886

  • RE: Can I have a default table value based on another column???

    I'm confused. Do you want to have a default or a computed column?

    For a default, you might need a trigger to handle that option.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 8, 2016 at 10:45 am

    #1916865

  • RE: Are the posted questions getting worse?

    Alan.B (12/8/2016)

    Jeff Moden (12/7/2016)

    This Saturday, 12/10, marks the anniversary of a very unhappy event for me...

    Ditto.

    I can't help feeling sad when I remember this. I never met him in...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 8, 2016 at 10:24 am

    #1916856

  • RE: Performance issue with nested query

    The description doesn't begin to describe the real problem.

    Without at least having the full query and actual execution plans, there's no real advice that can be given here. I agree...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 8, 2016 at 10:05 am

    #1916843

  • RE: Today's Random Word!

    Ed Wagner (12/8/2016)

    Revenant (12/8/2016)

    Kaye Cahs (12/8/2016)

    Manic Star (12/8/2016)

    crookj (12/8/2016)

    Brandie Tarvin (12/8/2016)

    Stuart Davies (12/8/2016)

    Ray K (12/7/2016)

    whereisSQL? (12/7/2016)

    Manic Star (12/7/2016)

    Ed Wagner (12/7/2016)

    djj (12/7/2016)

    Luis Cazares (12/7/2016)

    Ed Wagner (12/7/2016)

    DamianC (12/7/2016)

    Revenant (12/7/2016)

    Manic Star (12/7/2016)

    Limbo

    Stick

    Man

    Machine

    War

    Materials

    Labor

    Delivery

    Midwife

    Midtown

    Midriff

    Bare

    necessities

    oxygen

    Hydrogen

    Bomb

    Explosion

    Implosion

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 8, 2016 at 9:12 am

    #1916822

  • RE: Concatenate fields with separator character using XML PATH

    What Thom said, just don't use varchar(MAX) to optimize the resources. 😉

    Just keep the length of the longest type (in this case 1).

    CREATE TABLE foo (

    id INT IDENTITY(1,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 8, 2016 at 7:49 am

    #1916779

  • RE: AG Backup Preference

    I don't find the confusing part. Or maybe I just noticed the 3 hints to the correct answer.

    I need to ensure the databases are backed up while minimzing load on...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 8, 2016 at 7:14 am

    #1916762

  • RE: Date format for mm/dd/yyyy h:mm:ss AM/PM ?

    There's no direct code, but this should help.

    DECLARE @Datetime datetime = GETDATE();

    SELECT @Datetime, CONVERT(char(10), @Datetime,101) + STUFF( SUBSTRING( CONVERT(char(100), @Datetime,109), 12, 15), 10, 4, ' ');

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 7, 2016 at 2:08 pm

    #1916626

Viewing 15 posts - 1,756 through 1,770 (of 8,731 total)