Archives of the TeradataForum
Message Posted: Thu, 20 Jan 2011 @ 18:23:20 GMT
Dear esteemed listers,
Thank you for answering my previous questions.
When I run this SQL I get an error message saying, 'Query ends within a string or common block.'
select ' Weekly Security report for the week of ' (title ''), cast((date - 7 (format 'ddBmmm')) as varchar(20)) (title ''), ' - ' (title ") , cast((date (format 'ddBmmmByyyy')) as varchar(20)) (title '');
i) I'd like to put a dash (-) between two dates. But when I add '-' (title "), this SQL doesn't run. What should I change to make it run?
ii) How can I have a two line output such as
Weekly Security Report for the week of XXXX - XXXX
iii) Is there a command to put the title to the center of the document?
Thank you for your helps.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|