Need help with a syntax error 1

[crystalb24]

I'm fairly new to setting up stored procedures and I'm running into a syntax error that I don't understand.

"Incorrect syntax near '@MSBP1'.
Must declare the variable '@MS'."

Can anyone help me figure this out?

~Crystal
Click here (

http://www.freeiPods.com/default.aspx?referer=7003325)

for a free iPod

 

[dbomrrsm]

would need to see the code - post it and I am sure you will get assistance.

[blue]DBomrrsm[/blue]

 

[SQLSister]

If you right click on the error message, the locate error function willtake you to where the error is.

Questions about posting. See faq183-874

 

[donutman]

What I don't know scares me! Nice tip SQLSister.
-Karl

 

[SQLSister]

Hey I learned that one here about 1.5 years after I started using SQL Server.

Questions about posting. See faq183-874

 

[vongrunt]

Heh... I learned that about 1.5 minutes ago. Like it, tnx.

Btw. double-click does the same.