Database

declare @t table(childid int,name varchar(20),code int,parentid int)
insert into @t values (6219,'HBO',02,0)
insert into @t values(6220,'HBO1', 0201,6219)
insert into @t values(6221,'HEAO',0202,6219)
insert into @t values(6222,'HTS',0203,6219)
insert into @t values(6231,'MEAO',0403,6228)
insert into @t values(6232,'MTS',0404,6228)
insert into @t values(6234,'Midde',05,0)
insert into @t values(6235,'Overi',06,0)
insert into @t values(6228,'MBO',04,0)
insert into @t values(6236,'WO',10,0)
insert into @t values(6237,'Post',07,0)
insert into @t values(6239,'Basi',NULL,NULL)
insert into @t values(6448,'Athe',05001,6234)
select * from @t

;with cte as
(
	select 
		cast(t1.childid as varchar(1000)) [path]
		, t1.childid
		,t1.name
		,t1.code
		,t1.parentid 
		,0 AS [Level] from @t t1 where parentid =  0 or parentid is null

	union all
	select 
		cast([path] + '/' + cast(t1.childid as varchar(1000)) as varchar(1000)) [path]
		,t1.childid
		,t1.name
		,t1.code
		,t1.parentid 
		,c.[Level]+1 AS [Level]from @t t1
	join cte c
	on c.childid = t1.parentid
)
select childid,name,code,parentid
from cte order by [path]

childid	name	code	parentid
6219	HBO	2	0
6220	HBO1	201	6219
6221	HEAO	202	6219
6222	HTS	203	6219
6228	MBO	4	0
6231	MEAO	403	6228
6232	MTS	404	6228
6234	Midde	5	0
6448	Athe	5001	6234
6235	Overi	6	0
6236	WO	10	0
6237	Post	7	0
6239	Basi	NULL	NULL

declare @t table(activity varchar(10),datecol datetime)
insert into @t 
	select 'activity1', '2009-12-01' union all
	select 'activity2','2009-12-02' union all
	select 'activity3','2009-12-15' union all
	select 'activity4','2010-01-02' union all
	select 'activity5','2009-12-31'

declare @date1 datetime,@date2 datetime
set @date1 = '2009-12-01'
set @date2 = '2009-12-15'

select * from @t
where datecol between @date1 and @date2

activity1	2009-12-01 00:00:00.000
activity2	2009-12-02 00:00:00.000
activity3	2009-12-15 00:00:00.000

CREATE PROCEDURE usp_GetDataFromDateRange(
  @Start DATETIME,
  @End DATETIME
)
AS
BEGIN
  SET NOCOUNT ON;

  SELECT * FROM MyTable
    WHERE DateCol BETWEEN @Start AND @End

  RETURN

END

AndyInUK wrote:

where id = 'GHREFC5C-GT5F-43RF-GRT4-TGREW34TGY67' and id <> '4RT467YH-RF43-45FH-78YG-54RYG6THYR43'

SELECT *
  FROM [dbo].[A]
 WHERE id = 'bla'
  AND id NOT IN (
      SELECT [id]
        FROM [dbo].[C])

I are Troll

declare @t table(username varchar(50),userid varchar(100))
insert into @t 
	select 'username1','a' union all select 'username1','b' union all
	select 'username1','c' union all select 'username1','d' union all
	select 'username2','a' union all select 'username3','b' union all
	select 'username3','c' union all select 'username3','d' union all
	select 'username4','a' union all select 'username4','b' union all
	select 'username4','c' union all select 'username5','d' union all
	select 'username6','a' union all select 'username7','b' union all
	select 'username8','c' union all select 'username8','d' 

username	userid
username1	a
username1	b
username1	c
username1	d
username2	a
username3	b
username3	c
username3	d
username4	a
username4	b
username4	c
username5	d
username6	a
username7	b
username8	c
username8	d

select username from  @t
except
select username from @t
where  userid in('b','c','d')

select t1.username from  @t t1
left join (select username from @t where  userid in('b','c','d')) x
on x.username = t1.username
where x.username is null

select username from (
select username, 

	stuff((select ',' + CAST(t2.userid as varchar(max)) from @t t2
	where t2.username = t1.username for xml path('')),1,1,'') as userids
from @t t1
group by username )X
where X.userids = 'a'

username2
username6