Forum Replies Created

Viewing 15 posts - 121 through 135 (of 3,666 total)

  • RE: read file *.db, *.px paradox from ssis

    dramon14 (1/7/2016)


    because the process must be automatic, you must run at 7am and be the data must be ready in the database for analysis. I also thought the process by...



    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: Nested Case statements Help

    amar_kaur16 (1/7/2016)


    I have a table of tests where I have data in the tabular format:

    English 8:30 9:00 9:30

    Reading...



    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?

    Just thinking ... would be interesting if one could create an infinite LMGTFY loop. 😀



    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?

    SQLRNNR (1/6/2016)


    BTW - hApPy New YEaR

    Hoppy New Year to you too.



    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?

    Jeff Moden (1/6/2016)


    SQLRNNR (1/6/2016)


    Jeff Moden (12/29/2015)


    Grant Fritchey (12/29/2015)


    That picture has always struck me... it's either a picture of Grant's back yard when he's BBQ'ing or a picture of Detroit 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]

  • RE: Are the posted questions getting worse?

    Sean Lange (1/6/2016)


    Steve Jones - SSC Editor (1/6/2016)


    Sean Lange (1/6/2016)


    Wow. I rarely have to deal with user issues but I was just on a phone call with one of our...



    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?

    Jeff Moden (1/6/2016)


    Brandie Tarvin (1/6/2016)


    djj (1/5/2016)


    SQLBill (1/5/2016)


    If I hear of any openings anywhere that allow full work from home, I'll pass them your way.

    -SQLBill

    There all over the internet.:-P 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]

  • RE: Dynamically changing the value in Conditional split

    I don't think you can assign the condition(s) to a variable like you're trying to do.



    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: It's the end of the year

    Eirikur Eiriksson (1/4/2016)


    Alvin Ramard (1/4/2016)


    Eirikur Eiriksson (1/4/2016)


    Jeff Moden (1/4/2016)


    Lynn Pettis (1/4/2016)


    Good question. Just one minor thing, I'd use the following the end of the calendar year:

    SELECT DATEADD(DAY, -1, DATEADD(YEAR,...



    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: It's the end of the year

    Eirikur Eiriksson (1/4/2016)


    Jeff Moden (1/4/2016)


    Lynn Pettis (1/4/2016)


    Good question. Just one minor thing, I'd use the following the end of the calendar year:

    SELECT DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) +...



    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: Case heirarchy

    Post your SQL statement here, preferably with a sample of the data you have been using.



    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: Cannot Kill Process stays in KILLED/ROLLBACK status

    Sean Perkins (1/4/2016)


    I've been waiting for the process to finish for several hours now. When I first ran the kill command after seeing the SPID in rollback status, 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]

  • RE: can high number of query errors generated by monitoring tool cause 100 % CPU utilization?

    If you monitor the CPU usage when your PowerShell tool is running or is not running, you should be able to tell if your tool is causing the issue(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]

  • RE: Surface Book

    I have a Lenovo Yoga 2. I like it so much that it's pissing me off! I can't justify getting a Surface Book as long as it's working.



    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: TSQL to SELECT dimDate that are less than or equal to last factTable date

    joeshu26 (12/31/2015)


    I would like to SELECT only dates from my dimDate table that are less than or equal to the latest date in my factTable. Any syntax for this...



    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 - 121 through 135 (of 3,666 total)