yup - forgot all about that little restriction...

And yes - it can sometimes turn out to be (quite a bit) less efficient than the older-style derived table. Looks to...

mtraphagen (5/20/2008)

---

I want to select a bunch of stuff (or everything) from a query then you can do that with the "From query" option. It will ask you for a...

I'm actually trying to figure out why you're doing sums both in the inner query and the outer query. It looks to me that you're making this substantially harder...

Sounds to me that you already have your answer. You've essentially determined your own issue: you need to accurate derive/store the effective date of the credits/payments instead of the...

GSquared (5/20/2008)

---

Jan Van der Eecken (5/20/2008)

---

I got it wrong, in part because I didn't try it out, but also by relying on the trust I put into the SQL team,...

ALZDBA (5/20/2008)

---

I would certainly test SSMA.

Download it, install it, and see what kind of remark, warning, errors it gives.

You may need to do some stuff as a perparation for the...

Since you're in 2005, you can actually use the new windowed version of max() to do just that. It looks something like this:

select

employeeID,

name,

...

Lee Hart (5/19/2008)

---

Hi Toni,

That fill factor is the "recommended" fillfactor from the company and hence is the delivered fillfactor for...

kristian aspelin (5/19/2008)

---

I am trying to run a dynamic query with double byte characters as below:

exec('select ?? from yc1')

When I run this it replaces the double bytes with question marks...

ganeshmuthuvelu (5/19/2008)

---

An auto generated number something like the node "position()" is what I am looking for to uniquely idenitfy the node value..

The reason I need is, after getting the...

ganeshmuthuvelu (5/19/2008)

---

I have a XML as below

declare @doc2 xml

SET @doc2 = '

<ROWS>

<COL1>1</COL1>

<COL2>2</COL2>

<COL3>3</COL3>

</ROWS>

<ROWS>

<COL1>11</COL1>

<COL2>22</COL2>

<COL3>33</COL3>

</ROWS>'

Select r.value('local-name(.)','varchar(20)') as Name,

r.value('(text())[1]','varchar(100)') as Value

From @doc2.nodes('//*') as x(r)

This works to return...

Assuming you still have access to the SQL Server 2000 tools, when in doubt you can also try the DTS import and Export wizard. It can help get past...

Chris - it looks like EmployeeID isn't an identity (autoincrementing) column, so trying to insert into your employee table without an actual value for employeeID will fail.

By the way -...

MarkusB (5/19/2008)

---

Matt,

I think you still don't fully understand.

The rownumbers should be ordered by the listprice or any other column I select. So when ordering desc by ListPrice I want the...

MarkusB (5/19/2008)

---

Matt,

the inner order is actually the important one.

Anyway I just a look at MS Connect and there is a report about this issue and the answer from...