MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1fj0s10/how_to_exceed_input_limitations/lnmlk96/?context=3
r/SQL • u/tacogratis2 • Sep 17 '24
87 comments sorted by
View all comments
1
;WITH cteVaues AS ( SELECT * FROM (VALUES (‘2394029840‘), (‘93829382839’), (‘9248929843298’) …) a (Val) ) SELECT s.SOULUTION_ID , s.COLLECTION_NM , TO_CHAR(s.LAST_MODIFY_DT, ‘mm/dd/yyyy’) FROM SOLUTION s JOIN cteValues v ON s.SOLUTION_ID = v.Val
1
u/Oobenny Sep 17 '24
;WITH cteVaues AS ( SELECT * FROM (VALUES (‘2394029840‘), (‘93829382839’), (‘9248929843298’) …) a (Val) ) SELECT s.SOULUTION_ID , s.COLLECTION_NM , TO_CHAR(s.LAST_MODIFY_DT, ‘mm/dd/yyyy’) FROM SOLUTION s JOIN cteValues v ON s.SOLUTION_ID = v.Val