Forum Replies Created

Viewing 15 posts - 3,466 through 3,480 (of 8,731 total)

  • RE: Compare Distinct from two queries

    There's an issue when using NOT IN and the inner query returns a NULL value. In that case, it won't return any rows. You can correct that adding an additional...

    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

    January 28, 2016 at 11:38 am

    #1855042

  • RE: TECHNICAL QUESTION on TRUNCATING and DELETING

    Every change is logged in the transaction logged. That allows point-in-time restores and rollbacks.

    CREATE TABLE rollbacktest( id int);

    INSERT INTO rollbacktest

    SELECT database_id FROM sys.databases;

    BEGIN TRAN;

    TRUNCATE TABLE rollbacktest;

    DROP TABLE rollbacktest;

    ROLLBACK TRAN;

    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

    January 28, 2016 at 11:25 am

    #1855039

  • RE: Transform Rows to columns with out using PIVOT

    sqlfriends@sql.com (1/28/2016)

    Hi Team,

    I have the below requirement my table has the below data

    TABLENAME - SOURCE

    EMPID ENAME DEPARMENT

    1 XXX ...

    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

    January 28, 2016 at 11:14 am

    #1855034

  • RE: Find Valid Date from String

    This might be overkill, but storing a table with valid date formats could work. You can simplify the list or increase it as needed. You could even store lengths 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

    January 28, 2016 at 11:08 am

    #1855032

  • RE: Display only first row in SQL

    That should be done in the front end, otherwise you risk the possibility of reordering the rows and losing any way of defining which job relates to which invoice.

    Here's 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

    January 27, 2016 at 2:37 pm

    #1854826

  • RE: Easy puzzle, complicated query

    You should try to search for articles about the problems defined as "gaps and islands". There are plenty of them on the internet which might help you to understand 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

    January 27, 2016 at 1:58 pm

    #1854818

  • RE: Grouping does not seem to be working with Union ALL

    mjakachira (1/27/2016)

    Tried that and it didn't like the syntax. Going to keep trying I think i get it but any ideas?

    Also when I just use UNION it does the same...

    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

    January 27, 2016 at 9:25 am

    #1854760

  • RE: Multiple queries in the same stored procedure

    ScottPletcher (1/26/2016)

    Luis Cazares (1/26/2016)

    Manic Star (1/26/2016)

    So we had a development. An SQL MVP at days of .Net told our devs that their beloved UberQueries were ok since the QA cached...

    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

    January 26, 2016 at 6:33 pm

    #1854590

  • RE: Multiple queries in the same stored procedure

    Manic Star (1/26/2016)

    So we had a development. An SQL MVP at days of .Net told our devs that their beloved UberQueries were ok since the QA cached the plans at...

    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

    January 26, 2016 at 12:23 pm

    #1854525

  • RE: ***SPOILER FREE*** Star Wars: The Force Awakens

    Eric M Russell (1/26/2016)

    Luis Cazares (1/26/2016)

    Eric M Russell (1/25/2016)

    Luis Cazares (1/6/2016)

    chrisn-585491 (1/6/2016)

    http://www.computerworld.com/article/2915904/it-outsourcing/fury-rises-at-disney-over-use-of-foreign-workers.html

    Unfortunately, they're hiring people from India instead of the southern neighbors. However, I always remember a meme about 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

    January 26, 2016 at 12:09 pm

    #1854519

  • RE: ***SPOILER FREE*** Star Wars: The Force Awakens

    Eric M Russell (1/25/2016)

    Luis Cazares (1/6/2016)

    chrisn-585491 (1/6/2016)

    http://www.computerworld.com/article/2915904/it-outsourcing/fury-rises-at-disney-over-use-of-foreign-workers.html

    Unfortunately, they're hiring people from India instead of the southern neighbors. However, I always remember a meme about this: http://i.imgur.com/shDmF0L.jpg

    I hope I don't offend...

    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

    January 26, 2016 at 8:19 am

    #1854451

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/26/2016)

    TomThomson (1/25/2016)

    GilaMonster (1/25/2016)

    Bandwidth, latency and data out of the country (for 1 and 3)

    I see the same. Plus in the EU it's probably illegal to host 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

    January 26, 2016 at 6:14 am

    #1854411

  • RE: Are the posted questions getting worse?

    Ed Wagner (1/25/2016)

    Hugo Kornelis (1/25/2016)

    Ed Wagner (1/24/2016)

    jonathan.crawford (1/23/2016)

    Uh, how does one go Hand-To-Hand, exactly? Were you cramming pellets down someone's throat? I can also envision you sneaking around with...

    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

    January 25, 2016 at 3:20 pm

    #1854319

  • RE: Today's Random Word!

    SQLRNNR (1/25/2016)

    Sciuto

    prosciutto

    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

    January 25, 2016 at 1:57 pm

    #1854291

  • RE: Striped backups and cursor

    Would something like this work for you? I'm removing the loop and using a different method to concatenate as explained in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    SET ANSI_NULLS ON

    SET QUOTED_IDENTIFIER ON

    SET NOCOUNT ON

    declare@command...

    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

    January 25, 2016 at 11:45 am

    #1854256

Viewing 15 posts - 3,466 through 3,480 (of 8,731 total)