>>Using macro substitution inside a query is a bad idea anyway because it forces SQL to evaluate the macro for every row, and slows the query dramatically. HTH
>
>Erik, are you sure about this? If yes, then try some quick test.
>Actually, this is UDF which might be evaluated for each row.
Ed, Thanks, but how can I look at the SQL statement while it is running? I know this isn't the best way to use SQL, but this way give the user more flexablity.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only