Forum Replies Created

Viewing 15 posts - 901 through 915 (of 3,666 total)

  • RE: Simple arithmetic

    Sean Lange (12/10/2014)

    In actual code I would never be so sloppy as to not include proper parenthesis when required anymore than I would not be explicit with datatypes or schemas.

    Maybe...


    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]

    December 10, 2014 at 9:34 am

    #1763838

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/10/2014)

    Jack Corbett (12/10/2014)

    So in a meeting this morning I was going over a matrix for a 3rd-party product that lists what versions of...


    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]

    December 10, 2014 at 8:40 am

    #1763813

  • RE: Are the posted questions getting worse?

    Jack Corbett (12/10/2014)

    So in a meeting this morning I was going over a matrix for a 3rd-party product that lists what versions of the product are supported on...


    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]

    December 10, 2014 at 8:34 am

    #1763806

  • RE: SSIS Access

    butcherking13 (12/9/2014)

    Currently she can't even see it from her client and it is on the same domain.

    Although if she remotes into the server she can right click as Administrator and...


    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]

    December 9, 2014 at 10:28 am

    #1763604

  • RE: evidently confused on temp table scope

    hmmm

    That's news to me. A quick Google search found sources that agree with you and others that do not. Since one that agreed was a Microsoft Technet page,...


    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]

    December 8, 2014 at 3:47 pm

    #1763400

  • RE: evidently confused on temp table scope

    DSNOSPAM (12/8/2014)

    what if two people run the proc at the same time? Is the ## still within my login space, and can't be used by others?

    Thanks for the response.

    I...


    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]

    December 8, 2014 at 3:26 pm

    #1763397

  • RE: evidently confused on temp table scope

    DSNOSPAM (12/8/2014)

    I have a stored proc that calls a few other stored procs. I've included an edited version of it at the bottom. I assumed that if I...


    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]

    December 8, 2014 at 3:14 pm

    #1763393

  • RE: Why “3653.0 and 36524.0”?

    jshahan (12/8/2014)

    Quick joke, 36524 is the number of versions Jeff needs to upgrade on his old test box

    Hopefully he'll see this

    36524.0 if the required value for DBCC TimeWarp paramater 79...


    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]

    December 8, 2014 at 2:43 pm

    #1763387

  • RE: how to make my SSIS package execute successfully, even when there is no input feed file which is actually expected.

    sestell1 (12/8/2014)

    There are a few ways to prevent the package from failing when the file(s) are not there.

    One is to change the package properties so that it reports...


    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]

    December 8, 2014 at 10:23 am

    #1763323

  • RE: Count of accounts per zipcode

    cbrammer1219 (12/8/2014)

    I have that, I would like to get the totals for example, Meaning that there are that many accounts in that zipcode.

    ZipCode Count

    02149 ...


    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]

    December 8, 2014 at 8:47 am

    #1763297

  • RE: Count of accounts per zipcode

    Eirikur Eiriksson (12/8/2014)

    Window function version of Alvin's code

    😎

    SELECT

    State

    ,ZipCode

    ,Count(Account) OVER

    (

    ...


    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]

    December 8, 2014 at 8:42 am

    #1763290

  • RE: Count of accounts per zipcode

    Try:

    SELECT

    State

    ,ZipCode

    ,Count(Account) AS [Accounts]

    FROM YourTable

    GROUP BY State, ZipCode;


    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]

    December 8, 2014 at 8:25 am

    #1763284

  • RE: Datatype issue

    It's kind of hard to answer your question without knowing more about the data, the import process, and the table(s).


    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]

    December 5, 2014 at 10:20 am

    #1763025

  • RE: Hi guys, looking for suggestions

    How much do you know about SSIS?


    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]

    December 5, 2014 at 10:00 am

    #1763019

  • RE: Using SSIS

    Have people stopped taking time to learn the technology they want to use before trying to use 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]

    December 3, 2014 at 9:14 am

    #1762433

Viewing 15 posts - 901 through 915 (of 3,666 total)