I have a string variable, SourceSQL, as follows:
"select PHDPLANNBR, PHDPLANDSC, PHDSTRDATE, PHDENDDATE
FROM " + @[User::JDAR6LIB] + ".PROHDR WHERE PHDPLANNBR IN (" + @[User::Promo_Code] +
I execute this on an AS/400. The problem is the PHDPLANNBR was hardcoded into the statement. However, now we want to populate the Promo_Code variable first with one or more promo codes from data in a SQL Server.
How can I do this?
View Complete Post