Forum Replies Created

Viewing 15 posts - 3,226 through 3,240 (of 26,490 total)

  • RE: Happy Thanksgiving 2016

    Iwas Bornready (11/28/2016)


    Yev.d (11/24/2016)


    Happy Thanksgiving to all!

    You don't have to be an American to count your blessings and be thankful. 🙂

    mjh 45389 (11/24/2016)


    t.franz (11/24/2016)


    Who do you blame for the...

  • RE: Incorrect syntax near *

    Jacob Wilkins (11/17/2016)


    Lynn Pettis (11/17/2016)


    Jacob Wilkins (11/17/2016)


    Lynn Pettis (11/17/2016)


    Jacob Wilkins (11/17/2016)


    Also, print out the value of @sql instead of trying to execute it.

    You'll see there are several syntax errors.

    One of...

  • RE: GET Counts for insert,update,delete

    And this appears to be a duplicate post.

  • RE: Incorrect syntax near *

    Jacob Wilkins (11/17/2016)


    Lynn Pettis (11/17/2016)


    Jacob Wilkins (11/17/2016)


    Also, print out the value of @sql instead of trying to execute it.

    You'll see there are several syntax errors.

    One of the main ones is...

  • RE: Incorrect syntax near *

    Slight mod to what I posted above:

    SET QUOTED_IDENTIFIER OFF;

    SET NOCOUNT ON;

    DECLARE @SQLCmd nvarchar(max),

    @SQLParm nvarchar(max),

    @LastCheckedDateTime...

  • RE: Incorrect syntax near *

    Jacob Wilkins (11/17/2016)


    Also, print out the value of @sql instead of trying to execute it.

    You'll see there are several syntax errors.

    One of the main ones is that you're trying to...

  • RE: Incorrect syntax near *

    You are looking for something like this:

    SET QUOTED_IDENTIFIER OFF;

    SET NOCOUNT ON;

    DECLARE @SQLCmd nvarchar(max),

    @SQLParm nvarchar(max),

    @LastCheckedDateTime...

  • RE: Are the posted questions getting worse?

    GilaMonster (11/16/2016)


    Lynn Pettis (11/16/2016)


    GilaMonster (11/16/2016)


    Lynn Pettis (11/16/2016)


    Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus,...

  • RE: Are the posted questions getting worse?

    GilaMonster (11/16/2016)


    Lynn Pettis (11/16/2016)


    Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus, I came in...

  • RE: Are the posted questions getting worse?

    Did he say SQL Server 2016 supports Docker?

  • RE: Are the posted questions getting worse?

    Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus, I came in late.

  • RE: Using UPDATE with ROW_NUMBER()

    paul.keohan (11/15/2016)


    I'm fairly new to SQL and have become completely stuck in trying to do this:

    I want to update a column in Table 1 where there are a number of...

  • RE: Query Question

    Advanced windowing functions, LAG/LEAD, since this appears to be a SQL Server 2014 question.

  • RE: Enterprise Edition DB not growing despite available disk space

    TheSQLGuru (11/15/2016)


    Lynn Pettis (11/15/2016)


    Or, create a new file group and file and drop and recreate the nonclustered index(es) in the new file group.

    I already suggested that as a solution but...

  • RE: Enterprise Edition DB not growing despite available disk space

    Or, create a new file group and file and drop and recreate the nonclustered index(es) in the new file group.

Viewing 15 posts - 3,226 through 3,240 (of 26,490 total)