Any response would simply be a guess. We don't have enough information to really tell you anything. We don't know how the data is partitioned and indexed, or...

And, just for S&G's here is another alternative:

CREATE TABLE #Test

(ID INT, Countries CHAR(2));

INSERT INTO #Test

...

Effort worth expending not.

Here is another possible solution:

CREATE TABLE #Test

(ID INT, Countries CHAR(2));

INSERT INTO #Test

(ID,...

Flattery is imitation. Two Vaders there is on SSC.

Wonder I do should I correct him? 03:00 - 04:00 night is not, but early morn.

I would not look at shrinking tempdb. I'd look at increase the size of tempdb so that when it starts it has the space needed to meet the processing...

How about the following:

DECLARE @InvoiceDate DATETIME

DECLARE @Ans AS VARCHAR(12)

SET @InvoiceDate = '2-29-08'

SET @Ans = CONVERT ( VARCHAR(12) , @InvoiceDate , 105 )

SELECT @Ans

SET @Ans = CONVERT...

I think you will find that the SQL Server 2005 version of the UDF I wrote will work just as well. It may even be more efficient as I...

I would start by reading ALTER DATABASE in Books Online (BOL). If, after reading that you still have questions just come back to this thread and ask for what...

Here is another way to generate the dates you are generating.

CREATE FUNCTION dbo.DatesInRange(@StartDate datetime, @StopDate datetime)

RETURNS TABLE

AS

return

with

a1 as (select 1 as N union all

...

please confirm that the purpose of the function is to return a table of dates between a given StartDate and EndDate inclusively, ie if StartDate were 2009-01-01 and EndDate were...

I would not repost in a SQL Server 2000 forum at this time as people have already started helping you out here. However, I would just be sure that...

GilaMonster (3/9/2009)

Kit G (3/9/2009)

Lynn Pettis (3/9/2009)

Perhaps you should send...

True,...