Forum Replies Created

Viewing 15 posts - 976 through 990 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (9/3/2014)


    xsevensinzx (9/3/2014)


    I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions...



    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: scheduling a job

    What is the error?



    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: Variable returning * instead of an error

    Are you sure you have the right syntax?

    Select Top 1 Column_Is_an_int = @A_number from ....

    Unless I didn't get enough sleep and/or not enough coffee, this is not assigning a value...



    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: Add Analytic Services to MS SQL Server 2012 to existing installation

    Yes you can do it.

    When you run the setup, you will be asked if you want to do a new installation or modify and existing one. (I don't remember the...



    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: Need Help - SQL Select Statement

    where (t1.steps + t2.steps) IN (4,7,9) Only works for these values, in this example.



    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: How to apply same data manipulation codes to a group of SSIS components' inputs?

    Phil Parkin (8/25/2014)


    Unfortunately, the creation of 'global' functions in SSIS is not straightforward. Not a job for an SSIS newbie.

    This is my biggest disappointment 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]

  • RE: SSIS Help

    There's no simple way of doing this in the dataflow.

    One way I might do this is to create the basic flatfile as you seem to know how to do, without...



    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: How to replace a value in Bracket with negative value in ssis

    What have you done so far to learn how to use the Derived Column Transform?



    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: I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS TO SEND MAIL. PLEASE HELP ME HOW TO WRITE

    I've done something like this before, but rum manually via Excel macro.

    What I did was query MASTER.sys.Databases.

    If I got results, I knew the server was running and the results...



    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: Question about SQL Jobs<!-- 864 -->

    Also check what the Job Activity Monitor is showing for Next Run.



    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: Junk/SPAM Posts Overwhelming

    Michael Valentine Jones (8/19/2014)


    Just some ideas:

    Limit the number of forum posts to one or two per day, especially new topics, for a while, say a couple of weeks, after they...



    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: Convert Excel formula to SQL

    Should be doable, but first I need to know why you're subtracting B2 and subtracting from C2? Why not B3 and C3, or B9 and C9? What ...



    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?

    Ed Wagner (8/19/2014)


    SQLRNNR (8/19/2014)


    Luis Cazares (8/19/2014)


    Lynn Pettis (8/19/2014)


    How about this one, starting monthly salary of $4,927 for a Senior Database Developer. That's 2/3 what I made at School District...



    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: GETTING END DATES FOR HISTORY SEGMENTS

    Nilssond (8/14/2014)


    I have a customer history table with the follow structure and data:

    CustomerID Tier ...



    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: generate dynamic update statement

    Erin. (8/14/2014)


    I'm trying to generate an update statement based off select statement results. A very basic example,

    SELECT ListID FROM DListing WHERE Status = 2

    Results return 3 rows.

    1234

    2345

    3456

    How can 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]

Viewing 15 posts - 976 through 990 (of 3,666 total)