Forum Replies Created

Viewing 15 posts - 2,191 through 2,205 (of 2,917 total)

  • Reply To: Group Numbering

    That is true.  I suppose then it all depends on what you define as a "sequence".  If having the "Sequence ID" reset itself is a common occurrence, AND if resetting...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    June 24, 2019 at 8:44 pm

    #3657145

  • Reply To: Group Numbering

    To avoid the "0" and negative problem, change it from using the sequence number to using the event record ID.  In the example you have above, it looks like that...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    June 14, 2019 at 9:52 pm

    #3653990

  • Reply To: I Need a Good App Development Company to work with

    I think it depends on what you want in the app.  If you are looking for an app that will load a web page in a specialized frame that prevents...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    June 14, 2019 at 9:09 pm

    #3653974

  • Reply To: Upgraded from SQL Server 2008r2 to SQL Server 2016 sp2 application timeouts

    You could try turning on the legacy cardinality estimator.  It'll almost be like running it without doing the upgrade unfortunately, but might be able to narrow things down a bit.

    Since...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    June 13, 2019 at 9:40 pm

    #3653528

  • Reply To: Upgraded from SQL Server 2008r2 to SQL Server 2016 sp2 application timeouts

    My opinion, that is one of those "it depends" problems.  Is the timeout in code execution OR is the timeout in the connection?

    If the timeout is in code execution, do...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    June 12, 2019 at 7:33 pm

    #3652924

  • Reply To: best way to store values with different numbers of columns in a single table

    I think in this case "best" is a relative term.

    There are several ways to do it.  long character separated string values, key value pairs, very wide tables with non-descript column...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    June 12, 2019 at 7:22 pm

    #3652919

  • Reply To: if/then or case return?

    It depends entirely on the language you are working with.  As this is SQL Server Central, I am assuming you are working in SQL Server.

    The way I would do this...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    June 7, 2019 at 7:31 pm

    #3651161

  • Reply To: denied on the object 'databases', database 'mssqlsystemresource', schema 'sys'

    As a thought... I wonder if MAYBE the user is a member of a group that has deny permissions on a system object but you also granted the permissions explicitly.

    What...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    June 6, 2019 at 5:21 pm

    #3650833

  • Reply To: Service Broker Queues

    We use it to transfer realtime data from one system to another.  Mostly as a way to break reliance on linked servers where possible.

    We pull data from system X into...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    May 31, 2019 at 9:54 pm

    #3649192

  • Reply To: XML Query Help

    how about this:

    CAST(xmldata.value('(ns8:date)[1]','DATETIMEOFFSET') AS DATE) AS RDATE

    Basically get the value in it's original format (DATETIMEOFFSET) and then cast that to a DATE.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    May 31, 2019 at 9:15 pm

    #3649184

  • Reply To: sp_MSforeachDB

    You are missing an "END" after your BEGIN.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    May 28, 2019 at 7:21 pm

    #3648014

  • Reply To: Dynamic query based of business rules

    Putting in the restriction on delete isn't a bad idea, but depending on the permissions the user is granted, it may not be enough.  what if they drop that trigger? ...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    May 24, 2019 at 6:16 pm

    #3647085

  • Reply To: Dynamic query based of business rules

    I should add that there is a little bit of risk with SQL injection depending on what is in the code.

    For example, the Query that is being executed is:

    The above is all just my opinion on what you should do. 
    
As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    May 24, 2019 at 3:51 pm

    #3647033

  • Reply To: Dynamic query based of business rules

    This may not be the most elegant solution, but I believe it should work for you.  Just need to un-comment the EXEC(@SQLCMD) line:

    DECLARE @SQLCMD VARCHAR(MAX) = '';
    DECLARE...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    May 23, 2019 at 8:55 pm

    #3646676

  • Reply To: Stored Procedure to encrypt from VBA

    Quick fix:

    In the line "SET @SQLQuery", try casting your @intID to an NVARCHAR(255).

    EDIT - re-read your post and I see you tried this already.  Is it giving the same error...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    May 23, 2019 at 3:20 pm

    #3646557

    • Viewing 15 posts - 2,191 through 2,205 (of 2,917 total)