Forum Replies Created

Viewing 15 posts - 6,241 through 6,255 (of 8,731 total)

  • RE: The Last Line of Defense

    I agree with most people on avoiding being the single person that knows everything and the ultimate problem solver.

    However, I would like to encourage another point of view. You should...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 17, 2014 at 10:49 am

    #1722410

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/17/2014)

    Okay, now that's just plain weird. I've never seen that one before. I wonder...if you get the two windows logged in under a different account, which...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 17, 2014 at 10:22 am

    #1722397

  • RE: Are the posted questions getting worse?

    I'm not sure what happened in here :w00t:

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 17, 2014 at 9:43 am

    #1722372

  • RE: EXISTS Subqueries: SELECT 1 vs. SELECT * (Database Weekly 11.02.2008)

    Eugene Elutin (6/17/2014)

    Luis Cazares (6/17/2014)

    Would a post from Gail's blog help?

    To TOP or not to TOP an EXISTS[/url]

    Sorry Luis, help with what?

    First of all it is a bit different...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 17, 2014 at 8:37 am

    #1722348

  • RE: EXISTS Subqueries: SELECT 1 vs. SELECT * (Database Weekly 11.02.2008)

    Would a post from Gail's blog help?

    To TOP or not to TOP an EXISTS[/url]

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 17, 2014 at 8:10 am

    #1722333

  • RE: How to join to a comma delimited list

    You might be looking for something like this:

    http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    Read the article and ask any questions that you might have.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 16, 2014 at 2:31 pm

    #1722099

  • RE: Are the posted questions getting worse?

    Sean Lange (6/16/2014)

    We seem to have totally our website to spammers with links to streaming. Hope there is somebody around who can stop this nonsense.

    Is this a signal to stop...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 16, 2014 at 11:39 am

    #1722054

  • RE: Select within a time interval within a date range

    Nice work Chris,

    I would make a small modification because it's losing values from the last day.

    ;WITH RecordedMsgs (CallDate, Extension, CallerID, CalledID) AS (

    SELECT '2011-12-04 01:59:59.999', 'night', 1, 20 UNION ALL

    SELECT...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 16, 2014 at 8:33 am

    #1721975

  • RE: Are the posted questions getting worse?

    David Burrows (6/16/2014)

    Sean Lange (6/16/2014)

    ...a few technological advances (like goal line technology).

    Except that in one match already, with two different views of the goal line, one clearly showed no...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 16, 2014 at 8:07 am

    #1721958

  • RE: Tricky SUM(C1) OVER.. with extra selection? is it possible.

    Maybe something simple as this:

    SELECT a.custID,

    SUM(CASE WHEN MM BETWEEN 1 AND 3 THEN Amt END) SumQ1 ,

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 16, 2014 at 6:59 am

    #1721935

  • RE: Are the posted questions getting worse?

    Sean Lange (6/13/2014)

    GilaMonster (6/13/2014)

    I hate soccer season.

    hehe soccer isn't really a season per se. Especially those of us in the U.S. We have MLS in the summer and all the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 13, 2014 at 12:33 pm

    #1721632

  • RE: Inner Cursor Error

    You're using more variables than the ones declared. It should be more like this:

    EXEC sp_executesql @SQL, N'@aId nvarchar(50) output, @dId nvarchar(50), @dStatusId nvarchar(50)',@aId output, @dId, @dStatusId;

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 13, 2014 at 12:24 pm

    #1721625

  • RE: Validation of a Parent - Child relationship

    Thinking again, I might suggest a trigger approach on the case that you can soft-delete contracts with out soft-deleting the organisation. Using the FK approach, you wouldn't be able to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 13, 2014 at 12:16 pm

    #1721618

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/13/2014)

    The Dixie Flatline (6/13/2014)

    Sean Lange (6/13/2014)

    I hope I don't have to avoid SSC for the next month so I don't hear scores before I am able to watch the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 13, 2014 at 12:11 pm

    #1721614

  • RE: Inner Cursor Error

    Kuzey (6/13/2014)

    Hello,

    I have been using dynamic sql in an inner cursor and I get an error about the fetched variable of the outer cursor. How can I fix it?

    And the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 13, 2014 at 12:04 pm

    #1721608

Viewing 15 posts - 6,241 through 6,255 (of 8,731 total)