Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Can I use variables in the 'sql after' tab of MS SQL writer?

Can I use variables in the 'sql after' tab of MS SQL writer? 3 months 3 days ago #19756

  • JohnIngles
  • Topic Author
  • Away
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 0
Say if I set variable <FileDate> = 2020-02-28, can I then use it in the "SQL After"

UPDATE table1
SET table1.[End_Date]=<FileDate>
from table1 atr
left outer join table2 tmp
on atr.URN = tmp.URN
where tmp.URN is NULL;

Please Log in or Create an account to join the conversation.

Can I use variables in the 'sql after' tab of MS SQL writer? 3 months 3 days ago #19757

That should work.
Remember all variables are strings so put them in quotes when necessary
Peter Jonson
Support Analist

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 116 guests and one member online