the modified noting 'Error converting data type varchar to bigint'

even though CompanyID is a bigint in DB:

Alter PROCEDURE [dbo].[sp_GetCompany]

@CompanyID VARCHAR(200) OUTPUT

AS

SET NOCOUNT ON;

SELECT @CompanyID = ISNULL(CAST(@CompanyID AS VARCHAR(200))+ ',', '')...

hope someone will see this though is better that i post a new thread:

i need to add a comma to each output and got this error

'Error converting data type varchar...

Glad that it works thanks!

i want to output the CompanyID from t1 that exist in t2 & t3,

if possible to create a parameter explicitly without any input of external parameter like @CompanyID

which will be...

Thanks for explaining this to me, i was quite confused as a sql newbie lol =)

i guess i tried to put "a" as a field in the column of T1 and not inside T2 & T3, it doesnt allow any form of deletion from the...

was going to put it in the SP. Thanks, it works!