Trying to find definition for a return vaue of -6

I am receiving a return value of -6 from the attached SQL Server 2016 stored procedure.  Is there a list of return values and what they mean.  I haven't found any.
Juan VelasquezAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
which attached SP?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Juan VelasquezAuthor Commented:
Here is the attached file.  Sorry about that.
Juan VelasquezAuthor Commented:
It looks like I found the problem.
The -6 return value was generated in the following section of the stored procedure.  It was caused by a data issue where the value for itemclass and itemsect was '??'.  The convert function or concatenation process didn't know what to do with a value of ??
However a list of return values and their meanings would be helpful

		SELECT dbo.vw_LIS005MAST_Item.ItemClass, dbo.vw_LIS005MAST_Item.ItemSect, 
		LTrim(RTrim(dbo.vw_LIS005MAST_Item.Itm)) AS Item, 
		CONVERT(Varchar(10),dbo.vw_lis005mast_item.[itemclass]) + CONVERT(VARCHAR(10),dbo.vw_lis005mast_item.[itemsect]) AS Class, 
		dbo.vw_LIS005MAST_Item.IiDesc, LTrim(RTrim(dbo.vw_LIS005MAST_Item_UOM.[UOM])) AS PUOM
		FROM dbo.vw_LIS005MAST_Item 
		INNER JOIN dbo.vw_LIS005MAST_Item_UOM ON dbo.vw_LIS005MAST_Item.Server = dbo.vw_LIS005MAST_Item_UOM.[Server]
			AND dbo.vw_LIS005MAST_Item.Itm = dbo.vw_LIS005MAST_Item_UOM.ImItm WHERE dbo.vw_LIS005MAST_Item.ItemClass NOT like 'Kit%'
		ORDER BY dbo.vw_LIS005MAST_Item.ItemClass, dbo.vw_LIS005MAST_Item.ItemSect, LTrim(RTrim(dbo.vw_LIS005MAST_Item.[Itm]));

Open in new window

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Éric MoreauSenior .Net ConsultantCommented:
what does your SP returns? Do you have a "RETURN @variable name" at the end of your SP?
Jim HornMicrosoft SQL Server Data DudeCommented:
chtullu135 - I really recommend taking a step back, gathering your thoughts, and then re-ask your question with enough supporting details for experts to provide an answer.  

Keep in mind that experts here cannot connect to your data source(s) and run queries, and since we don't work at your company have no idea about company-specific terms.
Juan VelasquezAuthor Commented:
I was just looking for a list of return values and what they mean. That's all I was looking for.  I don't need any help in finding the problem in the code.  I was looking online and could not find such a list.  For example, what does a return value of -6 mean. I do not need any assistance in troubleshooting the actual problem.  I only supplied the code to provide context. Come to think of it, I think I saw such a list in one of my books at home. I will close this question.
Éric MoreauSenior .Net ConsultantCommented:
I suspect that you are returning this value, this is why I asked the questions here above!
Juan VelasquezAuthor Commented:
Not a problem Eric.  Thank you for your help.  The procedure ran without throwing an error.  I then ran each of the sql statements until I reached the one that was causing the problem which was the one above.
Juan VelasquezAuthor Commented:
Thanks for your help, it helped clarify the issue which was caused by a datatype conversion error
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Stored Proc

From novice to tech pro — start learning today.