Forum Replies Created

Viewing 15 posts - 31 through 45 (of 276 total)

  • Reply To: Date to record zero balance for an account version

    Props to Drew. Was hoping I had kicked ass on this one, but not quite. Damn.

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    April 10, 2019 at 9:51 pm

    #3100622

  • Reply To: Option to use old forums?

    I'm feeling really heartbroken by the new site. This is one of the most sacred places on the Internet to me, and this feels like a significant loss. The new...

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    April 10, 2019 at 9:36 pm

    #3100286

  • Reply To: Date to record zero balance for an account version

    GAWD the new formatting on this site is AWFUL. Can someone please change it back? It's practically unreadable. 🙁

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    April 10, 2019 at 6:46 pm

    #3096913

  • Reply To: Date to record zero balance for an account version 

    -- Drop target scratch table if it already exists:
    IF OBJECT_ID('tempdb..#OPCantBeBothered') IS NOT NULL
    DROP TABLE #OPCantBeBothered
    ;

    -- Create scratch table:
    CREATE TABLE #OPCantBeBothered
    (
    AccountNo INT, 
    VersionNo INT, 
    Amount INT, 
    StatusDate DATE
    )
    ;

    INSERT...

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    April 10, 2019 at 6:41 pm

    #3096814

  • RE: Building Better Stored Procedures

    Andy Warren - Thursday, March 14, 2019 9:32 AM

    Create or alter: https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/11/17/create-or-alter-another-great-language-enhancement-in-sql-server-2016-sp1/.

    Thanks, I didn't find that with a quick google search,...

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    March 14, 2019 at 9:38 am

    #2024467

  • RE: Building Better Stored Procedures

    Are you saying there is literally a "CREATE OR ALTER" feature? Or are you just using that name informally? The code examples you gave in the screenshot below appear to...

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    March 14, 2019 at 9:18 am

    #2024461

  • RE: Getting results from two table and do calculations

    I've never actually used the Time datatype before, which is what it looks like you are using for OrderLine.duration. Based on my testing, it seems like the following should work...

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    February 28, 2019 at 3:01 pm

    #2023248

  • RE: WHERE Clause exclusions, best practices.

    Seems like it might be worth considering dumping the filtered data into its own tables as part of a daily process or something. And then querying those tables.

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    February 28, 2019 at 2:25 pm

    #2023243

  • RE: Which index will perform better

    Jeff Moden - Tuesday, January 15, 2019 7:27 AM

    ...I also wouldn't do a direct delete.  Instead, I'd do a search for...

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    January 17, 2019 at 11:01 am

    #2019240

  • RE: adding each row incremental

    Not sure this is 100% relevant to your issue or not, but you might also want to check out SUM...
    https://docs.microsoft.com/en-us/sql/t-sql/functions/sum-transact-sql?view=sql-server-2017

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    December 11, 2018 at 3:45 pm

    #2016038

  • RE: Sql injection

    Amen! Glad someone found a hack. I knew it was just a matter of time! 🙂 Now we just await the OP's coworkers' defensive and dismissive replies... lol

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

    November 30, 2018 at 5:58 pm

    #2015189

    • Viewing 15 posts - 31 through 45 (of 276 total)