a function should be able to do what you want, although it's probably not the best solution. if you're doing a loop, you can also SELECT the fields into variables,...

if you suspect your windows firewall, you can temporarily disable it, then add an exception to it if you're able to connect after it's turned off. also, check to make...

actually, i meant do BOTH the replace and the commenting out for your debugging.

and yes, you'll have to explicity DROP the global temp tables because they'll survive the session.

it's uber-easy for debugging purposes:

1. CTRL+H (replace) find #TempTable, replace with ##TempTable

2. debug

3. repeat step 1 with find and replace reversed

you can also comment out from:

CREATE PROCEDURE

to:

AS

and debug the code...

instead of #temptablename, use ##temptablename. this changes it from a local temp table to a global temp table. you should be able to see it then

are you able to connect from other places (odbc, udl file, etc)? if so, try using the connection string from where you ARE able to connect. if not, check things...

what do your event logs from the machine experiencing the error show? also, what's your environment like? are you using citrix? how are your clients connecting? when exactly is this...

could you post the details of your fix here? i'm sure others will come across this and would really appreciate being able to repeat the fix themselves.

thanks,

lenny

is there a reason you can't upgrade to SQL2005 SP2? we had this problem and upgrading helped, but it didn't fix it completely.

if you use an ORDER BY along with the TOP 1 to get the lowest date in your range, then yes, it should.

LeeLuv (7/31/2008)

---

I'm getting an error of 'subquery returned more than 1 value' when I try to

run this, which I guess is because the @Approved is being set to a SELECT

that...

i'm not saying this is the best way, but this is a good starting point. basically, this is treating your original table as a pivot, then it's just unpivoting and...

"SQL Server 2005 only stores the identifying information of a SP."

actually, SQL05 DOES store the code of the object itself as well. it can be found in sys.sql_modules, and a...

Just out of curiosity, but are you executing your query while logged into the sql05 box, or are you using the management studio while logged into another box? I'm asking...

>From the original post: "We are currenlty running SQL Server 2k Standard Edition (SP3) on Windows 2003. We would like to set up a Test SQL Server."

>In this case, the decision...