I need to specify group in the following report how I can do it
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysOS.OSname, tblAssets.Username, tblAssets.IPAddress, tblAssets.Description, Max(Convert(date,tblQuickFixEngineering.InstalledOn)) As lastPatchDate, tblAssets.Lastseen, Case When...