emi_sastra
asked on
Filter using multiple value string parameter with dynamic sql script
Hi All,
I try below code.
What I want to achieve is show data from TMBARANG that has data 'CREPE' and CREPE 1018 1380 like below code :
SELECT BARANGCODE FROM TMBARANG
WHERE BARANGCODE IN ('CREPE', 'CREPE 1018 1380')
How could I do it ?
Thank you.
I try below code.
declare @Barangcode VARCHAR(100) = '''CREPE'', ''CREPE 1018 1380'''
DECLARE @SQL VARCHAR(MAX) = '
SELECT BARANGCODE FROM TMBARANG
WHERE BARANGCODE IN
(
SELECT ''' + REPLACE(@BarangCode, '''', '') + '''
)
PRINT @SQL
EXECUTE (@SQL)
What I want to achieve is show data from TMBARANG that has data 'CREPE' and CREPE 1018 1380 like below code :
SELECT BARANGCODE FROM TMBARANG
WHERE BARANGCODE IN ('CREPE', 'CREPE 1018 1380')
How could I do it ?
Thank you.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Icohan,
Thank you very much for your help.
Thank you very much for your help.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
In my case what should I do ?
Thank you.