‎01-31-2011 10:08 PM
‎01-31-2011 11:12 PM
‎01-31-2011 11:01 PM
CREATE VIEW dbo.web40repuserpictures
AS
Select Top 1000000 '<img src="smallthumb.aspx?user=' + tblADusers.Username + '&domain=' + tblADusers.Userdomain + '&size=32"/>' As Picture, tblADusers.Displayname, tblADusers.Firstname, tblADusers.Lastname, tblADusers.Username, tblADusers.Userdomain, tblADusers.Department From tblADusers Order By tblADusers.Displayname
GO
‎01-31-2011 10:53 PM
‎01-31-2011 10:15 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now