Forum Replies Created

Viewing 15 posts - 5,716 through 5,730 (of 8,755 total)

  • RE: Today's Random Word!

    Ed Wagner (4/7/2015)

    Eirikur Eiriksson (4/7/2015)

    djj (4/7/2015)

    Ed Wagner (4/7/2015)

    whereisSQL? (4/7/2015)

    Eirikur Eiriksson (4/7/2015)

    whereisSQL? (4/7/2015)

    Ed Wagner (4/7/2015)

    Revenant (4/7/2015)

    djj (4/7/2015)

    eccentricDBA (4/6/2015)

    Eirikur Eiriksson (4/6/2015)

    SQLRNNR (4/6/2015)

    timber

    Splinter

    Shredder

    Raphael

    Renaissance

    Knight

    Bishop

    Finger

    Salute

    Attention

    Distraction

    Details

    Summary

    Executive

    April 7, 2015 at 1:14 pm

    #1789314

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/7/2015)

    Everyone bow their head in a moment of silence.

    '14-'15 ski season is over.

    Powder?

    April 7, 2015 at 1:05 pm

    #1789308

  • RE: BULK INSERT first row

    Rune Bivrin (4/7/2015)

    I was very torn between "3" and "Not supported". Based on the following in the cited documentation, I kind of felt both were correct:

    The FIRSTROW attribute is not...

    April 7, 2015 at 1:02 pm

    #1789307

  • RE: Today's Random Word!

    djj (4/7/2015)

    Ed Wagner (4/7/2015)

    whereisSQL? (4/7/2015)

    Eirikur Eiriksson (4/7/2015)

    whereisSQL? (4/7/2015)

    Ed Wagner (4/7/2015)

    Revenant (4/7/2015)

    djj (4/7/2015)

    eccentricDBA (4/6/2015)

    Eirikur Eiriksson (4/6/2015)

    SQLRNNR (4/6/2015)

    timber

    Splinter

    Shredder

    Raphael

    Renaissance

    Knight

    Bishop

    Finger

    Salute

    Attention

    Distraction

    Details

    April 7, 2015 at 12:55 pm

    #1789304

  • RE: Today's Random Word!

    whereisSQL? (4/7/2015)

    Ed Wagner (4/7/2015)

    Revenant (4/7/2015)

    djj (4/7/2015)

    eccentricDBA (4/6/2015)

    Eirikur Eiriksson (4/6/2015)

    SQLRNNR (4/6/2015)

    timber

    Splinter

    Shredder

    Raphael

    Renaissance

    Knight

    Bishop

    Finger

    April 7, 2015 at 11:57 am

    #1789280

  • RE: Your Cloud Held Hostage – Could It Happen?

    Eric M Russell (4/7/2015)

    If you have some slush money left over in your disaster recovery planning budget, you can play off the fear of executive management by blocking off an...

    April 7, 2015 at 9:04 am

    #1789222

  • RE: SSIS and OLE DB depreciation

    JustMarie (4/7/2015)

    I searched for this on the site and didn't find anything specific to the change so I thought I would ask. If there is a discussion feel free...

    April 7, 2015 at 9:00 am

    #1789221

  • RE: Showing decimal places

    BOR15K (4/7/2015)

    I would use CHARINDEX

    WITH myString AS (

    SELECT '001' AS num

    UNION ALL

    SELECT '002' AS num

    UNION ALL

    SELECT '003' AS num

    UNION ALL

    SELECT '001.' AS num

    UNION ALL

    SELECT '004' AS num

    UNION ALL

    SELECT '002.' AS...

    April 7, 2015 at 8:58 am

    #1789217

  • RE: Help with arithmetic formula to "stuff" digits

    Luis Cazares (4/7/2015)

    Thank you both for your solutions.

    I would be careful using my version if the initial number of digits goes below 5 but hey! you can figure that one...

    April 7, 2015 at 8:53 am

    #1789216

  • RE: Correlated query to INNER JOIN or Window function

    sql-lover (4/2/2015)

    Eirikur Eiriksson (4/1/2015)

    You can use the free version of SQL Sentry Plan Explorer to obfuscate it.

    😎

    I've been using it for several years now, it does not allow you that,...

    April 7, 2015 at 1:41 am

    #1789113

  • RE: Get the Recent changed value from History Table

    Quick, simple and quite efficient solution

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    IF OBJECT_ID(N'dbo.History') IS NOT NULL DROP TABLE dbo.History;

    CREATE TABLE dbo.History (SnapShotDate DATETIME, UID VARCHAR(10), DUEDATE DATETIME)

    INSERT INTO dbo.History VALUES ('03-23-2015','PT-01','2015-04-22')

    INSERT INTO dbo.History...

    April 7, 2015 at 1:30 am

    #1789110

  • RE: Get the Recent changed value from History Table

    Use MAX(DATE) and GROUP BY (ID)

    😎

    April 6, 2015 at 11:30 pm

    #1789095

  • RE: Supress Results from running a DTS Package via xp_cmdShell within a Stored Procedure

    Quick suggestion, declare a table variable and do an insert-exec, the output of the exec goes in the variable, then discard it.

    😎

    April 6, 2015 at 11:27 pm

    #1789094

  • RE: Restore Fails on Standard Edition - statistics

    JoshDBGuy (4/6/2015)

    Grant Fritchey (4/5/2015)

    Jeff Moden (4/4/2015)

    krypto69 (4/4/2015)

    Grant Fritchey (4/4/2015)

    If the partitioning is working for your in production and you're actually using it, removing it doesn't make a lot of sense....

    April 6, 2015 at 2:24 pm

    #1789060

  • RE: Today's Random Word!

    SQLRNNR (4/6/2015)

    timber

    Splinter

    April 6, 2015 at 1:50 pm

    #1789052

Viewing 15 posts - 5,716 through 5,730 (of 8,755 total)