I think you may need u.database_id = db_id() in the Where Clause

Excellent article. I have a lot of forecast and actual time-series data and will check out the methods this weekend.

I always use select a/nullif(b,0) for division when there is a possibility that the divisor is zero.

This is not a huge database [about 100 Mb] and our IT guy did a full backup daily.

Problem arose when he moved the database to a Virtual server and...

Recovery Model =Full

Thanks.

Unfortunately, the good backups are a few weeks old.

That said, any ideas on the cause? Could it be the disk controller as suggested on the Microsoft KB?

Eddie

Declare @dt DateTime

Set @dt='20090604 09:00:00.123'

select convert(char(24),dateadd(dd,datediff(dd,0,@DT),0),121)

Can you send a sample of the CSV file.

Are you updating the XML or creating new records?

Solution using XML to concatenate strings

;With T1 as

(

Select

Col1,

Col2=Max(cast(b.x as varchar(max)))

From tab_Test a

Cross apply(select x=(select col2+',' from tab_Test...

Agreed, but XML constructs are part of T-SQL and therefore, always available

I find the use of XMl to be a cleaner method to concatenate rows into a single value:

select Fname+','

From Employee

For XML Path(''), Type

Elegant solution on Post http://www.sqlservercentral.com/Forums/Topic704553-145-1.aspx

My strings usually have less that 20 "tokens"

I use the recursive function below

Create Function dbo.GetStringTokens(

@String Varchar(Max),

@Delimiter varchar(1)

)

Returns Table

AS

Return

(

with StartEnd(ID,i,j) as

(

select

ID=1,

...

I used this yesterday and worked perfectly, slightly different from your syntax

Select *

from OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\temp\Spreadsheet.xls;',

'SELECT...