Forum Replies Created

Viewing 15 posts - 31 through 45 (of 395 total)

December 10, 2021 at 9:44 pm

#3962529

  • Reply To: Problem understanding SUM function with GROUP BY

    Sorry... I see now and tried MAX and that took care of it... thanks!!

    December 6, 2021 at 4:04 pm

    #3960902

  • Reply To: Problem understanding SUM function with GROUP BY 

    This does not seem to work, the data returns like before:

    SELECT [user_name], [created_at],
    SUM(dbo.fnGetDecimalTime([event_sec])) as 'Decimal_Time_SUM'
    FROM [Charter].[dbo].[ConvoHrs]
    group by [user_name],[created_at]
    order by [user_name]

    • This reply was modified 4 years, 5 months ago by DaveBriCam.

    December 6, 2021 at 3:41 pm

    #3960894

  • Reply To: Problem understanding SUM function with GROUP BY

    Thanks! One thing what if I need to add a field like [Date] (which I may want to do grouping on later)? It wants this added to the 'group by'...

    December 6, 2021 at 3:33 pm

    #3960891

  • Reply To: best way to extract name and number

    I can get the full name with this:

    ,LTRIM(RTRIM(SUBSTRING([user_name], CHARINDEX(')', [user_name]) + 1, 
            PATINDEX('%[+-][0-9]%', [user_name]) - (CHARINDEX(')', [user_name]) + 1))))

    December 2, 2021 at 7:57 pm

    #3959704

  • Reply To: Query removing NULLs when not chosen to

    That works and makes sense! Thanks!

    November 23, 2021 at 5:59 pm

    #3956176

  • Reply To: problem with UNION ALL query

    This is working:

    SELECT * FROM (SELECT 
          c.clientname as 'Client',
          c.BillingRateA as 'Rate',
      b.BillingTypeA as 'Unit',
    ...

    November 18, 2021 at 10:07 pm

    #3954633

  • Reply To: problem with UNION ALL query

    Both BillingRateA and BillingRateB are decimal

    CREATE TABLE [dbo].[Client](
    [ClientID] [int] IDENTITY(1,1) NOT NULL,
    [ClientName] [varchar](50) NOT NULL,
    [MarketSegmentID] [int] NULL,
    [BillingTypeA] [int] NULL,
    [BillingRateA] [decimal](8, 2) NULL,
    [BillingTypeB] [int] NULL,
    [BillingRateB] [decimal](8, 2) NULL,

    November 18, 2021 at 9:35 pm

    #3954631

  • Reply To: problem with UNION ALL query

    Her is what I am getting:

     

     

    November 18, 2021 at 9:20 pm

    #3954620

  • Reply To: problem with UNION ALL query

    BillingRateB and BillinRateA are decimal. 49 rows are returned and there are 41 records in the table of which 8 in question do have a BillingRateB (and BillingRateA), but all...

    November 18, 2021 at 8:56 pm

    #3954607

  • Reply To: Subquery issue in PIVOT

    How can I pass in the date as a variable in the dynamic part of the SQL?:

    --below is close but not working:

    declare
        @ColumnNames nvarchar(max),
    ...

    November 3, 2021 at 7:11 pm

    #3947649

  • Reply To: Update table FirstName & LastName from Email addresses

    What is the code for the function DelimitedSplit8K?

    October 29, 2021 at 7:34 pm

    #3946089

    • Viewing 15 posts - 31 through 45 (of 395 total)