Why is SQL Server procedure not executing properly?

[rahulae]

i'm trying to execute a procedure that should return a property that are available in a state within a price range(between x and y)

i have written a procedure but not able 2 execute it properly

[ck9663]

More details please.

Sample data of your source table and the value/format of your desired output.

-- CK

[rahulae]

Given a valid character state and price range( between x and y) the system should be able to report all the properties that are available in that state with in that range with their asking price.

Table:Attributes(property_id,property_name,asking_ price,status,total_size,address,city,state)

[Delerna]

SELECT Property_ID,Property_Name,Asking_Price,Status,
       Total_Size,Address,City,State
FROM Attributes
WHERE State=@State 
  AND Asking_Price BETWEEN @X AND @Y
 

[rahulae]

i have to write a procedure for that and also tell me how to execute the procedure since we have to use a between operator

[Delerna]

The stored proc will look something like

create proc GetAttributeRange 
         @State varchar(20),
         @X decimal(18,2),
         @Y decimal(18,2)
as
SELECT Property_ID,Property_Name,Asking_Price,Status,
       Total_Size,Address,City,State
FROM Attributes
WHERE State=@State 
  AND Asking_Price BETWEEN @X AND @Y
Go
 

and you will call it something like this

exec GetAttributeRange 'NSW',1.42,100.30
 

[rahulae]

Its working fine for me

Thank You.