Forum Replies Created

Viewing 15 posts - 391 through 405 (of 3,666 total)

  • RE: CAPS in column names

    SQLTougherGuy (8/17/2015)


    Hello,

    Is there a performance hit if I use CAPITOL LETTERS (like this) in column names for my SQL Server tables? Logically I would think that lower case letters would...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSIS Conditional Split Expressions

    Steve Jones - SSC Editor (8/17/2015)


    Probably slightly incorrect to say it's only one expression. It could be, but it could be multiple ones.

    I'll change the question, but I'm not sure...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSIS Package for incomming source..

    Use an expression for the connection string of the connection manger used to the to the file to e imported.

    In that expression, use a formula that sets the date values...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSIS Conditional Split Expressions

    I would have felt bad if I got this one wrong.

    Good one to start the week with Steve.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSIS Conditional Split Expressions

    sknox (8/17/2015)


    And here starts the obligatory pedantry. 😛

    In a conditional split transformation, an expression is evaluated for each row.

    is not quite correct. The correct statement is:

    In a conditional split...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (8/14/2015)


    SQLRNNR (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.

    😎

    Maybe he has coded it differently than you...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Seeking guidance regarding a tSQL Script

    First thing I would do is run a query that shows be all the people with the multiple rows, and their data. Then, looking at the data, see if you...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSDT-BI tool for SQL 2014 doesnot work with oracle 12c oledb driver

    Did you try it a 2nd time?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Seeking guidance regarding a tSQL Script

    Lynn Pettis (8/14/2015)


    Alvin Ramard (8/14/2015)


    Lynn, as far as I can tell, your script will work as long as the row for PercentFullTime = 1 is the same rows as AnnualizingFactor...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Seeking guidance regarding a tSQL Script

    Lynn, as far as I can tell, your script will work as long as the row for PercentFullTime = 1 is the same rows as AnnualizingFactor = 2080. For...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Seeking guidance regarding a tSQL Script

    Eirikur Eiriksson (8/14/2015)


    Alvin Ramard (8/14/2015)


    Lynn Pettis (8/14/2015)


    Something like this:

    declare @TestTable table(

    EEID int,

    Name varchar(64),

    AnnualizingFactor int,

    PercentFullTime...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Seeking guidance regarding a tSQL Script

    Lynn Pettis (8/14/2015)


    Something like this:

    declare @TestTable table(

    EEID int,

    Name varchar(64),

    AnnualizingFactor int,

    PercentFullTime decimal(3,2));

    insert into @TestTable

    values

    (1,'Marvin, Leo',2080,1...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/12/2015)


    < Rant >

    I don't know about others but I am really tired of people thinking that using vulgarity is appropriate in a professional environment and this is a...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    djj (8/12/2015)


    jasona.work (8/12/2015)


    Grant Fritchey (8/12/2015)


    Brandie Tarvin (8/12/2015)


    YAY! The forums are back!

    I was worried they'd be down all day.

    Me too. I sent an email to RG support. Maybe someone did something.

    RG...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    WayneS (8/11/2015)


    Any other Threadizens going to the Louisville SQL Saturday next week?

    I'm thinking about it.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 391 through 405 (of 3,666 total)