Hi

Looks equal for me but I'm no pro in this non-ansi syntax. Could you please explain more detailed what's the difference in the returned data? Some test data would be...

Hi

Your first option is not a good practice since it uses a cursor (while loop) to insert 100 single rows.

Your second option seems to have a little typo, but is...

Hi

Maybe wrong execution to get the return value?

This works fine on my system:

CREATE PROCEDURE dbo.usp_TestReturn

AS

BEGIN TRY

RETURN 10

END TRY

BEGIN CATCH

RETURN 20

END CATCH

GO

DECLARE @ret INT

EXECUTE @ret...

I used SET until some month ago but currently switch to SELECT 🙂 because it can be used to assign more than one variable. For the readability I use more...

Hi

What kind of remote server is connected?

rjern (5/1/2009)

---

I have a very complex and large SQL program that has one OPENQUERY select statement using a linked server. The problem I am...

Hi...

Glad to see that we could help!

Greets

Flo

Hi

I have to confirm Michael, clustered indexes should be essential.

As second I'm not sure if you forgot to script all foreign keys or not. If not it is possible that...

Paul? Still or already?

Good morning or good night?

Hi

You have SSMS2k5 and SSMS2k8 installed, didn't you? This is a problem in the combination of both. Microsoft has a hotfix for SSMS2k5. SSMS2k8 should work with latest service pack.

Greets

Flo

Luke L (5/1/2009)

---

I never knew about it...

Lynn Pettis (5/1/2009)

---

WayneS (5/1/2009)

---

I guess it's a good thing that I didn't ask you how to get to...

Jeff Moden (5/1/2009)

---

Florian Reischl (5/1/2009)

---

TheSQLGuru (5/1/2009)

---

Flo, are you getting your reads from SET STATISTICS IO ON? IIRC UDFs don't report IO correctly in this manner. Try getting them...

Good point. Thanks!

Just...

Great idea Lynn!

Since Paul was 0/4 time due to only one logical read and your inline tally don't need any logical reads we can say this version needs (0/4)/8 milliseconds...