Hope this gets you started in the right direction. All I did was mimic the sample code from BOL (Books Online).

create table #t1 (id int,pid int,s varchar(100))

insert into #t1...

To get help faster and get working tested code, please read the first article I reference in my signature block regarding asking for assistance.

To really help you, we need the...

Why not change this:

AND (VV.Fund_Valuation_Date = (SELECT MAX (Fund_Valuation_Date)

FROM dbo.Fund_Valuation VVV

WHERE VVV.Fund_Valuation_Date < '2006-09-01'

AND VVV.Fund_Number = V.Fund_Number

AND VVV.Class_Type_Abbr_Name = V.Class_Type_Abbr_Name

AND VVV.Class_Type_Category = V.Class_Type_Category))

to this:

AND VV.Fund_Valuation_Date = (SELECT MAX (Fund_Valuation_Date)

FROM dbo.Fund_Valuation...

Actually, I may have figured it out. Took a lot of digging and guess work. Preliminary testing looks good, but it is late, and I really don't feel...

drew.allen (8/11/2009)

---

I think that this line from...

I have to disagree with this statement. Just because a topic has already been covered in an...

Not all posts are related to the article itself. That is one of the benefits of this community and where you actually learn new things or ideas.

Have you tried casting both sides to INT? Can you add two columns to the tables, computed columns that convert the values to INT and then index the computed...

timothyawiseman (8/11/2009)

---

Steve Jones - Editor (8/11/2009)

---

What I would be happy to do is publish a list of "reviewers" on the writer's page and allow authors the ability to private message...

Also, the following works:

declare @ EnableStr varchar(max);

select

@ EnableStr = (select 'alter login ' + [name] + ' enable;'

...

I'd have to say it isn't a bug as sorting by ordinal works fine with a normal query. Probably has to do more with the concatination process.

jacroberts (8/11/2009)

---

Kit G (8/11/2009)

---

jacroberts (8/11/2009)

---

I feel that's fine as a policy but there is no warning of this within the articles, they can look like they've been reviewed and properly...

But if you change the ORDINAL (1) to [name] it works.

You really should start using the column name(s) in your order by clauses.

Like Jeff said, your code was wrong. Other than that, I have no explaination. All I did was build the query in pieces following the sample code in...

I have also heard this: "You learn more from failure than success."

If you never fail, what do you learn? It's the mistakes one makes that you learn from, not...