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
 SQL Server Development (2000)
 Stored Procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-15 : 20:35:20
ines writes "a have problems with the parameters in sp:


CREATE PROCEDURE Callstatistik(@date1 datetime, @testnumber nvarchar(500) AS
BEGIN
SELECT..
FROM ...
END
GO

EXEC Callstatistik @date1='31.01.2001 23:59:59' @testnumber='49190851712,4554,377373'

@testnumber has to be an array and i don't know how to select for example @testnumber=49190851712
or @testnumber=4554 or @testnumber=377373"
   

- Advertisement -