Is it doable to create a stored procedure without a where portion and then in my ASP designate the where clause by concatinating that string at the end using ASP?
so in othe words, something like this where I'm using ASP to finish out the where clause of my SP:
strSQL_Wherepart = "thisid =" & rID
strSQL = "sp_mystored_proc @SomeID=" & TheID & " WHERE " & strSQL_Wherepart
then in my stored proc I just wouldn't specify a where clause. Is this possible?