sql2000视图转换

[sufull88]

MSSQL2000 (取所有列qty1、qty2、。。。。qty10不全为0的行)

原始视图view_qtyall
materialid, qty1,qty2,qty3,qty4,qty5,qty6,qty7,qty8,qty9,qty10
1 ,0 , 1 , 1 , 0 , 0 ,0 ,0 ,0 , 0 , 0
2 ,1 , 0 , 0 , 0 , 0 ,0 ,0 ,0 , 0 , 0
7 ,0 , 0 , 0 , 0 , 0 ,0 ,0 ,0 , 0 , 1
8 ,0 , 0 , 0 , 0 , 0 ,0 ,0 ,0 , 0 , 0

要求结果：可以转换为其它名字的视图
视图view_qtyall (只取所有列不全为0的行)
materialid, qty1,qty2,qty3,qty4,qty5,qty6,qty7,qty8,qty9,qty10
1 ,0 , 1 , 1 , 0 , 0 ,0 ,0 ,0 , 0 , 0
2 ,1 , 0 , 0 , 0 , 0 ,0 ,0 ,0 , 0 , 0
7 ,0 , 0 , 0 , 0 , 0 ,0 ,0 ,0 , 0 , 1

[哥眼神纯洁不]

where qty1!=0 or qty2!=0 or...一直到10

• 打赏
• 举报

回复 赞