Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 8,731 total)

  • RE: Date Question

    Jason Toews - Wednesday, August 30, 2017 8:35 AM

    In the following code I was expecting the Minutes from the base date but...

    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

    August 30, 2017 at 10:27 am

    #1957511

  • RE: The Offensive Line

    Sean Lange - Wednesday, August 30, 2017 7:31 AM

    Koen Verbeeck - Wednesday, August 30, 2017 1:14 AM

    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

    August 30, 2017 at 10:10 am

    #1957506

  • RE: Help me with the SQL syntax

    mw112009 - Monday, August 28, 2017 9:47 AM

    Good Day!
    What I need is a SQL syntax that will display the start and end...

    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

    August 28, 2017 at 10:12 am

    #1957119

  • RE: Finding Consecutive Values For a Record

    RonMexico - Monday, August 28, 2017 9:53 AM

    Thanks for the help, Luis and SQLGuru!  That does exactly what I need it 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

    August 28, 2017 at 9:59 am

    #1957116

  • RE: Finding Consecutive Values For a Record

    Here's the simplest option if the table is already like this:

    SELECT ID,
      CASE WHEN [2017_07] > 0 THEN 0
       WHEN [2017_06] > 0 THEN 1

    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

    August 28, 2017 at 9:11 am

    #1957107

  • RE: Finding Consecutive Values For a Record

    RonMexico - Monday, August 28, 2017 8:37 AM

    I have a table that shows if a record has a value for each month. ...

    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

    August 28, 2017 at 8:49 am

    #1957098

  • RE: Column name assignment

    Sean Lange - Monday, August 28, 2017 7:27 AM

    RonKyle - Monday, August 28, 2017 7:15 AM

    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

    August 28, 2017 at 7:42 am

    #1957083

  • RE: Are the posted questions getting worse?

    Sean Lange - Friday, August 25, 2017 11:54 AM

    Boy the forums are getting buggier all the time. I have had several notifications...

    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

    August 25, 2017 at 11:59 am

    #1956917

  • RE: Delete Extended Events file

    Thank you for the good ideas. Sure, exceptions can be made and this will be used by DBAs (or selected developers), the problem is that we're development DBAs 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

    August 25, 2017 at 11:56 am

    #1956916

  • RE: Delete Extended Events file

    Brandie Tarvin - Friday, August 25, 2017 10:50 AM

    It depends. Do you have access to xp_cmdshell?

    I don't, they claim is...

    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

    August 25, 2017 at 11:03 am

    #1956897

  • RE: Are the posted questions getting worse?

    I know it's Friday, but can someone give me a hint here?
    https://www.sqlservercentral.com/Forums/1893830/Delete-Extended-Events-file

    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

    August 25, 2017 at 10:43 am

    #1956891

  • RE: Looping Challege

    calvin.clay - Friday, August 25, 2017 9:27 AM

    Hi,
    I have an interesting project.  I need to show materials that make up parts then...

    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

    August 25, 2017 at 10:17 am

    #1956888

  • RE: Help on Writing multiple steps query

    Chris Harshman - Monday, August 21, 2017 1:01 PM

    EDIT: second time today someone beat me to it 😛

    I just got...

    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

    August 21, 2017 at 1:14 pm

    #1956052

  • RE: Help on Writing multiple steps query

    Maybe something like this? It considers that the only values for the char(1) columns are Y or N.

    WITH CTE AS(
      SELECT m.ID, d.Group_Num, ROW_NUMBER() OVER(...

    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

    August 21, 2017 at 12:59 pm

    #1956047

  • RE: SQL Crossword 2 SELECT Keywords

    tabinsc - Friday, August 18, 2017 7:29 AM

    Did the key to this ever get published?  Maybe it has but I don't see...

    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

    August 18, 2017 at 7:36 am

    #1955832

Viewing 15 posts - 1,006 through 1,020 (of 8,731 total)