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...

Let us throw in another monkey into the wrench. What happens if the job is started at 20 minutes after the hour, and for various reasons ends up running...

Using your test setup try the following:

select RunnerId, [1] as Contest1, [2] as Contest2

from

(select Id, RunnerId, ContestId from #tblResults) p

pivot (

count([Id])

for ContestId in ([1],[2])

) as pvt

order by RunnerId;

It isn't a bug in SQL Server 2008 (and yes, there are SQL Server 2008 forums available). I changed the datatype from time to datetime and ran your original...

Assumptions:

1. Single Reporting Job: Report Job

2. Multiple Schedules:

Schedule 1, every hour between 6:00 AM and 6:00 PM (i.e 6:00, 7:00, 8:00,...)

Schedule 2,...

GilaMonster (8/11/2009)

---

Chad Crawford (8/11/2009)

---

Gianluca Sartori (8/11/2009)

---

Some time ago there was a thread entitled "Should you use your real name as nickname?".

Maybe it's time to start the "Should you use your...