the storage requirements of a varchar are the length of the data + some space to store info to work out how long/ where that data is (an offset/length - a number...

I think you slipped in an extra slash at the end of the xpath

i.e.  '/RECORD/EMPLOYEE/' should be '/RECORD/EMPLOYEE'

We used OpenXML in some components for a (small/mid sized?? - maybe 35K hits/day) web site generation app to pass small xml docs to some stored procs to vary the...

w3c is usually a good place to start.

http://www.useit.com

is a very good site for ui design (usability/ functionality rather than prettiness). Needs a bit of...

The euro symbol isn't supported in ISO-8859-1 format, so I don't think that can work like that.

btw, notice that the example isn't disposing of the xml document with...

glad to see it's working

the order by is only to ensure that the child nodes get assigned to the correct parent nodes and in whatever order you want, which you've...

Argh! Stupid browser - just lost my post >-| (or maybe these ff mouse gestures aren't compatible with an itchy trigger finger).

If you take off the "for xml explicit" bit...

Don't think you can do what you want simply because in the result set the row for 203 will always occur after 202, so j:LocationStreet ends up being written after...

Hi, haven't looked at xml explicit in a bit [using oracle at the mo ], but as I recall you should be able to...

could you do something like

SET b.Period_01_Balance = b.Period_01_Balance + t.Trans_Amount * (CASE t.Fiscal_Period WHEN 1 THEN 1 ELSE 0 END),

 b.Period_02_Balance = b.Period_02_Balance + t.Trans_Amount * (CASE t.Fiscal_Period WHEN 2 THEN 1...

Dan

did you try accessing the db locally on the server with the same problems? o/w when you connect in EM, you can choose between win auth and sql server...

Anything in the event log? o/w have you tried connecting using Enterprise Manager or just using eg a .udl file to make a connection string? That might give...

I suspect you'll need to use a cursor to accomplish this in sql since ( if I've understood what you want :S ) you need to continually monitor the results...

wierd ... from BOL:

Note You can create indexed views only if you install Microsoft SQL Server 2000 Enterprise Edition or Microsoft SQL Server 2000 Developer Edition.

not used them though...

believe you need Enterprise edition to use indexed views btw...

msdn version might allow it as well.