Home Forums SQL Server 2017 SQL Server 2017 - Development Stored Procedure Help and dealing with Where Clause RE: Stored Procedure Help and dealing with Where Clause

  • February 7, 2018 at 11:57 am

    #1978941

    Cheryl McLaughlin-385812 - Wednesday, February 7, 2018 11:47 AM

    Phil
    Thanks, I think this one will work best due to what I am working with here. Performance is not an issue as these are fairly small databases and these reports are for internal use only. Again, thanks for the input. I am the only developer, so I don't have a go to person when I need a sounding board, etc lol.

    Good stuff. It struck me afterwards that it might be better to create and populate the #AssetSizes table as a permanent table. Your code could reference it in the same way as shown above & you'd be able to change the boundary values without having to change code.
    It's a lonely job being the sole developer, I don't envy that.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.