Archives of the TeradataForum

Message Posted: Fri, 20 May 2011 @ 09:19:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If you only need to run the code in SQL Assistant then the following will work. You will be prompted for a parameter to replace the text "?hcclSchema" wherever it occurs. I think that this will not work outside of SQL Assistant. In Crystal Reports you would enter your parameter as {?hcclSchema}--adding the braces.

     SELECT *
     FROM ?hcclSchema.PATIENT

Thanks,

Ben Ford

	<Prev	Next>		<<First	<Prev	Next>	Last>>