Feeds:
Posts
Comments

Archive for March, 2008

var tl:TileList = TileList( event.currentTarget );
var thumb:Thumbnail = Thumbnail(tl.indexToItemRenderer(ind));
var img:Image = thumb.image;

Advertisements

Read Full Post »

SET NOCOUNT ON

CREATE TABLE #RowNumber (
RowNumber int IDENTITY (1, 1),
emp_id char(9) )

INSERT #RowNumber (emp_id)
SELECT emp_id
FROM employee
WHERE job_id = 10
ORDER BY lname

SELECT RowNumber, e.emp_id, lname, fname, job_id
FROM #RowNumber r JOIN employee e
ON r.emp_id = e.emp_id
ORDER BY RowNumber

DROP TABLE #RowNumber

SET NOCOUNT OFF

Read Full Post »