It works, thanks.

Corrected it in the c# program before calling the stored proc.

Thank you, yes, I just came around the problem with the same type of solution.

Something like : str(cast('252536e+003' as real) )

Thanks again.

drew.allen : yes, tweaked it a bit but this works fine.

Thank you all for your help.

Yes, that is part of the problem, unfortunately, we cannot change this and add a unique constraint.

Only one line of each user in the Users table.

Here's the sample code :

CREATE TABLE [dbo].[Users](

[ID] [int] IDENTITY(1,1) NOT NULL,

[UserName] [varchar](20) NULL,

[Email] [varchar](20) NULL,

CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

My bad, wrote the post too quickly, I edited the original post, I was missing the UserId and corrected the INNER JOIN clause.

Phil Parkin : well, the tables are simplified but it's almost as is in terms of structure.

Thanks guys, I just added the SELECT COUNT(*) = ... at the end of...

Thanx, exactly what i needed.

Found the topic : http://www.sqlservercentral.com/Forums/Topic775518-146-1.aspx?Update=1

Thanks

Where can I find that 'Schema Changes History' report for that database?

I searched everywhere, to no avail.

Thanks

Indeed, I thought the error I was receiving...

Hi Lowell,

Almost works, Error : Msg 7411, Level 16, State 1 Server is not configured for RPC

Found this article :

http://blog.sqlauthority.com/2007/10/18/sql-server-2005-fix-error-msg-7411-level-16-state-1-server-is-not-configured-for-rpc/

But the server referenced as the 'linked server' is...

Hi kalyanp79,

It...