Technical Article

Make a time value from a given float value

Clients asked me to show a more detailed and longer text which doesn't have to be edited. So I came up with the following solution/function.This function returns a varchar time value with a description containing how many days, hours and minutes. For example 100.25 returns :'100:15( 4 Days, 4 Hours, 15 Minutes )'.I hope somebody […]

You rated this post out of 5. Change rating

2007-07-04 (first published: )

114 reads

Blogs

Monday Monitor Tips: Finding the Hostname for Queries

By

I was chatting with a customer recently and they wanted to know which host...

Can AI Read Execution Plans?

By

Yeah, yeah, second AI post in a row. I promise not to make a...

Streamline Dependency Management in Databases

By

In the intricate world of business, where precision and efficiency are paramount, managing database...

Read the latest Blogs

Forums

SSIS Won't Create Log Entries

By water490

Hi everyone My SSIS package will not log to sysssislog.  I am not sure...

SQL Server is terminating in response to a 'stop' request from Service error

By naga.rohitkumar

Dear All, In one of the server its repeatedly restarting sqlserver services and not...

Understanding CROSS APPLY and OUTER APPLY in SQL Server

By Noman072

Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...

Visit the forum

Question of the Day

Database Files on Shares I

I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?

See possible answers