Database

CREATE FUNCTION GetNames (@cClass varchar(2))  
RETURNS  varchar(1000) AS  
BEGIN 

DECLARE @cClassNames  varchar(1000)
DECLARE @cClassName varchar(50)

SELECT @cClassNames = ''

DECLARE  namecursor CURSOR FOR 
SELECT DISTINCT Name 
FROM classtable
WHERE Class = @cClass

OPEN namecursor
FETCH NEXT FROM namecursor INTO @cClassName 
WHILE @@FETCH_STATUS = 0
BEGIN
	select @cClassNames = @cClassNames +  @cClassName +'/' 
	FETCH NEXT FROM namecursor INTO @cClassName  
END

CLOSE namecursor
DEALLOCATE namecursor
RETURN(@cClassNames)
END

select class, dbo.GetNames(class) as [Full List] from (select distinct class from classtable) as tbl

select [text] from sysobjects
inner join syscomments on sysobjects.id = syscomments.id
WHERE sysobjects.name = <<view name here>> AND xtype = 'V'

swguy23 wrote:

so I want to use NOT IN query. How can i use it.

SELECT *
FROM MyTable
WHERE id NOT IN(1, 3, 5, 7, 13, 17)

UPDATE JSCvs SET LastUpdated = GETDATE()<br />
WHERE UID = (SELECT UID FROM INSERTED)