then it seems like this should work:

SELECT * FROM (
SELECT  agent, dbo.fnGetSeconds(CALL_TIME) 
FROM 
    [a2wh].[dbo].[CallLogCommon] 
) t
pivot (
    SUM(dbo.fnGetSeconds(CALL_TIME))
 ...

Solved... there were no NULLS but one value was ''

I changed the function to have a length of 10 rather than MAX but the error persists:

CREATE FUNCTION [dbo].[fnGetSeconds]
(
@TimeFormatted varchar(10)
)
RETURNS decimal(10, 2)
AS
BEGIN
  RETURN
  (SELECT (LEFT(@TimeFormatted,2)*3600)...

No nulls in the data but there are some that are 00:00:00

I can figure out where/how to use it but I'm getting an error:

dbo.fnGetSeconds(CALL_TIME)

--Invalid length parameter passed to the RIGHT function.

That worked.... thanks!

I download the installer from which I can choose SSRS and SSIS but when I try to launch the installer I consistently get the following error: Please close the following:...

This sql works about this way:

DECLARE @Seconds INT;

SELECT @Seconds = 43052;

SELECT CAST(@Seconds/3600 AS VARCHAR(10))

+ RIGHT(CONVERT(CHAR(8),DATEADD(ss,@Seconds,0),108),6);

I tested it

Fortunately for this application I don't need to convert any to days as none will exceed about 20 hrs.

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

On the D: drive there is 239GB available out of 839GB. And the data and logs are on the same drive

So the file size of my log file being 253GB is nothing to worry about (?). The total size of the drive is 1 terabyte. The file ID 2 is...

• This reply was modified 6 years, 1 months ago by DaveBriCam.

It says the file is in use. The backup is on the same server as the SQL database unfortunately. There seems to be some inconsistency of naming too (?)

file_id   ...

Quite honestly no one including myself has any idea how this file grew so large or what to do about it while our space is quickly running out. I don't...

Would the truncate only option be necessary since this database will have activity going on while I'm reducing this file size? I have no room on my server to back...

I'm trying to sum the payments for each person and I also wonder if I can take it further joining other tables like location, etc. and using SUM, ROW NUMBER...

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