Viewing 8 posts - 16 through 23 (of 23 total)
Since I'm not the administrator of the database, I don't know what additional tools have been installed. How can I determine whether or not I have Redgate SQL Prompt or...
October 5, 2016 at 2:40 pm
So if I'm understanding you correctly, I should restore the DB to a test location, that way I can pick the code for the one procedure in question, recreate it...
October 5, 2016 at 2:37 pm
i see. thank you for clarifying that for me.
January 14, 2009 at 3:10 pm
that did the trick!
but why was SQL even looking at that line of code, seeing as how the value of @tbl_num was less than 9?
January 14, 2009 at 3:07 pm
i do know for a fact that that field "address2" in table "test1" indeed contains the value in question; and the table only has 4 records, being a test table.
i'll...
January 8, 2009 at 9:22 pm
nevermind- i got it.
thanks for your help!
May 15, 2008 at 12:17 pm
that looks great, thanks!
one last thing- what's the proper syntax for calling the SP with a value for @days?
May 15, 2008 at 11:43 am
Here's the SP with the input variable decalred, but not used. I'm not sure where to go from here; and the literature I have here is not doing the...
May 15, 2008 at 10:48 am
Viewing 8 posts - 16 through 23 (of 23 total)