Actually, either supports aggregation to many levels (I am not sure of the...

rukhsar1101 (9/18/2012)

---

Hello,

I hav just joint this forum.

I have to ask few things.

I have worked with SQL 2000 and basic 2005.database design.

I've planned to work as a DBA ,but not sure...

Jeff Moden (9/18/2012)

---

As a side bar, this is one of the reasons for my strong dislike for XML.

The following XML takes 193 bytes including a single end-of-line character.

<PartsList>

<Part>123</Part>

<Color>blue</Color>

<Size>small</Size>

<Part>124</Part>

<Color>black</Color>

<Size>medium</Size>

<Part>125</Part>

<Color>red</Color>

<Size>large</Size>

</PartsList>

The following only...

That's going to be quite a challenge if it is possible at all.

You might want to look at this recent thread: http://www.sqlservercentral.com/Forums/Topic1351799-392-1.aspx

Look for the suggestion by Eugene Elutin to generate...

Agreed that the BOY function is a waste of CPU cycles when the conversion is quite easy as follows:

SET DATEFORMAT MDY

SELECT BOY=DATEADD(year, DATEDIFF(year, 0, MyDate), 0)

,EOY=DATEADD(year,...

I think you're going to have a problem converting your part number into a tag.

You can do something like this:

DECLARE @t TABLE (Part INT, Color VARCHAR(10), Size VARCHAR(10))

INSERT INTO @t

SELECT...

I can answer for John.

SUM OVER requires a PARTITION clause. In this case, since you're partitioning over the entire rowset, anything will do, like 1 or NULL.

L' Eomot Inversé (9/18/2012)

---

No, it doesn't. ...

Evil Kraig F (9/18/2012)

---

dwain.c (9/18/2012)

---

Now I'm fairly sure someone is going to think that I'm crazy and perhaps I am, but why not use XML for this?

Let's set up the...

Nice work on the query mod. Like I said, I figured that info must be somewhere in those tables I SELECTed against.

On your second point, I guess it depends...

Now I'm fairly sure someone is going to think that I'm crazy and perhaps I am, but why not use XML for this?

Let's set up the incoming data just slightly...

That could be a very involved question. I suggest you look through the Stairway to SQL Server...

I have to agree with NOT A DBA in that your question is worded strangely and his answer is basically correct.

I suspect you may be looking for something else, namely...

This is really cool stuff!

Only scanned the article so far but have bookmarked it for a return read this weekend.

I had often wondered if there's an existing algorigthm out there...

Jeff Moden (3/3/2009)

---

<REDACTED>

Now, just in case anyone gets any smart ideas about using the clustered index in SELECTs to create an "order" without an ORDER BY... [font="Arial Black"]don't bloody well...