Forum Replies Created

Viewing 15 posts - 2,416 through 2,430 (of 8,731 total)

  • RE: Column for Table1 within subquery

    DEEPAK GUPTA-378433 (7/29/2016)

    Hello All

    How could I use Column for Table1 within subquery. I know this is not possible but there should be a nice way to achieve this.

    SELECT *

    FROM Table1...

    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

    July 29, 2016 at 8:52 am

    #1892656

  • RE: How Far Have You Traveled for a SQL Saturday?

    I've only been to 2 SQL Saturdays.

    For the first one I had to travel 130 miles (209km) to Orlando on 2012. We went to Disney World on Sunday, so we...

    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

    July 29, 2016 at 8:33 am

    #1892651

  • RE: Are the posted questions getting worse?

    TomThomson (7/28/2016)

    jasona.work (7/27/2016)

    Luis Cazares (7/27/2016)

    It's exhausting to write translated posts. I hope I'm not saying any nonsense as I'm a bit outside my common knowledge (referring to DBA tasks, not...

    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

    July 29, 2016 at 7:31 am

    #1892641

  • RE: SQL help

    So, are you good now?

    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

    July 28, 2016 at 2:05 pm

    #1892547

  • RE: SQL help

    Why does record_id 2 ends up with value 'col1' for colname?

    Have you tried using MAX() and MIN() to aggregate rows?

    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

    July 28, 2016 at 1:36 pm

    #1892544

  • RE: deleting from non updatable views

    This is interesting. I'm not sure if that's a bug or a feature. I would be inclined to call it a bug.

    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

    July 28, 2016 at 8:12 am

    #1892482

  • RE: SQL SERVER 2012 NDF, delete

    Douglas Rosa (7/27/2016)

    Tambien quisiera consultarles como podria montar o generar un informe el cual me diera el estado de salud de una instancia de sql server.

    Una de las formas más...

    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

    July 27, 2016 at 10:59 am

    #1892343

  • RE: Are the posted questions getting worse?

    It's exhausting to write translated posts. I hope I'm not saying any nonsense as I'm a bit outside my common knowledge (referring to DBA tasks, not Spanish :-D).

    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

    July 27, 2016 at 9:41 am

    #1892328

  • RE: SQL SERVER 2012 NDF, delete

    Douglas Rosa

    Hi I would like to go back to the traditional design of one mdf file and one ldf file, to be able to migrate my enterprise edition to a...

    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

    July 27, 2016 at 9:36 am

    #1892324

  • RE: GET MAX VALUE

    This is another option:

    SELECTAPPLICANTS_ID,

    APPL_CURRENT_STATUS,

    APPL_CURRENT_STATUS_DATE

    FROM APPLICANTS

    OUTER APPLY( SELECT TOP 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

    July 27, 2016 at 7:38 am

    #1892271

  • RE: GET MAX VALUE

    This is one option:

    WITH CTE AS(

    SELECTAPPLICANTS_ID,

    APPLICATIONS_OCC.APPL_CURRENT_STATUS,

    APPL_CURRENT_STATUS_DATE

    ...

    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

    July 27, 2016 at 7:35 am

    #1892269

  • RE: How to skip the file?

    The most important part. How do you define the file has junk data?

    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

    July 27, 2016 at 7:32 am

    #1892267

  • RE: sql query

    Or you could use a table with all possible values.

    Here's an example on how to create it.

    CREATE TABLE Weeks(

    WeekCode int,

    ...

    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

    July 27, 2016 at 7:28 am

    #1892266

  • RE: SQL SERVER 2012 NDF, delete

    ¿Por qué quieres poner una limitación al diseño de la base de datos? El tener distintos filegroups y archivos te permitirá tener un diseño físico más flexible y puede facilitar...

    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

    July 27, 2016 at 6:24 am

    #1892245

  • RE: Are the posted questions getting worse?

    GilaMonster (7/27/2016)

    Can someone who speaks Spanish please check the translations? http://www.sqlservercentral.com/Forums/Topic1804719-2799-1.aspx

    Your response is translated correctly. I was going to reply but I haven't reached my computer yet.

    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

    July 27, 2016 at 5:30 am

    #1892227

Viewing 15 posts - 2,416 through 2,430 (of 8,731 total)