Forum Replies Created

Viewing 15 posts - 2,971 through 2,985 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Wonder if I should answer: "Using INSERT statements"

    http://www.sqlservercentral.com/Forums/Topic1781117-1550-1.aspx

    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

    April 26, 2016 at 12:37 pm

    #1874756

  • RE: Today's Random Word!

    Ray K (4/26/2016)

    Ed Wagner (4/26/2016)

    Song

    Music

    Sound

    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

    April 26, 2016 at 12:15 pm

    #1874745

  • RE: Are the posted questions getting worse?

    Episode VII is too dependent on nostalgia. Most of us were there to see what happened with beloved characters from the original trilogy and identified lots of similarities with 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

    April 26, 2016 at 12:15 pm

    #1874744

  • RE: Sum with Isnull

    Jacob Wilkins (4/26/2016)

    John Mitchell-245523 (4/26/2016)

    Steve Jones - SSC Editor (4/26/2016)

    Phil Parkin (4/26/2016)

    As a general rule, it's better to put IsNulls inside Sums rather than outside. This avoids the warning message...

    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

    April 26, 2016 at 9:58 am

    #1874686

  • RE: sql query issue

    You might need to use a recursive CTE if you can nest more than one level.

    WITH postmeta AS(

    SELECT *

    FROM #postmeta

    ...

    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

    April 26, 2016 at 9:50 am

    #1874682

  • RE: sql query issue

    Are you able to change your database design? This design will give you nightmares and will also cause poor performance. Please consider this before building additional functionality on this system....

    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

    April 26, 2016 at 9:35 am

    #1874678

  • RE: @TrumpDBA!

    Jeff Moden (4/25/2016)

    Oddly enough, March 6th is Michelangelo's birthday. Remember that virus back in the '80s?

    I remember that I was born in the 80's 😀

    I only remember the Friday...

    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

    April 26, 2016 at 7:59 am

    #1874625

  • RE: Sum with Isnull

    Does this gets you what you need?

    SELECT

    QueryID,

    DatasetID,

    ISNULL (SUM(mm.XMLResults.value ('(./MM)[1]','varchar(100)')),0) AS MEDICAL_MM

    FROM OVT_RESULTS

    CROSS APPLY...

    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

    April 26, 2016 at 7:40 am

    #1874612

  • RE: Pulling all object name alone form various Queries

    What happens when there's the name of an object but it's not referencing the object? Or when it's commented?

    Getting object names is easy. Validating that the objects are actually used...

    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

    April 26, 2016 at 7:07 am

    #1874575

  • RE: Automate data script generation.

    ishaan99 (4/26/2016)

    Theres dependency on DBA team to get the database restored to point of time recovery. Turnaround time could be slow , as a result I m looking for...

    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

    April 26, 2016 at 7:01 am

    #1874569

  • RE: Is there any free versions for BI tools?

    For more news, you could also go to the source. http://www.microsoft.com/SQLServer?

    An interesting place to get news about SQL Server along with events and training (mostly free) is http://www.sqlpass.org/

    There are lots...

    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

    April 26, 2016 at 6:49 am

    #1874559

  • RE: Just fetches one record in 10 lakhs

    If CROSS APPLY option is too slow (as I understood from the previous post) you could try this one:

    SELECT DISTINCT

    S.SiteNumber,

    PA.ID,

    ...

    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

    April 26, 2016 at 6:43 am

    #1874557

  • RE: Help me in executing this CASE Statement

    Wild shot in the dark.

    SELECT

    FromDate,

    enddate,

    Shift,

    ShiftType

    FROM dbo.ShiftScheduler

    WHERE EndDate BETWEEN '20160401' AND...

    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

    April 26, 2016 at 6:30 am

    #1874550

  • RE: Automate data script generation.

    ishaan99 (4/25/2016)

    How do I automate a process which will

    a) select all tables from my database. some tables have auto identity columns.

    b) generate insert script that will turn on/off identities and...

    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

    April 25, 2016 at 1:02 pm

    #1874350

  • RE: Are the posted questions getting worse?

    TomThomson (4/25/2016)

    Luis Cazares (4/25/2016)

    In Mexico is common to say that "his hamster went on vacations".

    I've just got to remember to try that next time I'm in P del C! :-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

    April 25, 2016 at 11:55 am

    #1874330

Viewing 15 posts - 2,971 through 2,985 (of 8,731 total)