<root><row A="A" /></root>

Just had to try it myself.

I do all my coding in SSMS, so I never noticed this. Weird that it works if I copy and paste into...

Try this:

declare @XML XML;

select @XML = '<root>

<column_name>

<node_a>value1</node_a>

<node_b>value2</node_b>

</column_name>

</root>';

select x.y.value('local-name(.)', 'VARCHAR(50)'),

x.y.value('.', 'VARCHAR(50)')

from @XML.nodes('//*') x(y)

ItalianOlgi (10/8/2009)

---

On the other hand, I'd consider it a positive if it started with, "I haven't had to do that, so I'm not sure, but what I'd start with is...

GilaMonster (10/8/2009)

---

GSquared (10/8/2009)

---

On the other hand, I'd consider it a positive if it started with, "I haven't had to do that, so I'm not sure, but what I'd start with...

I'm not too worried about him taking my comment and doing anything useful with it. ...

GilaMonster (10/4/2009)

---

Elliott W (10/4/2009)

---

The only right answer is a valid answer, "I don't know" or a crap answer will almost certainly be a disqualification for anything other than a junior...

ItalianOlgi (10/8/2009)

---

Small company with no full-time DBA currently. Interview by VP of IT and one lady from India who knows SQL Server but only asked general questions like "have you...

jcrawf02 (10/8/2009)

---

GSquared (10/6/2009)

---

You can gain a lot of potential table names if you use Latin names (genus species style) as well as the vernacular. Extinct animals are a great...

According to what he posted, it's using 1.3. That plus the swap file data makes it look like a memory pressure issue to me.

Since we're pretty much shooting in...

From that, I'm extrapolating that an asterisk in the field indicates that either the next character is a column, or that the next number is a column. Can you...

First, you get a copy of Query Analyzer or SQL Server Management Studio. Either one will work.

Do you have one of those?

Add more RAM. SQL using 1.3 and page file 1.8 on a 2 Gig machine means you're swapping to disk more than you should be.

I don't even use desktop...

Here's a sample of how to make this kind of thing work:

create table #T (

ID int identity primary key,

ParentID int null);

insert into #T (ParentID)

select null;

insert into #T (ParentID)

select null;

insert into...

One-to-one/zero tables are quite common. It's called "vertical partitioning", and it's really useful in a number of circumstances. Some DBAs use it any time a column could possibly...

From your description, it should be relatively easy to use the Substring function to split out those columns.

For example, something like this will handle column 2:

create table #T (

ID int...