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 |
|
baburk
Posting Yak Master
108 Posts |
 Posted - 2009-11-26 : 23:43:04
|
| DECLARE @FieldName NVARCHAR(50) = 'Vehicle', @FieldValue NVARCHAR(50) = 'testv' , @EstateID NVARCHAR(50) = 'm1' IF @FieldName = 'Vehicle' BEGIN IF EXISTS(SELECT VM.VHWSCode FROM Vehicle.VHMaster AS VM INNER JOIN [Vehicle].[VHCategory] AS VC ON VC.VHCategoryID = VM.VHCategoryID WHERE VM.VHWSCode = @FieldValue AND VC.[Type] = 'V' AND VM.EstateID = @EstateID ) BEGIN SELECT 2 END ELSE IF EXISTS(SELECT VM.VHWSCode FROM Vehicle.VHMaster AS VM INNER JOIN [Vehicle].[VHCategory] AS VC ON VC.VHCategoryID = VM.VHCategoryID WHERE VM.VHWSCode = @FieldValue AND VC.[Type] = 'V') BEGIN SELECT 1 END ELSE BEGIN SELECT 0 END END. |
|
|
vikky
Yak Posting Veteran
54 Posts |
Posted - 2009-11-27 : 01:04:36
|
| Hi,DECLARE @FieldName NVARCHAR(50) = 'Vehicle', @FieldValue NVARCHAR(50) = 'testv' , @EstateID NVARCHAR(50) = 'm1'SELECT CASE WHEN @FieldName = 'Vehicle' AND VM.VHWSCode = @FieldValue AND VC.[Type] = 'V' AND VM.EstateID = @EstateID THEN 2 WHEN VM.VHWSCode = @FieldValue AND VC.[Type] = 'V' THEN 1 ELSE 0 FROM Vehicle.VHMaster AS VMINNER JOIN [Vehicle].[VHCategory] AS VCON VC.VHCategoryID = VM.VHCategoryIDThanks,vikky. |
 |
|
|
baburk
Posting Yak Master
108 Posts |
Posted - 2009-11-27 : 04:09:21
|
quote:
Originally posted by vikky
Hi,DECLARE @FieldName NVARCHAR(50) = 'Vehicle', @FieldValue NVARCHAR(50) = 'testv' , @EstateID NVARCHAR(50) = 'm1'SELECT CASE WHEN @FieldName = 'Vehicle' AND VM.VHWSCode = @FieldValue AND VC.[Type] = 'V' AND VM.EstateID = @EstateID THEN 2 WHEN VM.VHWSCode = @FieldValue AND VC.[Type] = 'V' THEN 1 ELSE 0 FROM Vehicle.VHMaster AS VMINNER JOIN [Vehicle].[VHCategory] AS VCON VC.VHCategoryID = VM.VHCategoryIDThanks,vikky.
This returns more than one value |
|
|
|
|
|
|
How to write this query in a simple way