Please confirm that the purpose of the function is to return a table of items from a delimited string.

For example, given the string "'A','B','C','D','E'" return the following:

1 A

2...

Here is my .02. I'd prefer to do native backups to local disks, then backup the backup files to tape or other remote storage media. Reason, it is...

Nice it would be if feedback OP would provide.

Check out the following code and see if it does what you need:

select getdate(), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0) + 4

GilaMonster (3/11/2009)

Bet you a coffee that either he comes back...

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...