Placing Notes In Sql Statement

Anyone know how to place not functional "NOTES" in an SQL statements like the authors name or to note functionality?? thanks GRTTry using --
:D|||thanks works great!|||Just as an fyi, you can highlight entire lines in Query Analyzer and use these:

CTRL+SHIFT+C --Comments everything.
CTRL+SHIFT+R --Removes comments from everything.

This is great when you are troubleshooting or want to just type then highlight and comment.|||whenever you ask a question like this in the generic SQL forum, you need to specify which database system you're using

and you guys who give a database-specific answer to a generic question should preface your remarks that way

for example, if you're using microsoft access, you can't put comments in the sql at all

if you're using microsoft sql server, the double dash works, and so does /* comment */

guess which database allows //|||whenever you ask a question like this in the generic SQL forum, you need to specify which database system you're using
That's right. Repeat after me: "Microsoft SQL Server and SQL are not the same thing"...|||-- supposed to be ansi standard.
:rolleyes:|||PL SQL developer oracle version 9i

pivot table drag and drop

Is there anyway to extend the functionality of a matrix report to allow drag and drop functionality simialr to Excel?In short, no. I guess report builder is as close to what you describe as possible. You could also try to make it work using parameters but no drag and drop.