Database

SELECT top 10 A.artist, A.title, A.count_played, B.MaxDate 
FROM dbo.songlist A 
INNER JOIN (
     SELECT count_played, MAX(date_title_played) AS MaxDate 
     FROM dbo.songlist 
     GROUP BY count_played 
) AS B 
ON A.date_title_played = B.MaxDate
WHERE count_played >0
ORDER BY count_played DESC, date_title_played DESC

SELECT top 5 A.artist, A.title, A.count_played, B.MaxDate FROM dbo.songlist A INNER JOIN (SELECT count_played, MAX(date_title_played) AS MaxDate
FROM dbo.songlist GROUP BY count_played ) AS B ON A.date_title_played = B.MaxDate
WHERE B.count_played >0
ORDER BY B.count_played DESC, date_title_played DESC

UPDATE tablename SET [time]='12:34' where id=80

clng(right(FIELDNAME, len(FIELDNAME)-instr(FIELDNAME, "TU")))

iramirezp wrote:

Create Procedure sp_stored1
@intVariablex int

iramirezp wrote:

Create Procedure sp_stored2
intVariabley int

update A set name = (select top 1 Name from B where B.barcode = mid(A.code,1,8))