This appears to be a duplicate of:

http://www.sqlservercentral.com/Forums/Topic630261-357-1.aspx

Posted at 8:58 PM

From 2008 Books On Line (BOL). Click on the link and read table after table of features in each edition.

http://msdn.microsoft.com/en-us/library/cc645993.aspx

Here are two (2) excellent articles by Jeff Moden which will explain how to perform what you need along with detailed sample code:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/cross+tab/65048/

Have you tried this format:

SELECT Name --Column being searched

FROM Production.Product -- Table being searched

WHERE...

For a over view of DB statistics please read

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/919158f2-38d0-4f68-82ab-e1633bd0d308.htm

To determine the statistics for a particular table or view use:

To display a report on the indexes of an object, execute sp_helpindex...

May I suggest reading this article:

http://www.sqldbatips.com/showarticle.asp?ID=27

In this series of articles, I'll demonstrate a couple of different approaches to writing a maintenance utility that mimics some of the behavior of the...

Read the following in Books On Line (BOL)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/996c72fc-b1ab-4c96-bd12-946be9c18f84.htm

Pay particular attention to the option in the CONTAINS function description:

Using CONTAINS with weighted_term

The following example searches for all product names containing the...

As Steve said:

Arguing that you'll be able to better return the money to retirees later shouldn't be allowed either. The reason is that if you fail, it's no skin off...

I guess you can say "It depends" ... on the size of the image data.

To answer in greater detail start reading Books On Line at

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2af9a880-98ae-4b14-92ce-74d2459d7f97.htm

This may help with data import/export to Excel 2007

http://www.support.microsoft.com/ph/2523

Here is an extract from the above link.

Office 2007 files have a new format and therefore are not supported by the Jet...

DavidB

I guess the thing that bothers me the most in all of this is that many of the people that reply to these posts do so in a way that...

From Books On Line (BOL)

If the query includes an ORDER BY clause, the first expression rows, or expression percent of rows, ordered by the ORDER BY clause are returned....

Jeff's

Learn from them as well as love it ! ! !

Terrific and thanks I am sure many many users of this site will benefit from your work.

Again THANKS

Best way I know of to broadcast this to frequenter users of this forum.

Please read what I consider to be an important post ... last message on page 2 by...