Still working on indirection query

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Still working on indirection query

Message

From

05/02/2007 10:02:10

Alex Feldstein
Florida, United States

05/02/2007 09:51:33

Borislav Borissov
Microcomplex
Sofia, Bulgaria

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Still working on indirection query

Environment versions

SQL Server:

SQL Server 2000

Miscellaneous

Thread ID:

01192348

Message ID:

01192396

Views:

>Remove table_w_data from your first query:
>
>cSQL = 'SELECT @Column2Get3=' + @Column2Get1 + ', @Column2Get4=' + @Column2Get2 > ..... >

When I do I get:

"Must declare the variable '@Column2Get3'."

which I guess it means a scope problem as it runs in a separate batch.

Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery

"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry

Map

View

Click here to load this message in the networking platform