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

497 reads

Blogs

The T-SQL Tuesday Corollary

By

T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics...

How to Import Perfmon Data into a SQL Server for Analysis

By

If you followed the last video, I showed you how to set up windows...

How To Set Up Perfmon for 24×7 Collection

By

I just released a new training video (one of many to be released in...

Read the latest Blogs

Forums

OLAPQueryLog does not work for SSAS Tabular mode

By Tho Le

I running into a problem when I try to setup querylog in SSAS. The...

MasOffer Affiliate m?t hình th?c ki?m ti?n v?i ti?p th? liên k?t

By ngocha97

[/b] MasOffer là m?ng ti?p th? k?t liên r?t l?ng danh ? Vi?t Nam....

Code to auto-update tables on set date

By thetubageek

I am in a project where information is being pulled from a database then...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers