Match Date Only

Here is a simple function to compare datepart of datetime fields , (no need to say ignores hour t,min,sec ... ) isDateMatch(@date1,@date2 ) retruns 1 if the datepart matches else returns 0regardsjohn

2 (1)

2007-03-21 (first published: )

181 reads

Convert Numeric Figures into Words

Hi guys    What about a function that converts a number figure into words.This sample script is to demonstrate the procedural capabilities of SQL Server . Samples  select fig2words(10) will give --Ten-- ,select fig2words(103) will give --one hundred and three --    The author uses much under utilized capability of SQL Server the recursive function calls to […]

2003-11-11

487 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

Upgrading SQL Service Packs on multiple versions

By Lord Slaagh

Hello SSC, My company has SQL versions that range between 2008 R2 to SQL...

Dynamic images within my report

By Shabbaranks

Hi, Im trying to get dynamic images in my report based on a Tablix...

Setting fill factor on an auto-increment INT clustered index

By Mr. Holio

Hi all, Please consider the following table structure. CREATE TABLE [dbo].[Transactions]( [Id] [int] IDENTITY(1,1)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers