sorte.orm (11/5/2009)

---

I asked why "select *" is such a bad thing, and as far as I can tell there has not been any single answer that was good imho. ...

Thanks Leon, Richard, Ian, Malcolm, Martin, Derek, Tim, Aleksandr, Margarity, and Adrian for you methods on bringing in a file list. Ian especially as this trick is neat and...

Agree that presentation software is great for presenting end results data, but in some instances you want to have pre-filtered the results from your database via the underlying SQL. ...

Firstly my apologies for not responding sooner

Secondly, thank you all for the marvellous responses and ensuing competition.  Sadly I must now say my...

Good article, I learned something about OPENQUERY, which I had not used before.

A few things I have identified while doing linked server queries. 

• Queries run over the local server linking...

Hi Tao, did you post the correct version of your code?

I copied your code above and did a find/replace on #SequenceTable and SeqNumber swapping these for my table name and...

Many thanks for both these responses.  I have been able to see how both work, and made use of them successfully.

The problem with these as a method, as compared to...

Thanks all for the great examples of other ways to get the same results.  It is interesting to see these different methods and the understandings of...

There is a problem here I believe in that if the data itself contains commas it will throw the rows out when converted into Excel.  The best way I have...

I'll have to tweek my own code as for some reason I was sure I could only have one parameter.  Thanks for this.

Having spent time reading all the posts I've now forgotten what the last column was in the table design.  Needless to say this column represents a flaw in the authors...

I've seen this in off the shelf software and fully agree with you.

Cheers

Stephen

Hi, good article. Just something you may like to consider mentioning. I have seen this problem several times now and it allows potential for system misuse. The...

Thanks for the feedback. The typo occurred in translation from the submitted MS/Word document to the HTML page and was an accident by the publisher that I did not...

Hi, you could check out the Redbooks at http://www.redbooks.ibm.com/cgi-bin/searchsite.cgi?query=SQL

You can view all the redbooks online or download them at no cost, or purchase from IBM on CD-ROM.

There is...