I agree... and, if folks are going to post questions that have no backwards compatability, they should identify which version of SQL Server.

DECLARE @AsOfBeginDate datetime

DECLARE @ParmAsOfDate datetime

set @ParmAsOfDate='09/01/2007'

SET @AsOfBeginDate = dbo.uf_RptGetDayBeginDate(@ParmAsOfDate)--@ParmAsOfDate)

Print @AsOfBeginDate

The item hilighted in red is incorrect. It must be a SELECT...

DECLARE @AsOfBeginDate datetime

DECLARE @ParmAsOfDate datetime

set @ParmAsOfDate='09/01/2007'

SET @AsOfBeginDate = (SELECT...

Ok... that's for the "If I give the dates directly The stored procedure is giving the result is good." part you were talking about... but you also said "If I...

Can you show the code that you're calling the sproc with, please?

I believe you're missing the sample in your post...

What is v_un, v_1, v_2, etc, etc? They're views aren't they? You should probably post at least 1 of those and some easy to load data... see...

Heh... thought you said you "Frankly, I don't want to waste time working on something that's a bad idea or trying to prove which one is better"

Nah... they've got views for that stuff...

SELECT *

FROM Information_Schema.Columns

WHERE Data_Type = 'UniqueIdentifier'

Ummm... Windows' calculator has a very nice scientific mode. And Jason...

Then, consider this...

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

The only problem is that I've not figured out a good set based method for future dating things like deliveries given a ship date and a number of...

It appears that this article was written quite some time ago... but, boy, is it sweet. I haven't tried it yet but Dinesh sure did make it easy.

You can...

By the way... I call these While Loops that do deletes, "Delete Crawlers" because they "crawl" through the rows to be deleted, mostly unnoticed. Here's the basis of how...

First, the database will take a while to "recover"... it'll take less time because you rebooted it as it won't let anyone in until it's done... so no blocking of...

Oh bugger... I'm sorry. I'm the same way... I do like to have "Jeff" spelled correctly.

Heh... lately, I've been using your name (or a mispelled version of it :hehe:...

Both are huge, very broad subjects....

There are a large number of articles on debugging SQL... Google for "HOW TO DEBUG SQL" and you'll get some great articles including how to...