I am new in .Net ....Problem in Logic of sp

Question

1.00/5 (1 vote)

See more:

In this query my SP doing right way for forword data proccessing when calculate the bill of next year.......i.e. your bill from 2010....calculate data bill for right way..2011,same for 2012,2013....so on...but problem are arise when .....show the data in 2009....(Backword)
means 2009 have not data then not show the data but here show data......sorry for bad english

SQL

ALTER PROCEDURE [dbo].[spGetMaxBillingFinancialYearID]      
 @FinancialYearID INT,      
 @WardNoID INT,
 @MohallaID INT,      
 @MaxBillingFinancialYearID INT OUTPUT      
AS       

BEGIN      
 IF EXISTS(SELECT FinancialYearID FROM PropertyTaxBill WHERE WardNoID=@WardNoID AND MohallaID=@MohallaID AND FinancialYearID < @FinancialYearID) 

    
 BEGIN      
  SET @MaxBillingFinancialYearID=(SELECT TOP 1 FinancialYearID FROM PropertyTaxBill WHERE WardNoID=@WardNoID AND MohallaID=@MohallaID        
						AND FinancialYearID =(SELECT MAX(FinancialYearID) FROM PropertyTaxBill WHERE WardNoID=@WardNoID AND MohallaID=@MohallaID        
						AND FinancialYearID < @FinancialYearID))

					  
END      
 ELSE      
 BEGIN      
  SET @MaxBillingFinancialYearID=0      
 END 
END

Posted 20-Feb-13 18:23pm

Faizymca

Updated 20-Feb-13 18:51pm

uspatel

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 21-Feb-13 0:43am

Where is .NET here?
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sandeep207 · Accepted Answer · 2013-02-20T18:44:00

Solution 1

Hi
Please change below condition

SQL

IF EXISTS(SELECT FinancialYearID FROM PropertyTaxBill WHERE WardNoID=@WardNoID AND MohallaID=@MohallaID AND FinancialYearID < @FinancialYearID) 
To

IF EXISTS(SELECT FinancialYearID FROM PropertyTaxBill WHERE WardNoID=@WardNoID AND MohallaID=@MohallaID AND FinancialYearID <= @FinancialYearID)

Posted 20-Feb-13 18:44pm

sandeep207

Updated 20-Feb-13 18:52pm

v2

Comments

uspatel 21-Feb-13 0:54am

Always add code tag in your solution for code text to make it more understandable.