This script shows the way, how to remove a time from datetimes.Do not move this code to UDF, it would run at least 6 times slower.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-04-03

77 reads

Blogs

ochisia – n. the fear that the role you once occupied in someone’s life...

This is a quick blog post, mainly so I have the code available if...

Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...

Forums

I've read lots of the horror stories about nested views in databases where they're...

Hello! How do I grant a user to read-write to a single database and...

I have a very large table and I'm looking to do a cleanup based...

When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?