Great, you looks confident! how you do partitioning switching? dynamic queries? manual? how often? weekly? monthly?

using the 20k method? what 20k method?

that mean I need to go thru' trial-and-error? Thanks anyway

Jeff Moden (8/25/2008)

---

If the clustered key is set by date or, perhaps, identity and the identity column is indicative of entry order, then sectional deletes (or insert to archive, delete...

Yes, I have gone thru' that. That's what I meant cold archiving (predefined values). I have tried to do something like this:

SET @SQLString = N'ALTER PARTITION SCHEME [' + @archiveScheme...

Sorry, I am curious how the table partitioning affect...

then you meant ident_current('table name') can be used as scope_identity ?

since you are talking about identity, I think IDENT_CURRENT('table_name') will also have the scope problem as @@IDENTITY(From BOL: @@IDENTITY is not limited to a specific scope; SCOPE_IDENTITY returns the value...

I cann't , I get this :

< D>

< N>Measure </N>10.6227 </D>

< D>

...

Thanks for your info, though I did not use trigger. Anyone know batch update to eliminate of getting @@scope_identity?

The openXML or XQuery I have no problem,

but the column "ID" in table A will be getting from:

set temp variable = @@identity

to insert into column "A_ID" in...

Great, thanks. 😀

where's declaration of @var?

Do not tell me:

DECLARE @var text

or

DECLARE @var nvarchar(4000)

😀

[Code]

create table #t1 (col1 text)

insert into #t1

Values('

<Customers CustomerID="XYZAA" ContactName="Joe"

...

GilaMonster (5/14/2008)

---

Other than suggesting that SQL 2000 questions should go in the SQL 2000 forums?

Dunno. I'm...

GilaMonster (5/13/2008)

---

I'll go with a simple partitioned table (partitioned on the day of week, or the day of month, depending on data volumes) Don't see any need to add the...