Did you notice? Based on the last login info the OP obviously lost interest or found an answer...

What columns you want to store the data in?

Please review your provided information...

If you're using MySQL and not SQL Server you probably should try a MySQL forum instead....

The solutions we're posting probably won't work...

Most...

The nvarchar(128) is the defined type and length for identifiers (see BOL, section "identifiers [SQL Server]")

I would use the allowed tpes as described for base_types when creating a user-defined type...

First question:

Why do you have table2 and table3 in your query? They are neither part of your SELECT nor your WHERE condition....

To help you any further please post more detailed...

Your performance concern comes second. First we have to understand what you're...

No, I didn't. I told you that the information you provided so far is not consistent. You use columns in...

@matt-2: you beat me this time... :crying:

But at least our answers do not contradict... 😉

Digs (4/28/2010)

---

Sure whatever works..

So I just do

INSERT INTO dbo.DIM_OHLC_Xml

SELECT

@symbol AS Symbol,

@CurrDate AS Currdate,

...

You might want to use XQuery instead of Openxml:

DECLARE @xml XML

SELECT @xml='<ohlc>

<record date="02/01/2010" open="125.25" high="126.25" low="124.25" close="125.20" volime="554651668" adjclose="125.20" />

<record date="02/02/2010" open="126.25" high="127.25" low="125.25" close="126.20" volime="548935488" adjclose="126.20" />

<record date="02/03/2010" open="125.25"...

If you have a fixed number of brand_names then you could either use PIVOT (see BOL, aka BooksOnLine, the SQL Server help system), or CrossTab (see the related link in...

You're referencing different tables in your SELECT and GROUP BY clause:

SELECT

dbo.DimAge.Age,

dbo.DimSex.Sex,

dbo.DimOccupation.Occupation

GROUP BY

DimCountry.Age,

DimTaxDetails.Sex,

DimRace.Occupation

Since we're talking about a cross join across 10 tables: I truly...

Grant Fritchey (4/28/2010)

---

People here may not have, or may not want, StackOverflow logins to answer your question. If you want an answer here, ask the question here. Otherwise, wait patiently...

The code you're running is basically a triangular join which probably doesn't scale very well...

You should look into ROW_NUMBER().

Something like this (untested, since ne ready to use sample data to...