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 4 years, 9 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 5 years, 5 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 5 years, 8 months ago by DaveBriCam.
• This reply was modified 5 years, 8 months ago by DaveBriCam.
• This reply was modified 5 years, 8 months ago by DaveBriCam.
• This reply was modified 5 years, 8 months ago by DaveBriCam.

Is there a way to order by COUNT like?:

New York 73,152

Chicago 34,152

Los Angeles 15,252

I'm using this as a learning exercise too, so if anyone has any PARTITION BY or WITH...

"ODBC--connection to CCE_Ethics_DB' failed."

Using "User" type DSN

Thanks Jonathan it worked!!

My problem is this part/count gives the correct figure of 4,090:

SELECT count(p.[peopleId]) AS 'Inactives'
FROM [BCC_DB].[dbo].[People] p

And this gives the correct figure of 2,126:

(SELECT count(p.[peopleId])...