Re: Date format question

From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 03 Aug 2007 21:01:25 +0200

On Fri, 3 Aug 2007 11:32:01 -0700, lwidjaya wrote:

Hi Hugo,
Thanks a lot! That's what I need. It even replaces all 'Null' with zero.

Hi lwidjaya,

Just in case you'd rather have the NULL, you only have to leave out the
"ELSE NULL" part of the dynamically built query.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.

References:
- Re: Date format question
  - From: Hugo Kornelis
- Re: Date format question
  - From: lwidjaya

Prev by Date: Re: Date format question
Next by Date: Re: Help with missing data in query
Previous by thread: Re: Date format question
Next by thread: Re: Help with missing data in query
Index(es):
- Date
- Thread

Relevant Pages

Re: nulls
... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(comp.databases.ms-sqlserver)
Re: T-SQL Challenge
... However, for each Product and WE_DATE, we also want the demand units ... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(comp.databases.ms-sqlserver)
Re: Date Range for SQL 2005
... execute. ... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(comp.databases.ms-sqlserver)
Re: reduce time for search query
... Posted by Peso: ... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(comp.databases.ms-sqlserver)
Re: SQL Minus 7 days from current date
... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(microsoft.public.sqlserver.mseq)