And I see you are a fellow Italian... Gratzi.

Thank you very...

Thank you all, but we are rewriting it...

Cheers,

~D

Sean Lange (9/12/2011)

---

If you want to return a varchar value you have to use an output parameter or make your last statement in the procedure a select statement. SQL returns...

Yes. I can modify it... I know it is a matter of also getting it to return a varchar instead of an int as well...

Then once again, I feel I am at an impasse of sorts... how can I get the date from the case statement at the end of my sproc?

Here is the...

Thank you for your response, but I do not think I am doing this right... it is a little hard for me to understand right now given the context of...

Thank you very much and I apologize for my ignorance when it comes to this, but given my sproc that I have posted... if you look at the end in...

I would like to return a varchar, but I am not sure how I would do that... I did not write the sproc.

I'm sorry... then what would I do then if I wanted to return a varchar(30)?

Thank you very much... here is the sp:

USE [TransactionalData]

GO

/****** Object: StoredProcedure [dbo].[COB] Script Date: 08/30/2011 16:12:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[COB]

@ItemCode varchar(50) =...

You have...

Thank you. I plan on cleaning it up in a bit...

Nevermind... I needed END at the end....

GSquared (3/30/2011)

---

Have you tried changing the char(13) + char(10) to < br >? (Without the spaces, of course. Forum software wants to consume the tag if I type it...