Forum Replies Created

Viewing 15 posts - 5,926 through 5,940 (of 9,707 total)

  • RE: Job Modifications

    I would agree with Suresh. I have never seen a place where you can track the changes made to a job over time.

    However, you could set up logging that tracks...

  • RE: SQL Server replication withoout Internet

    DTS doesn't exist in SQL 2005 except as a legacy hook up. I do not recommend using this.

    I'm not quite understanding your comment about no internet access. I'm not sure...

  • RE: Are the posted questions getting worse?

    WayneS (5/24/2011)


    What's up with all the old threads being resurrected lately? I've seen several this week already... 🙁

    Are they "Did you ever find a solution" resurrections, spam resurrections, or "hey,...

  • RE: Full Text Search "Contains" question

    I may be misunderstanding the CONTAINS predicate, but it seems to me that it searches for a whole word, not part of a word.

    BOL


    CONTAINS can search for:

    A word or...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (5/24/2011)


    LutzM (5/23/2011)


    Regarding the specific situation: it might be better for the person in question to officially ask for support. Try to deal with the situation "undercover" would just...

  • RE: Are the posted questions getting worse?

    GilaMonster (5/23/2011)


    Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing to give telephonic support...

  • RE: Needed: Litespeed Syntax

    Tara,

    I don't think Litespeed uses the SQL Server extended procs. I'm pretty sure they built their own.

  • RE: Combinations and Permutations

    LutzM (5/18/2011)


    GSquared (5/18/2011)


    I put in the non-repeat bit because of the way Steve wrote his original Where clause. I just moved it into the Joins.

    Gus: If this concept is...

  • RE: Combinations and Permutations

    I don't see what's wrong with allowing matching since the question was "all possible combinations". <- EDIT: I believe it was the original question in the thread Steve referenced.

    However, if...

  • RE: Combinations and Permutations

    Boys, you should be ashamed of yourselves. Jeff Moden gave us a better way.

    DECLARE @MaxTally int;

    SELECT @MaxTally = Max(ID) FROM dbo.Combinations;

    SELECT c.ID, t.N AS TallyID

    FROM dbo.Combinations c

    CROSS JOIN dbo.Tally t

    WHERE...

  • RE: Combinations and Permutations

    Steve,

    I actually have a table in an analytics database where I had to set something like this up, but the numbers are so small that I just entered them into...

  • RE: Today's Random Word!

    Ray K (5/18/2011)


    bcsims 90437 (5/17/2011)


    The seats are in right field, far away from the stick and most balls; in the 'all you can eat' section. Will have to fend...

  • RE: Are the posted questions getting worse?

    Jim Murphy (5/17/2011)


    Koen Verbeeck (5/17/2011)


    And now I've reached the 5000-points milestone.

    W00t w00t! :w00t: 😎 :hehe:

    Ahem.... Back to the tasks at hand... 😀

    Excellent! Good job helping the community.

    Wait. We're supposed...

  • RE: Are the posted questions getting worse?

    jcrawf02 (5/17/2011)


    Data Analyst job will be opening up soon where I work (not mine) in Columbus, OH. Mostly report writing, some dev work in SSRS/SSIS, rest is trending patient utilization...

  • RE: Today's Random Word!

    SQLRNNR (5/17/2011)


    Ray K (5/17/2011)


    bcsims 90437 (5/17/2011)


    Daniel Bowlin (5/17/2011)


    SQLRNNR (5/17/2011)


    crookj (5/17/2011)


    SQLRNNR (5/17/2011)


    stick

    Shift

    clutch

    hitter

    pinch

    Hmmm, should I spend $60 to take me and my dog to the Dodgers game on Bark in the Park...

Viewing 15 posts - 5,926 through 5,940 (of 9,707 total)