Jeff Moden (9/22/2009)

---

As a side bar... this is why I cringe at the idea that 2k8 actually has separate datatypes for date only and time only. Everyone is going...

It was there, I opened directly, but I since...

This is another way and doesn't use the convert statement:

dateadd(dd, datediff(dd, 0, getdate()), 0)

sqlislife (9/23/2009)

---

Hi experts, I have always wanted to know this,

What is the best way to write a tsql code for parametrized date ranges? For example

create procedure procname

(

@datestart datetime,

@dateend datetime

)

as

select column1

from...

Chuck Lucking (9/23/2009)

---

I made the assumption that you want any task that is due today or in the past.

create table #Task (Task varchar(10), Due smalldatetime)

insert #Task select 'TaskA','09/21/2009'

insert...

kiran_ramisetti (9/23/2009)

---

Table: TaskTable ...

Thomw (9/23/2009)

---

I've now built a case stm which works standing alone, but fails when part of the query. Either I'm missing something simple, or it doesn't work like this....

As asked before, would you please post the DDL for your table and the indexes?

Silverfox (9/23/2009)

---

I took a look at this particular thread. I do agree with you, Silverfox, and I am usually one tht tries very hard in this regard....

Silverfox (9/23/2009)

---

Has...

I'm not sure what you are talking about. I...

Jeff,

Test this one out:

USE [SandBox]

GO

/****** Object: UserDefinedFunction [dbo].[ufn_Tally2] Script Date: 09/22/2009 09:06:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

alter function [dbo].[ufn_Tally2](

@pStartValue bigint = 1,

...

I incorporated the changes that both Gus and Jeff suggested and using the simple SET STATISTICS TIME ON method of testing, the routine generates 1,000,000 rows in approximately 900ms.

Here is...

See, and now we are finding some very interesting errors in the code that I missed. Thanks, I do appreciate it. 🙂

Jeff Moden (9/22/2009)

---

Lynn Pettis (9/22/2009)

---

First, leave it to you squeeze another 33% out of a routine, awesome. I'll have to incorporate that change into my code. I think...