I have a query that I would like to avoid hard coding. Using the following example could you give me the code to create such a variable:
where division = 'Central'
I know in MS SQL Server (T-SQL) you can say "declare @division VARCHAR(20)" and set @division = 'Central' before the query will create the variable, but that doesn't work in Teradata.
Thanks for the help.
Can you try like this. I haven't ran this but giving you the sample code snippet.
DECLARE vDivision VARCHAR(20);
SET vDivision= 'Central'
/*CALLING THE PROCEDURE*/