Forum Replies Created

Viewing 15 posts - 181 through 195 (of 471 total)

  • RE: Sorting triggered by data type

    Interesting question which provoked a good discussion.

    December 13, 2011 at 8:50 am

    #1420682

  • RE: Maximum number of Databases.

    Ninja's_RGR'us (12/8/2011)

    Make sure to put them all on auto close & autoshrink.

    Then start foreachdb and check stuff in them :hehe:

    I like where this is headed.

    December 8, 2011 at 1:51 pm

    #1418959

  • RE: DATETIME 1

    ma-516002 (12/7/2011)

    Great question, but the answer is language dependant since outside the us at first glance '01-08-2011' reads 1st of August 😉

    Yes, this is a lesson we learn quite quickly...

    December 7, 2011 at 8:12 am

    #1418122

  • RE: Table space usage 3

    Great question, thanks Hugo.

    December 2, 2011 at 7:41 am

    #1415890

  • RE: Delete duplicate row

    Jpotucek (11/18/2011)

    Thank you one and all.. time to put on my Quincy lab coat and go do some investigating on 'cte's 😀

    I remember Quincy, but I...

    November 18, 2011 at 12:32 pm

    #1410150

  • RE: Delete duplicate row

    SKYBVI (11/18/2011)

    Cliff Jones (11/18/2011)

    SKYBVI (11/18/2011)

    ;WITH cte

    AS (SELECT ROW_NUMBER() OVER (PARTITION BY Col1, Col2

    --add all column names col1,col2,...

    ORDER BY ( SELECT 0)) RN

    FROM table)

    DELETE FROM cte

    WHERE RN > 1

    Regards,

    Sushant

    Yes Sushant, I...

    November 18, 2011 at 12:27 pm

    #1410142

  • RE: Delete duplicate row

    Jpotucek (11/18/2011)

    Thank you!!!

    I ran this and it worked:

    ;WITH cte

    AS (SELECT ROW_NUMBER() OVER (PARTITION BY path, sortOrder,id, repname, repfilepath, language_cd, updateddate, repFormat

    --add all column names col1,col2,...

    ORDER BY ( SELECT 0)) RN

    FROM...

    November 18, 2011 at 12:15 pm

    #1410132

  • RE: Delete duplicate row

    Jpotucek (11/18/2011)

    not sure what ;WITH cte means..

    but I tried this:

    Select * (SELECT ROW_NUMBER() OVER (PARTITION BY path, sortOrder,id, repname, repfilepath, language_cd, updateddate, repFormat

    --add all column names col1,col2,...

    ORDER...

    November 18, 2011 at 12:13 pm

    #1410128

  • RE: Delete duplicate row

    SKYBVI (11/18/2011)

    ;WITH cte

    AS (SELECT ROW_NUMBER() OVER (PARTITION BY Col1, Col2

    --add all column names col1,col2,...

    ORDER BY ( SELECT 0)) RN

    FROM table)

    DELETE FROM cte

    WHERE RN > 1

    Regards,

    Sushant

    Yes Sushant, I was just about...

    November 18, 2011 at 12:07 pm

    #1410122

  • RE: Use of DATETIME and BETWEEN - Part 2

    Good question, thanks.

    November 18, 2011 at 8:18 am

    #1409947

  • RE: Table space usage 1

    jeff.mason (11/9/2011)

    Yeah, in my case I am so used to the indexes being created as a part of making the foreign key that I failed to notice that they weren't...

    November 9, 2011 at 9:41 am

    #1405328

  • RE: Triggers

    mbova407 (11/2/2011)

    Yeah... one point... now two with this post.

    That's the spirit!

    November 2, 2011 at 7:42 am

    #1402131

  • RE: Collation and SQL_VARIANT

    Very interesting question.

    November 1, 2011 at 7:41 am

    #1401607

  • RE: SQL Server Code name

    Is this going to be on the test?

    October 31, 2011 at 8:40 am

    #1401109

  • RE: Query Plan Execution Order

    Great question and explanation. I answered a little too quickly.

    October 27, 2011 at 7:35 am

    #1400143

Viewing 15 posts - 181 through 195 (of 471 total)