Thank you, it worked.

I get an error message near = on last line

I basically want to say if @Component = -1 then parentTypeId In (601, 605, 606) else parentTypeId = @Component

No triggers associated with this stored procedure.

I have something like this in the stored proc:

-- table variable for the BroadView data transformed into PackagingForms format

DECLARE @BroadViewData TABLE

(

EpisodeId INT,

EpisodePackageFormatId INT,

EpisodePackageNumber VARCHAR(50),

WebTagBroadViewId VARCHAR(50),

FormatSheetBroadViewId VARCHAR(50),

OnAirOfferBroadViewId VARCHAR(50),

FundingBedBroadViewId VARCHAR(50),

FlattenedInd CHAR(1),

BroadViewId INT,

BroadViewHashCode...

The Alter Table statement succedded well.

When I expand the table columns, I already see the added columns. Is there anything ellse I need to do for the stored procedure to...

Thanks

Thanks, I tried your code and it worked.

this problem was posted long time ago. I no longer work on this project, therefore, I cannot test it.

Thank I will try it and let you know.

Your code only works if it is like this:

Declare@hostNameIP VARCHAR(1000);

set @hostNameIP = 'AMEDNBWR01C003X';

Declare@softwares VARCHAR(Max);

set @softwares = NULL;

Declare@Make VARCHAR(5000);

Set @Make = 'LENOVO';

Declare @SoftwareQuery VARCHAR(5000);

CREATE TABLE #SoftwareInfo

(

HostName Varchar(1000),

SerialNum...

Thank you, I will try your code.

Thanks. I will review your code and make ajudgestments.

Thank you. Your solution worked.

What is the string supposed to be please?