Heh... 5 rows for 2 users generates 1,460 rows in the #Days table to start with.  Wonder what's going to happen when you have 10,000 rows for 100 users?

I'm thinking that DTS is going to be your only way out if you don't want to or can't use a command prompt of xp_CmdShell.

If you had a really cool...

Peter, any way you guys can suppress the double spacing?  And, which editor are you using (I like the colors)

Uh-huh... What is that that you would like to do for the following?

ID Name   ParentID Level

1  Root   null     1

2  Trunk  1        2

3  Branch 2        3

4  Leaf   3        4

5 ...

Why are you storing such data in your database?  Can't you get the source info into a little better shape, first?

The best performance will come from BULK INSERT followed closely by BCP in most cases.  But "What is Best" is in the eyes of the beholder... If you need the...

No... not more VB like... more mathematical like

Sure would be nice if you posted the URL of the article you read...

Sounds like an interesting article... do you have the link?  I'd like to take a peek...

Thanks, Tracey.

Heh... ok... no flaming   But I'll just bet you'll never again let another vendor touch your DB's without making a full backup, huh?...

Not sure if this can be done in Analysis Services because I don't use it  

In the T-SQL side of the house, we...

Gova,

Are you all set now?

Let's see... here's some nicely formed test data that Gova provided...

DECLARE @myTable TABLE

(

DataDate DATETIME,

DataVale INT

)

INSERT @myTable

SELECT '07/01/2007', 100 UNION

SELECT '07/08/2007', 120 UNION

SELECT '07/15/2007', 150 UNION

SELECT '07/22/2007', 190 UNION

SELECT '07/29/2007', 210...

Go back and look at the original post... it's all there even though there may have been a bit of confusion, at first... if it wasn't, I wouldn't have been...

Gova did all that, Lynn...   Even provided a table with data inserts..