Forum Replies Created

Viewing 15 posts - 106 through 120 (of 380 total)

October 6, 2024 at 12:45 am

#4465674

  • Reply To: C# - how to convert string to date

    Thank you so much!

    April 24, 2024 at 1:09 am

    #4414764

  • Reply To: need help with a SQL query

    Jonathan AC Roberts wrote:

    Not sure if this will be any faster, you might have to look at putting indexes on the table if it is not:

    ;with cte as
    (
     ...

    April 8, 2024 at 7:26 pm

    #4408891

  • Reply To: need help with a SQL query

    Jonathan AC Roberts wrote:

    water490 wrote:

    I think I fixed the issue.  I added t_date to the partition part and now I am getting the correct number of records.  The query is super slow...

    April 7, 2024 at 7:54 pm

    #4408538

  • Reply To: need help with a SQL query

    I think I fixed the issue.  I added t_date to the partition part and now I am getting the correct number of records.  The query is super slow though.  It...

    April 6, 2024 at 4:44 am

    #4408106

  • Reply To: need help with a SQL query

    Thom A wrote:

    Seems like you could achieve this with a couple of CTEs. I assume that the value of T_date could differ, hence why I use window aggregation functions rather than...

    April 6, 2024 at 4:25 am

    #4408097

  • Reply To: how to do this in SQL?

    the queries are giving the correct output now.

    thank you both so much!

    April 4, 2024 at 4:05 pm

    #4407517

    • Viewing 15 posts - 106 through 120 (of 380 total)