Outstanding, Sergiy!

I ran the following and the proc that uses the DateOnly function doesn't take any longer than the other...

USE NORTHWIND

GO

SET STATISTICS TIME ON

GO

CREATE PROCEDURE dbo.ProcTest1 AS

SELECT dbo.DateONLY(ShippedDate)

 ...

>The conclusion I am reaching is why you should never, ever, under any circumstances use UDFs. e.g. DENY CREATE FUNCTION to public should be standard.

My experience is that UDF's are...

Charles,

Very nice.   And if you reverse the dates, the numbers make even more sense!  I added a couple more to show the trend...

 Previous Week: DateDiff(wk,getdate(),datefield) = -1

  Current Week:...

Not sure... I think this is what you want... make sure you have a primary key on your table and this should only take a couple of seconds to run. ...

Those are all great methods and I applaud the innovations of all... but as Remi G and Adam Mechanic would remind us, you might just want to think about finally...

Nice article... you really put some thought into the proofs and which graphics to use.  Good idea, as well.

They want to use a varbinary similar to what is presented by COLUMNS_UPDATED() in triggers.  I've got all that worked out so no problem there.  Like I said, I have...

Vladan,

My most sincere appologies as well... I thought you were directing it at me... Phil's correct... it's been a terrible week never mind day alone.  But that's no excuse and...

Not my restrictions but the I agree with your smart-assed comment and useless comment... the client is insane especially in light of the fact that I have a solution that...

You bet, Chhana.  Simple is good.  Thank you for the feed back.

Phil,

I sure wouldn't mind seeing that DLL if I can call it as an extended stored procedure.  I hadn't thought about that.  From a Data Troll aspect, I wouldn't mind...

 CREATE TABLE myTable

        (

        myCol BIGINT IDENTITY(1,1),

        Col1....

        .... other column data

        ....

        )

Harley,

First, welcome aboard.  Thanks for the feedback and you are absolutely correct... it's supposed to add a month and I fat fingered it...  I've corrected the problem in the previous...

Midan1,

YOU WROTE:

----------------------------------------------------------------------------------------but i need to search between dates

like this i can not !!!

SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)  

 , DATEADD(mm,DATEDIFF(mm,-1,GETDATE()),0)

i need to search from

first day of the month

 the-1

 and  between

last

28