Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using main query columns in declare section

Status
Not open for further replies.

BTrees

IS-IT--Management
Aug 12, 2006
45
CA
Hi,

In a sql query, can i reffer columns/tables from main query.
Please help. thanks
 
The DECLARE section is for variables that will be used within the T-SQL process, including those that store database columns that are referenced in SELECT statements. It's probably too complex to describe in this setting. Have you looked at samples of code both here at tek-tips and on the internet?

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top