I see two data type mismatches involving the @User_State and @User_YOB parameters. The stored procedure uses unicode character data (nchar), while the ASP code is creating numeric parameters. If the stored...

You can test whether the current user is a member of the sysadmin role using the IS_SRVROLEMEMBER() function.

IF IS_SRVROLEMEMBER('sysadmin') = 0  -- =1 if a member of role

B

Are you running the Windows Firewall?  If so, check out this KB article:

http://support.microsoft.com/default.aspx?kbid=841251

By default, ports used by SQL Server are blocked.

I assume you've successfully compiled the SP and tested it within Query Analyzer. The problem is most likely in the call from your ASP page. Are you sure you've included...

David,

I have firefox installed on a test server (just a Dell 4300 with 512MB RAM) running Windows 2000 Server SP4 and SQL Server 2000 SP3. I've haven't experienced any problems...

Jeff, you are correct. That's what happens when Frank gets everybody excited about an issue. Jumped the gun a bit on that. 

Frank, I understand the issue you bring up. It depends on the business rules for that the particular application. I think the method that you originally posted requires that non-numeric...

Obviously, there are many ways to do this. Still another method:

CREATE FUNCTION dbo.PadLeft

(

  @theField varchar(1000),

  @padLen smallint,

  @padChar varchar(1)

)

RETURNS varchar(1000)

AS

BEGIN

  RETURN Right(Replicate(@padChar, @padLen) + @theField, @padLen)

END

GO

CREATE TABLE #Test

(

  col...

How about this:

CREATE TABLE #Test

(

  col varchar(10)

)

SET NOCOUNT ON

INSERT #test VALUES ('11')

INSERT #test VALUES ('10')

INSERT #test VALUES ('2')

INSERT #test VALUES ('3')

INSERT #test VALUES ('1')

INSERT #test VALUES ('3C')

INSERT...

Here's a link to a previous question in which I posted some code I use.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=143488#bm143900

Here is an expanded example showing how to use the UDF to INSERT or UPDATE rows in a table.

DROP TABLE SlowThinker

GO

DROP TABLE TheData

GO

CREATE TABLE SlowThinker

(

 ...

Here's an expanded example showing how you could insert rows into a new table while parsing, or update existing rows with the parsed data.

DROP TABLE SlowThinker

GO

DROP TABLE TheData

GO

You can't select multiple rows into a local variable like that.

  DECLARE @s-2 varchar(1000)

  SELECT @s-2 = ExData FROM SlowThinker

I ran this:

DROP TABLE SlowThinker

GO

CREATE TABLE SlowThinker

(

  id...

>excuse my stupidity, but when I try to replace the @s-2 with the field that

>contains this string I'm trying to parse, all it seems to grab is one record

Make sure...

I use the following stored procedure for cases similar to yours. It returns the "next" (leftmost) token, then strips that token from the source string (@s). In the loop example, I...