Forum Replies Created

Viewing 15 posts - 3,331 through 3,345 (of 8,731 total)

  • RE: Display numeric as empty string based on condition

    You might want to reduce your varchar length. I've never heard of a common use for such large numbers.

    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

    February 17, 2016 at 10:11 am

    #1859313

  • RE: Similar trainings to SQL Saturday?

    Oracle organizes certain free events. You might find some information in http://www.oracle.com/technetwork

    Those include Oracle database, MySQL, Java and probably other Oracle products.

    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

    February 17, 2016 at 10:07 am

    #1859312

  • RE: Sub query where clause returns nothing

    The max lotjob for the groups of [StockCode], [SalesOrder], [SalesOrderLine] might not be the same that the one in your filter.

    In the first query, you're returning all the groups that...

    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

    February 17, 2016 at 9:33 am

    #1859299

  • RE: Display numeric as empty string based on condition

    You can use a CASE statement for that. Remember that a column can only have one type, so if you want to return an empty string, you need to return...

    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

    February 17, 2016 at 9:25 am

    #1859291

  • RE: SQL Performance Elevenses

    Just one comment on number 10

    Elegant SQL often boils down to the same query plan as awkward-looking SQL. Don't be fooled into believing you can make SQL queries run faster...

    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

    February 17, 2016 at 8:38 am

    #1859278

  • RE: Are the posted questions getting worse?

    jasona.work (2/17/2016)

    SQLRNNR (2/16/2016)

    Luis Cazares (2/16/2016)

    SQLRNNR (2/16/2016)

    Sean Lange (2/16/2016)

    Luis Cazares (2/16/2016)

    Sean Lange (2/16/2016)

    Luis Cazares (2/16/2016)

    I might have lost my composure in my last reply.

    I wonder if Java developers go 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

    February 17, 2016 at 7:25 am

    #1859252

  • RE: ROW_NUMBER() function with a difference

    I'm just curious to know what's wrong with the solution that I posted.

    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

    February 17, 2016 at 7:22 am

    #1859250

  • RE: Return multiple values in a one column preformatted string

    Alan.B (2/16/2016)

    If there is a possibility that OccurrenceTypeName will contain any of what SQL Server considers XML characters (e.g. CHAR(1) through CHAR(32), CHAR(38), CHAR(60) or CHAR(62)) then you would make...

    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

    February 17, 2016 at 5:38 am

    #1859222

  • RE: SQL Query to Extract after 2nd - in a field

    Alan.B (2/16/2016)

    and most people helping on forums aren't being paid

    Huh?!?! I just thought my SSC paycheck was really late. Aw man!

    Maybe you haven't done the correct posts. I've just been...

    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

    February 16, 2016 at 9:30 pm

    #1859166

  • RE: Are the posted questions getting worse?

    SQLRNNR (2/16/2016)

    Sean Lange (2/16/2016)

    Luis Cazares (2/16/2016)

    Sean Lange (2/16/2016)

    Luis Cazares (2/16/2016)

    I might have lost my composure in my last reply.

    I wonder if Java developers go to C# forums and 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

    February 16, 2016 at 3:37 pm

    #1859139

  • RE: Are the posted questions getting worse?

    Sean Lange (2/16/2016)

    Luis Cazares (2/16/2016)

    I might have lost my composure in my last reply.

    I wonder if Java developers go to C# forums and then say that the provided code...

    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

    February 16, 2016 at 3:03 pm

    #1859126

  • RE: Are the posted questions getting worse?

    I might have lost my composure in my last reply.

    I wonder if Java developers go to C# forums and then say that the provided code didn't work.

    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

    February 16, 2016 at 2:47 pm

    #1859122

  • RE: SQL Query to Extract after 2nd - in a field

    trvlbabie (2/16/2016)

    I'm new to this so I wasn't sure - appreciate that you were so patient and helpful...not.

    I'll give you some advice since you say that your new to this....

    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

    February 16, 2016 at 2:39 pm

    #1859121

  • RE: Return multiple values in a one column preformatted string

    This article might be what you're looking for:

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

    Here's an example based on that article:

    SELECT

    ot.Occurrence_ID,

    ot.OccurrenceName,

    STUFF( (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

    February 16, 2016 at 1:33 pm

    #1859101

  • RE: Disabled job notification

    Chitown (2/16/2016)

    We have a job which runs daily at 8 AM in the morning but sometimes, the job is disabled and for days I don't get notifications and I assume...

    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

    February 16, 2016 at 12:41 pm

    #1859077

Viewing 15 posts - 3,331 through 3,345 (of 8,731 total)