Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 1,413 total)

  • Reply To: Syntax Inquiry

    The spam filter will not let you post "select *star*" which is kind of annoying on a Sql site.

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 15, 2019 at 5:29 pm

    #3671626

  • Reply To: Syntax Inquiry

    Sorry, the 1,2,3,... syntax only works in sort by in Sql Server.   Can't tell if the syntax parses because the tables aren't in my test instance.  Please try:

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 15, 2019 at 3:58 pm

    #3671597

  • Reply To: Syntax Inquiry

    These are the 5 'group by' columns in the select list:

         EnrollmentID
        ,CoveragePeriod
        ,PSPolicyTransID
       ...

    • This reply was modified 6 years, 10 months ago by Steve Collins. Reason: Put column lists in code editor

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 15, 2019 at 3:30 pm

    #3671590

  • Reply To: Will SQL Server supports Nepal Calendar

    Oh ok I've looked into a little more.  Sql does get calendar/clock time zone info from the OS (on Windows, not sure how it works on Linux).  This is a...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 9, 2019 at 11:18 am

    #3670189

  • Reply To: Performance Debate

    Is this an MVC application?  Was the sql was generated by the entity framework?

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 9, 2019 at 12:21 am

    #3670098

  • Reply To: Group by on 120 pivotted columns

    Without wading into the specifics of your situation you could use the stuff() function in combination with for xml path.

    In this code the cte is called num_expand and it creates...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 8, 2019 at 1:03 pm

    #3669884

  • Reply To: Will SQL Server supports Nepal Calendar

    Sorry, you asked if it's possible to install Sql Server with the Nepalese calendar.  Sql will inherit the time zone info from the OS it's installed on.  So if...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 8, 2019 at 12:07 pm

    #3669828

  • Reply To: Will SQL Server supports Nepal Calendar

    What happens if you run this query?

    select * from sys.time_zone_info order by 1

    In Azure Sql the 77th row is:

    Nepal Standard Time, +05:45, 0

    What happens if you run this next query?

    select...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 8, 2019 at 11:47 am

    #3669822

  • Reply To: Can't add user to db_owner role

    You're using SSMS and error says it's timing out.  What is the timeout setting in your SSMS?

    In SSMS menu go to Tools, Options, Query Execution, then General.  The 3rd item...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 7, 2019 at 11:37 pm

    #3669711

  • Reply To: Using Begin & Commit inside a Stored Procedure

    Agree try/catch is primarily for error capture.  Partial rollbacks are not common in my experience.  Sql clients could cache partial form input however they do it.

    In theory something could be...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 7, 2019 at 6:17 pm

    #3669605

  • Reply To: In-Memory OLTP - N00b Question

    Here's the list of unsupported features in MOT.  No triggers has made it not easy (and not even tried in some cases) to migrate to for some of my projects. ...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 7, 2019 at 3:31 pm

    #3669541

  • Reply To: SQL equivalent to NORM.DIST Excell function?

    mharbuz wrote:

    I was wondering how I would go about calculating the normal distribution for a number of values, specifically the Probability Density Function.

    How many data points and over what interval...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 7, 2019 at 3:19 pm

    #3669538

  • Reply To: SQL equivalent to NORM.DIST Excell function?

    Standard deviation is the square root of the variance

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 7, 2019 at 1:04 pm

    #3669482

  • Reply To: Using Begin & Commit inside a Stored Procedure

    "after several updates and inserts..."

    Maybe it's worth asking... does your procedure specify 'set xact_abort on'?  When a proc has multiple DML statement in a transaction and without xact_abort setting can...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    August 7, 2019 at 12:34 pm

    #3669458

  • Reply To: Stored Procedure code understanding

    Hi I posted this answer before but it appears to be marked as SPAM.  Not sure why.  This site has an annoying text editor.

     

    What this code is doing.

    1. Declares 3...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    July 25, 2019 at 12:51 pm

    #3666032

    • Viewing 15 posts - 1,396 through 1,410 (of 1,413 total)