Forum Replies Created

Viewing 15 posts - 106 through 120 (of 375 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

  • Reply To: how to do this in SQL?

    Thank you both!!  I appreciate your help so much!

    I tested another scenario.  I added a different company in the list so there are now two not one company.

    Drew, your solution...

    • This reply was modified 1 year, 6 months ago by water490.

    April 3, 2024 at 11:33 pm

    #4407181

  • Reply To: how to return the min value of a column if a sub-query returns no results

    Thank you everyone!

    I will try them and report back any issues

    April 2, 2024 at 6:52 pm

    #4406594

  • Reply To: error using #temp tables

    Thank you everyone.

    This is very interesting.  Is this a bug within SS that you cannot drop a #temp table inside a SP using the DROP TABLE command?  Or is there...

    April 2, 2024 at 3:07 pm

    #4406481

  • Reply To: error using #temp tables

    one thing I should mention/clarify...

    each time I re-use #temp2 I am using a completely different select statement so the columns going into #temp2 will be different.

    it is odd that I...

    April 2, 2024 at 7:30 am

    #4406267

  • Reply To: how to return the min value of a column if a sub-query returns no results

    thank you everyone for your feedback.  I will test the code and see how the output looks

    April 1, 2024 at 9:25 pm

    #4406086

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