Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to change month and year to FromDate and ToDate in SP
Dear all, Can somebody help me to revise below original SP where it would display cardno for the month period. What I want is to display cardno by date range Eg, txtLog_date and txtCompleted_date set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- Batch submitted through debugger...- yeongsm
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
how to revise exising SP to handle parameter passed from ashx to sp ?
Hi, Benson After adding your statement into ashx..it always showed context is not declared.. Btw,could you pls help me to finetune this previous SP where it receive 3 parameters which are cardno, month , year.. so that it can pass my required 3 parameter (cardno,txtLog_date, txtCompleted_date)...- yeongsm
- Post #3
- Forum: Microsoft: ASP.NET
-
how to revise exising SP to handle parameter passed from ashx to sp ?
Hi, there. I have created a new sp in SQL but it failed to show specific records which are based on the parameters captured in ashx page from ASP page. See attached photo how I pass 3 parameters from asp to ashx then call SP... ---------------------- $_rpt_vehicle...- yeongsm
- Thread
- Replies: 3
- Forum: Microsoft: ASP.NET
