Forum Replies Created

Viewing 15 posts - 6,676 through 6,690 (of 39,877 total)

  • RE: Update Stored Procedures

    It would help to have data, but I'd reverse this and use a CTE.


    WITH mycte
    AS
    (SELECT StockItemGenericID, StockUomID, COUNT(*) AS 'Unitcount' FROM dbo.StockItemHeader

  • RE: Looking Back

    KGERBR - Friday, July 21, 2017 10:21 AM

  • Can you imagine having to go thru all your SQL code and...

  • RE: Looking Back

    chrisn-585491 - Friday, July 21, 2017 6:59 AM

    I agree with the original article writer on many issues, mainly because I've got 35...

  • RE: Looking Back

    archie flockhart - Friday, July 21, 2017 5:28 AM

    Lots of interesting points in the article. Case sensitive variable names are one of...

  • RE: SSMS is Free

    Jeff Moden - Friday, July 21, 2017 7:56 AM

    It actually used to be part of Sp/Cu updates.  The problem with the...

  • RE: Python Delimiters

    After a month or so, I came to appreciate the whitespace. I think it makes reading much easier. Easier than finding the curly braces in C#, IMHO.

  • RE: Python Delimiters

    I would have have gotten this if I hadn't gone through a book a couple years ago.

    If anyone wants to learn more, this is how I got started: ...

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Friday, July 21, 2017 7:55 AM

    Mine will lock the door when I walk away with the fob in my...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Friday, July 21, 2017 7:22 AM

    jasona.work - Friday, July 21, 2017 6:51 AM

    July 21, 2017 at 8:07 am

    #1952100

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, July 20, 2017 2:46 PM

    No doubt it involved removing the engine and taking apart the chasis.

    LOL, not...

  • RE: Are the posted questions getting worse?

    We had a battery need replacement in the Prius. Unfortunately it's in the trunk, which needs power to open. I removed the old and a kid closed the trunk. A...

  • RE: SSMS is Free

    Sorry, Community Hub link

  • RE: SSMS is Free

    You can report this at the Redgate Community Hub forums, but I have both SSMS 2016 and SSMS v17 and both have tools from Redgate in them.

  • RE: How to load data to table from SQL Audit File

    This is a Log File format for Windows.

    There is a  function you can use.

    I might search for ways to programmatically read event...

  • RE: Set Option 'XML data' via script

    I would guess there is. Either it's in your .vsssettings file or it's in the registry.

  • Viewing 15 posts - 6,676 through 6,690 (of 39,877 total)