Select b.Topic, c.CompanyName, cast(a.Rating as int) as 'Cumulative Rating'

from InfoTable a

Left Join Topic b On a.TopicID=b.TopicID

Left Join Company c on a.CompanyID=c.CompanyID

--where b.ProjectID=1

Group by b.Topic,c.CompanyName

Hi

Can you please give somple data and result that you want from that..?

set nocount on

Declare @TableName varchar(128), @ColumnList varchar(1000)

Declare @SQL varchar(1000)

set @TableName = 'your Table'

SELECT @ColumnList = COALESCE(@ColumnList + ', ', '') + column_name

FROM INFORMATION_SCHEMA.Columns

WHERE Ordinal_position <= 95

and table_name = @TableName

Set...

Thanks lot. Its working fine.. David Burrows 

CallDate belongs to Modifiedcalldata

select * from #Parent p join  #Child c on p.IdentityField = c.ForeignKey  and recencydate =

(select max(recencydate) from #Child d where d.ForeignKey= p.IdentityField)

I hope this will do...

exec sp_Executesql 'N(@SQL) -- (N stand for Nvarchar)

As per your example this will do

SELECT Inv_Date, Inv_No, Description, SUM(Amount)

FROM #Trans

GROUP BY Inv_Date, Inv_No, Description

Inv_Date                  Inv_No Description  Sum  

2005-11-19 13:10:00 1         The 1           11

2005-11-19 13:10:00 2         The 2          ...

If we see the cursor that you have wrote then explicitly there are some errors,but first i would like to know what you would like to do.. i mean can...

Hi all

 i got it.. this is the query...

select * from sales M where keyid IN

(select top 2 keyid from sales M1

where  m.saleperson =m1.saleperson )  

thanks all

Hi Kenneth

        In the sales table we have nearly 5,00,000 lac records. It's impossible to check all the records. So that he just pick any two records for quality checking.

       Franks...

And i also tried using this

select top 2* from sales M where keyid IN

(select top 2 keyid from sales M1

where  M1.keyid=M.keyid and m.saleperson =m1.saleperson )  

But the above...

Thanks for your response

 Just for Analysis purpose, Some time sales manager wants to check some data (for quality). So SM just wants any two (or top 2) records.

update a set a.MyNewColumn = b.MyOldColumn from table1 a , table2 b where a.<keyfield> = b.<keyfield>

 Please try this

select top 0* into <new table> from customer