Here's what I'd do.

Write a query for everything but 0, so

select name, score, 'A' as 'OrderingField'

from Table

where score > 0

order by score

then union in the zeros.

select name,...

You might pick up a copy of this as well: http://www.amazon.com/Server-Relational-Database-Design-Implementation/dp/143020866X/ref=sr_1_1?ie=UTF8&s=books&qid=1260635050&sr=8-1

OK, 999 pages, I just had to post something and see if I could kick it to 1000.

I still want a "got SQL?" shirt.

Speaking of beer....

I got an email today from Red Gate, the subject was "108 bottles of beer and 16 pizzas"

The rest of the email was "in the servery" (cafeteria).

Some days...

I think Pavel is right. It has to be security. domain admins don't necessarily have rights to all folders.

What I'd suggest is you make a new share on the other...

SSIS just changes the way you could use accounts. You still need to get an account that works. Something doesn't seem right here. Are you executing this in SSMS and...

It's not that you document and slog through everything. But you don't often know or realize what's important when it happens. How often have you had something occur and wished...

You get one chance to make a first impression, but you can fix...

Good editorial. I certainly like my comfort zone and don't like moving out of it. I tried last year, with the idea that I'd speak more, do more community stuff....

Here are a couple SSIS links:

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

http://www.simple-talk.com/community/forums/thread/5173.aspx

http://www.sqlis.com/post/File-Watcher-Task.aspx

http://stackoverflow.com/questions/541693/how-can-i-specify-a-variable-file-name-using-ssis

Does the file name change according to a pattern (date, etc)? Can you calculate it? If so you can use scripts to calculate the name...

moved

It was 60F before the snow hit, a couple days in fact. Last Jan I think we averaged about 50F for the month, which is fairly warm out here. Without...

The local administrator typically doesn't have rights on another machine. The path you show is a remote machine, and that's why it is suggested that it is suggested that...

Jack Corbett (12/10/2009)

---

I should mention that it is going to be cold tomorrow. High's will only be in th mid 60's. I may break out a long-sleeved shirt...

You can change the batch size in the DTS package to a smaller number. I've done this in groups of 1000 to narrow things down, then you can change it...