Forum Replies Created

Viewing 15 posts - 31 through 45 (of 1,414 total)

  • Reply To: Is there an ISERROR equivalent in SS?

    water490 wrote:

    How do I code "calc1 has error"?  The above code is part of a larger code where results results are passed up from sub-query to parent query so...

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

    May 24, 2025 at 10:18 pm

    #4596893

  • Reply To: New lightweight pure‑T‑SQL unit‑testing framework (T‑TEST) — feedback welcome

    Very nice.  The chess app is interesting too.  Could you explain the project structure of the chess app a little more?  There appears to be more than one chess engine

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

    May 19, 2025 at 10:22 pm

    #4593653

  • Reply To: Question on SQL Query with NOT condition

    "I am trying to pull the record with ID 198765 out from select query where first and last or full name does not exists."

    What seems to be intended is for...

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

    May 15, 2025 at 7:44 pm

    #4591805

  • Reply To: Migrating data from using ManagerId to HierarchyId

    There are examples on the internet of how to recursively assign HIERARCHYID.  A while ago on this forum:

    Using hierarchyID

    My reply in the SSC forum was based on this Stack...

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

    May 10, 2025 at 3:58 pm

    #4589729

  • Reply To: continuous membership

    "a continuous year without any gaps" might mean different things.  This assumes it to mean (any) 365 days in a row

    If the EXP_DATE is null does that mean the account...

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

    May 10, 2025 at 3:31 pm

    #4589723

  • Reply To: T-SQL Parent Child

    Hey there why so hasty?  If you'd fixed the script we might've seen some JM t-SQL  It's been a while afaik :).  The query seems nicely done tho.  Presumably uniqueness...

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

    May 6, 2025 at 3:34 pm

    #4588359

  • Reply To: T-SQL Parent Child

    ringovski wrote:

    I have 5 country grouping tables with PK & FK foriegn key relationships that store master group names and sub group names each with the relevant country id.

    There are...

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

    May 3, 2025 at 2:17 pm

    #4587501

  • Reply To: Update particular record in a table

    Afaik there are only two possible values for the Category column: { 'Lessthan8', 'greatherthan8' }.  If that's so the query could rely on EXISTS to handle any duplication

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

    April 24, 2025 at 10:26 pm

    #4583779

  • Reply To: Replace calculation in cursor with set based logic

    Regarding the precision of the data types

    cast(Price as decimal(9,7)) Calculation

    The line above CAST's the price (Price) to DECIMAL(9, 7).  Imo this is not a good practice.  When...

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

    April 14, 2025 at 5:40 pm

    #4578900

  • Reply To: Replace calculation in cursor with set based logic

    My query was insufficient because it applied the factor percentage to the lagged price and not to the lagged calculated price.  It seems recursion is unavoidable.  This query uses a...

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

    April 13, 2025 at 3:48 am

    #4578250

  • Reply To: Replace calculation in cursor with set based logic

    Why are you using these data types with this numerical precision?  By making @Factor DECIMAL (9,7) and applying this percentage to a price it adds significance to decimal places to...

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

    April 9, 2025 at 6:13 pm

    #4576173

  • Reply To: Count of Distinct Values

    One way to unpivot unique values (of columns [Emp_1], [emp_2], [Emp_3]) could be to CROSS APPLY their UNOIN. The syntax might appear to be unusual because the subquery doesn't contain...

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

    April 7, 2025 at 11:07 am

    #4574482

  • Reply To: Query Help to show record in single row 

    with stub_cte as (
        select BName, StartDate, StartTime, 
               lag(StartDate) over (partition by v.stub...

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

    February 22, 2025 at 9:44 pm

    #4543919

  • Reply To: Final SELECT with WHERE based on passing in variable from Dropdown box

    The @dateChoice variable is passed in from a dropdown box and the WHERE clauses between the two queries are different.  Syntax-wise you could try IF @dateChoice = 'DOS' SELECT ... ...

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

    January 24, 2025 at 1:28 am

    #4522079

  • Reply To: Help with parent/child query please

    The only relational operator which seems required is a partial CROSS JOIN of #tmp (WHERE 'parent_id' IS NULL) to #tmp (WHERE 'parent_id' IS NOT NULL) ON 'uniqueid'.  Then it's a...

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

    January 16, 2025 at 2:21 pm

    #4516908

    • Viewing 15 posts - 31 through 45 (of 1,414 total)