Damn, you actually did :w00t:

nice, thank you so much...

Now I will sit down an try to understand what you did, so I can add the 3. and 4. table...

hehe.. ok, no problem, have lots of time, the streets are emty, Evvverybody want to see Paris Hilton here in DK.. hehe

again, took 20 rows, to get data from logicaldisk

...

This is what I got! I took some more, to actually have an output in devices 😀

DeviceKey ...

Sure 🙂

I'm not sure how to create a INSERT script with pre-data..

but its simple, I use Name and productKey from devices, and DeviceKey is the relation key

in CIM_logicalDisk I want...

I think it shoyld be the temp table?

Update s

Set N = s.ID + 1 - sg.MinID

From #Serverstemp8 s

Join (Select #Serverstemp8.Name, ID, Min(ID) as MinID From...

Hi Again,

And sorry for all the ? but this is by far the most complex SQL I have ever seen, but still learning 😀

after converted to the real table names,...

the problem is the Row_Number() function, its not supported in sql2000, can I eliminate that?

/T

hi again rbarryyoung,

Hope you(or anybody) could help me the last time in this matter:

My script now looks like this,

With cteServers as (

Select PC.PC

, ...

Oh my god.. 🙂 is it all in your head? :hehe:

I don't know why, but i wrote this instead,

, Row_Number() Over(Partition by PC.PC order by Disks.Disk_Desc) as...

got some errors, tried to change it a bit, but still not the result I'm looking for, any ideas?

With cteServers as (

Select PC.PC

,PC.PC_DomainName

, Disks.Disk_Desc

,...

thats the problem, that its different every time, but 3-4 I think.. at most..

just founded out, it does.. growth to current size, so if it ones has reached ex. 30GB initial size will stay until I make a SHRINK_XX but was is the...