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.
| Author |
Topic |
|
iamsmahd
Yak Posting Veteran
55 Posts |
 Posted - 2005-09-22 : 07:30:48
|
| Hi there....I have created this stored proc. ::Create Stored Procedure dbo.xyz_1ASdeclare @type bitset @type=0SELECT DISTINCT dbo.Product.PCode, dbo.Order.ODescription, Case @type when 1 then 'x' when 0 then 'y' end as type, CASE WHEN (subquery1) ='d' THEN CASE WHEN (subquery2) >100 THEN (subquery3) WHEN (subquery2) <100 THEN begin Set @type=1 Case WHEN .. ELSE .. END End END AS PriceFROM .......WHERE .......-------------------------but I get error what's wrong?sonia |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Case