The derived table below doesn't have a join to the other tables, as far as I can see, although some DDL would help if that isn't your issue. I'm assuming you...

Post the code you have so far and we can tell you what areas of BOL you need to research to figure out the rest.

Yeah, this really needs to end up in a sticky somewhere in the forum (maybe an FAQ?). If your search results aren't fruitful, this is the last post that...

Even with a clustered index, doesn't MS claim that there is no guarantee that they'll be in the order you want without the ORDER BY? I'm thinking specifically of caching...

If you're familiar with bcp, you should be able to go that route in 2005, and thus temporarily put off learning SSIS, but you'll eventually want to bite the bullet...

The only issue I have with your otherwise valid complaint is that in the SQL Server world, far more so than in the Oracle world, there is often a need...

In almost every one of his threads, I am tempted to ask where he works (he claims that this stuff isn't homework). I'm betting I could bill them insane amounts...

In addtion to what mrpolecat said, if you only need this in reports, most reporting tools (including Reporting Services) can do this with your data as it is currently. It's...

We create the datasource in the code that wraps around our reports, and it gets its connection string from a web.config file, thus allowing us to simply change web.config settings...

Are you trying to create them while remoting into the server, or on the server box directly? If not, try that first.

Very nice work, Jeff!

I didn't know that I stated any reasons (I'm guessing you are commenting on my references to indexes, but to me they're a wash, as they are...

My understanding (I haven't had a need for it yet) is that once they are in the body, you can hide them there, and then reference the textbox in the...

I don't speak Portugese, and I can't test this, but won't this do the trick for you? By the way, for those following along, he wants to create a row...

May I ask why they refused to help you? You said you are licensed for 2005, and they do allow "Downgrade Rights" for previous versions under those circumstances. It should...

I'm not John, but I'm pretty sure he's using the two innermost casts to guarantee you don't get the int division issue, where the results are also an int. For...