Hi Just have a try with the below code Create Table #softwareMeter(id Int primary key, pcID Int, softID Int, myDateTime DateTime) Insert Into #softwareMeter Values (1,100,501,'20060301 10:12') Insert Into #softwareMeter Values (2,102,509,'20060301 12:40') Insert Into #softwareMeter Values (3,100,503,'20060302 08:12') Insert Into #softwareMeter Values (4,102,508,'20060302 13:50') Insert Into #softwareMeter Values (5,103,508,'20060303 13:50') Insert Into #softwareMeter Values (6,104,509,'20060303 15:20') Insert Into #softwareMeter Values (7,105,503,'20060303 18:13') **select top 10 with ties PCID,max(MyDateTime) from #softwareMeter Group by PCID Order By PCID** The top close is a must and the number after top should be set wisely.

Hi, Take the enterprice manager and just select what all the objects you want to script and then COPY and take the query analiser or any editor and PASTE it..