Procedure has too many arguments

Question

Post reply

Procedure has too many arguments

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 1

I solved it. I was passing @CandID in the where cond. That was passing null.

Thanks.

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 2

Glad.

Enjoy.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

Andrew Watson-478275 SSCarpal Tunnel Points: 4652 More actions · Answer 3

If you're getting the "1" printed, but not "uniqueno = "+@uniqueno then the error has to be one of these lines:

SELECT @uniqueno = ResumePrefix+ResumeSuffix+ResumeLastNo FROM HC_SYSCONFIG

UPDATE HC_SYSCONFIG SET ResumeLastNo = ResumeLastNo + 1

We'll need to know the definitions of those fields.

I'd guess that ResumePrefix, ResumeSuffix and ResumeLastNo are a mixture of numeric and varchar data, and some data in there's causing an implicit conversion to fail.

myheadhurts Ten Centuries Points: 1262 More actions · Answer 4

This looks problematic:

DECLARE @ResumePrefix VARCHAR(50)

DECLARE @ResumeSuffix VARCHAR(50)

DECLARE @ResumeLastNo BIGINT

DECLARE @uniqueno varchar(50)

SELECT @uniqueno = ResumePrefix+ResumeSuffix+ResumeLastNo

-MarkO

"You do not really understand something until you can explain it to your grandmother" - Albert Einstein