Have you Googled the first part of the error?

Also, this may not be related to the actual report but something to do with your hardware or software.

Alexeins (5/17/2012)

---

What is best way to write this statement?

1)

DECLARE @L_ZERO INT

SELECT @L_ZERO = IdMyTable FROM MyTable WHERE ColumnRef = 1000

SELECT ISNULL(@L_ZERO, 0)

OR

2)

DECLARE @L_ZERO INT

SET @L_ZERO = ISNULL((SELECT IdMyTable FROM MyTable...

SJanki (5/17/2012)

---

I have a table Allocations with coulmns AllocationID , PaymentID , ….

AllocationID is a PK.

Depending on certain condition I have to insert multiple records in Allocations table.

I get the...

I tasted homemade grape schnapps one summer when I was in Austria. Delicious! I need to go find a good recipe for it to see if I can make it...

saidapurs (5/16/2012)

---

I apriciate your responce & i agree with you but issue is i am not yet wrote any SP in my life. so while adding this once i requested...

ColdCoffee,

RAISEERROR would definitely work, but in this case, the dev specified that he wanted to exit without raising an error. Which limits the options down to RETURN().

mtassin (5/16/2012)

---

capn.hector (5/16/2012)

---

in any of my procedures that are user accessible i have a block at the beginning something like this:

IF @Input <> (good input)

BEGIN

SELECT 'you have bad input'

RETURN

END

kills it...

Exactly the problem I was having when reading the entries. I hate BOL examples...

Thank everyone for the relevant highlights and links. I can't believe I missed that.

Really? The RETURN statement will stop a proc in mid execution?

I'm looking over BOL on that and don't see any statements to that effect. That's why I posted here.

Just an FYI: This is a bad way to phrase a request for help. It raises the hackles of forum regulars...

SQLRNNR (5/16/2012)

---

jcrawf02 (5/16/2012)

---

Brandie Tarvin (5/16/2012)

---

L' Eomot Inversé (5/15/2012)

---

We have idiocies like proposals for an "absolute right to be forgotten" which means, for example, that someone serving a prison sentence for...

Barty

L' Eomot Inversé (5/15/2012)

---

We have idiocies like proposals for an "absolute right to be forgotten" which means, for example, that someone serving a prison sentence for rape or for murder...

Tom,

Does EU data protection laws define a difference between sensitive information and personal indentifying information?