{"id":493977,"date":"2026-06-14T10:17:00","date_gmt":"2026-06-14T10:17:00","guid":{"rendered":"https:\/\/livelycity.com\/switzerland\/sap-hana-sql-query-with-dynamic-placeholder-stack-overflow\/"},"modified":"2026-06-14T10:17:00","modified_gmt":"2026-06-14T10:17:00","slug":"sap-hana-sql-query-with-dynamic-placeholder-stack-overflow","status":"publish","type":"post","link":"https:\/\/livelycity.com\/switzerland\/sap-hana-sql-query-with-dynamic-placeholder-stack-overflow\/","title":{"rendered":"SAP HANA SQL Query with Dynamic Placeholder &#8211; Stack Overflow"},"content":{"rendered":"<p>4 I have a query that is passing the current year as a placeholder parameter that right now is hard coded. How can I have this just pass the current year? I&#8217;ve seen a few different potential solutions but most of them are in HANA Studio or involve dynamic SQL generation. I&#8217;m putting the SQL into Tableau so those are both off the table.<\/p>\n<p><a href=\"https:\/\/stackoverflow.com\/questions\/49615710\/sap-hana-sql-query-with-dynamic-placeholder\" target=\"_blank\" class=\"\">https:\/\/stackoverflow.com\/questions\/49615710\/sap-hana-sql-query-with-dynamic-placeholder<\/a>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>4 I have a query that is passing the current year as a placeholder parameter that right now is hard coded. How can I have&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[13],"tags":[],"class_list":["post-493977","post","type-post","status-publish","format-standard","hentry","category-kunsthaus-zurich-en","wpcat-13-id"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/posts\/493977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/comments?post=493977"}],"version-history":[{"count":0,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/posts\/493977\/revisions"}],"wp:attachment":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/media?parent=493977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/categories?post=493977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/tags?post=493977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}