Thanks Luke L & SQBill -

I picked this from SQL Profiler when Opening SQL Server Management Studio. I knew that it gives 9 with SQL 2005 and 8 with...

OPENDATASOURCE: It Is a one way to work with Excel or other third party Data in SQL. Some how U may utilize it.

Query - The reference Book: Microsoft SQL Server 2005...

HI I'M SENDING U SAMPLE QUERY - HOPE IT WILL WORK BUT THERE WILL BE ANOTHER PROBLEME WHEN U'LL CHANGE SECOND FIELD OTHER THAN INT. I'LL POST THAT SOLUTION TOMARROW....

Can U send me a complete Query.

I would like to see another one named query field

If it is like this....

CASE DatePart(dw, reporting_date) -- for week day name

         WHEN 1 THEN '1'

         WHEN 2 THEN '2'

        ...

U must follow ---> Change the field back to int, make sure they are still indexed (if they were before).  And never let the client again decide of the DB...

I'm agree with SQLBill

Why don't you test it yourself?

But Ok Sending U another simple way...

SELECT

 tblSales.FruitID,

 tblSales.Date,

 tblSales.Volume,

 tblSales.Price,

 tblFruit.FruitDescription

FROM

 tblFruit

 INNER JOIN tblSales

 ON TblFruit.FruitID = tblSales.FruitID

WHERE...

Hi Dear Suppose there is three tables eg.: Table1..2..3

and One has 5 Columns, Two has 6 columns and Three has 9.

And here I supposed to there is some Link column...