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)
 Problem with Views!

Author  Topic 

mibheenick
Starting Member

12 Posts

Posted - 2005-08-26 : 06:32:57
Hi everyone out there!

I have a View(vw_A) which return me values like the following:

Num1 Typ1 Num2 Typ2 Num501 Typ501
---- ---- ---- ---- ---------- -------
570 1 382 2 113 501
571 1 382 2 113 501
572 1 383 2 113 501

I want to retrieve the column values in different rows.

case 1: Select * from vw_A where Num201 = 570 and Type


I leave it to god.....

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-26 : 06:42:53
Post your question fully

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -