get the value from textbox,,to execut query

Using dynamic query you can able retrieve as per your scenario ,


Please check this ,



ALTER PROCEDURE [dbo].[spSelectBalance]
(
    @intLocationID as varchar(100), -- you can use either string or int
    @intYearID as varchar(100),     -- if you will use integer then cast it integer to string in dynamic query
    @intDays as varchar(100)
)   
AS
BEGIN
    DECLARE @SQLQuery as varchar(2000)
    --Query generation
    SET @SQLQuery = 'select b.RegNo, b.FirmName, isnull(a.BalTaxAmount,0) + isnull(a.BalPenalty,0) +
                    isnull(a.BalNoticeFee,0) DueAmount,isnull(a.BalInterest,0) InterestAmt,
                    datediff (day,  DueDate ,getdate()) duedays, b.autoid IDtblPTForm3
                    from tblPTForm3Balance a, tblPTForm3 b where a.IDtblPTForm3 = b.AutoID and a.LocationID = '
    SET @SQLQuery = @SQLQuery + @intLocationID + ' and a.YearID = ' + @intYearID
    SET @SQLQuery = @SQLQuery + ' and (isnull(a.BalTaxAmount,0) + isnull(a.BalPenalty,0) +
                    isnull(a.BalInterest,0) + isnull(a.BalNoticeFee,0)) > 0 and convert(datetime,convert(varchar(10),a.DueDate + '
    SET @SQLQuery = @SQLQuery + @intDays + ',101))  <= convert(datetime,convert(varchar(10),getdate(),101))'

    --Print the Query
    PRINT(@SQLQuery)

    --Execute the Query
    EXEC(@SQLQuery)
END


--Finally execute the SPs
EXEC spSelectBalance '3','1983','25'


If it helps you , please mark as answer.