Simplicity is the golden rule in sql server.

He'll get this eventually. Maybe after 2-3 weeks of trying to make this work ...

I assume that there are more that he didn't pick up yet.

Way to stick it in there .

I feel I must point this out at this point.

When you...

I can't stay that patient when someone snaps at me .

That's why I didn't tell him that this proc is crap...

There's no initial condition for this statement :

END If

ElseIf (

BTW thoses error are impossible if you are calling the query from the right db. The query gave me actual results.

Please post the results it gives you vs the ones you want to receive.

DECLARE @RETURNVAL AS smallint

EXEC @RETURNVAL = dbo.SP_NEXTUSER

Can you post the proc code??

Also why use dynamic sql in this case?

Is the db in single user mode?

"Both think mimes are funny, I rest my case."

Don't generalise to myself. I'm different, just like everybody else .

Why wouldn't someone who's more...

how about

SELECT dbo.Product.ProductID, dbo.Categories.ProductCategoryID, dbo.Categories.ProductCategoryName, dbo.Product.CompanyID

FROM dbo.Product INNER JOIN

...

Sure :

What's the number and name of your boss?

I'm not french, I'm french canadian. You can't imagine how different those two cultures are.

That never worked on me and that never will.

Now go finish your reports or you'll see what real world consequences are.