If you were to execute the procedure I posted above in SSMS, this is how you would do it:

declare @id int,

@uname varchar(50),

...

This is how I would write the procedure:

alter procedure [dbo].[checkComms]

@CommID int,

@username varchar(50),

@status varchar(200) OUTPUT

as

begin

...

Can you tell me more about the configuration of the server all of this is running on?

Had an idea for SQL Server 2005. This WON"T work on SQL Server 2000. Please give it a try, and let's see what happens.

select

*

from

...

While you are capturing the Execution Plan, could you post the complete query code you are running and the DDL (Including indexes) for the two tables.

From what I can tell,...

I came up with another option, and I think it is easier. It uses patindex to find the first non-zero character.

select substring(@varstr,patindex('%[^0]%', @varstr),len(@varstr) - patindex('%[^0]%', @varstr) + 1)

I guess not enough people complained about the answer to this question.

I have to agree with Jeff. This was an awesome thread and it demonstrates what a community can do when it works together for a common purpose. Hats...

See if you can use this code to strip leading zeros and if it helps your query.

declare @varstr nvarchar(50);

set @varstr = '000045691823';

select substring(@varstr,patindex('%[A-Za-z1-9]%', @varstr),len(@varstr) - patindex('%[A-Za-z1-9]%', @varstr) + 1)

set @varstr...

You should still be able to use the code sample above to develop a solution to your problem at work.

Looks like another "cursor man" out there if you...

May I suggest you read this article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Also you may want to read this blog: The Flip...

Does this help?

create table dbo.xtable (

ID int,

val1 varchar(30) null,

val2 varchar(30) null

);

create table #tmp (

ID...

Well, you need to provide a clearer picture of what you...

Not...