Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Dynamic where

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-02 : 07:18:04
Robby writes "I have two table: A, B

A.= AFIELD1, AFIELD2
Val1.1, Val2.1
Val1.2, Val2.2
Val1.3, Val2.3
..... .....
Val1.n Val2.n

B.= BFIELD1, Val2.1, Val2.2, Val2.3,...,Val2.n


how make a dynamic statament that has in where clause the value of the column AFIELD2 of the first table?"

Amethystium
Aged Yak Warrior

701 Posts

Posted - 2004-06-02 : 07:24:46
http://www.sqlteam.com/item.asp?ItemID=2077

_________________________________________________________
The cradle of civilisation will defeat the new monsters of the world.
Go to Top of Page
   

- Advertisement -