Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Function

Author  Topic 

ermese
Starting Member

5 Posts

Posted - 2004-11-03 : 03:16:49
CREATE FUNCTION TestSatir
(
@SARJNO nvarchar(30),
@TestNo nvarchar(60)
)
RETURNS Table
As
DECLARE @SQL varchar(600)
SET @SQL =
'Select * From TestSatirSutun WHERE SARJNO='+@SARJNO+' and ISLKOD IN('+@TestNo+')'
RETURN(@sql)

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-11-03 : 03:21:25
triplicate post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42065

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -