declare @a table (ID int, Val varchar(10))
insert into @a values(1, 'aaa')
insert into @a values(2, 'bbb')
insert into @a values(3, 'ccc')
insert into @a values(4, 'ddd')

Declare @ID int 
Select @ID = min(ID) from @a

While Exists(select * from @a where ID >= @ID)
BEGIN
	Select * from @a where ID = @ID
    Select @ID = min(ID)

select u.userdescription as 'username', 
       u.loginid 'login id',
       (case  
		  when max(cgm.objectid) is not null Then 'Y' 
		  else 'N' 
		end) as IsCoverageGroupMember 
from hsuser u 
left outer join hscovgroupmember cgm 
    on u.objectid = cgm.user_oid 
left outer join hscovgroup cg 
    on cgm.covgroup_oid = cg.objectid 
group by u.loginid,u.userdescription

Create function fGetMin(@A1 int, @A2 int, @A3 int, @A4 int, @A5 int)
Returns int
AS 
BEGIN
Declare @Res int
Select @Res = min(Col)
From (Select @A1 Col
      Union
      Select @A2
      Union
      Select @A3
      Union 
      Select @A4
      Union

UPDATE AST_ComputerSystem 
SET AST_ComputerSystem.Supported = '1' 
from AST_AssetWarranty
INNER JOIN AST_CMDB_Associations ON AST_AssetWarranty.instanceId = AST_CMDB_Associations.Request_ID02 
INNER JOIN AST_ComputerSystem ON AST_ComputerSystem.Reconciliation_Identity = AST_CMDB_Assocations.Request_ID01
WHERE(AST_AssetWarranty.Expiration_Date > Currentdate)

Select * from sysobjects

Select email_id from table_name where  not exists(select process_id from table_name)
Or 
Select email_id from table_name where  process_id is null

declare  @a table (CrDate datetime,  Dishes int) 

insert into @a values ('2008-09-01 00:05:04.483', 1)
insert into @a values ('2008-09-01 00:06:31.653', 1)
insert into @a values ('2008-09-01 04:35:44.983', 1)
insert into @a values ('2008-09-09 08:51:20.857', 1)
insert into @a values ('2008-09-09 08:52:08.873', 1)
insert into @a values ('2008-09-09 08:52:47.280', 1)

insert into tableA values ('NameofGuy', (Select Top 1 id from tableB where roleDescription = 'Administrator'), (Select Top 1 id from tableC where companyName = 'CompanyX'))

SELECT *
FROM (
	SELECT A.ID,A.date1,A.rmc_value,A.userid,B.formula,B.fini shedgood,B.rawmaterial,
	(SELECT C.desc1 FROM C WHERE C.ID=B.finishedgood AND B.finishedgood>0) AS f_item,
	(SELECT C.desc2 FROM C WHERE C.ID=B.finishedgood AND B.finishedgood>0) AS f_desc,
	(SELECT D.desc1 FROM D WHERE D.ID=B.rawmaterial AND B.rawmaterial>1) AS r_item,
	(SELECT D.desc2 FROM D WHERE