John,

Gail is asking you to save the execution plan as a .sqlplan and attach it to your post. Do you know how to do this?

You are welcome.

Just an FYI, though. You posted your question in the wrong group. Try General under 2008 or Business Intelligence under 2005 (which covers both 2k5 & 2k8).

Hey, Steve, can you change the birth year in my profile to read 1776, please?

😀

Revenant (5/17/2012)

---

Stefan Krzywicki (5/17/2012)

---

Steve Jones - SSC Editor (5/17/2012)

---

Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or something like...

In SSIS, you can use a MERGE JOIN transformation task, I believe. Or you can use Slowly Changing Dimensions. It depends on your business rules, etc.

Check them out in...

Here's another method:

CREATE TABLE dbo.BrandieTemp (MyID INT NOT NULL, TestCol1 VARCHAR(35),

TestCol2 VARCHAR(10));

GO

INSERT INTO dbo.BrandieTemp (MyID, TestCol1, TestCol2)

VALUES (1,'Mickey','Mouse'), (2,'Donald','Duck'), (3,'Goofy','who?');

SELECT MyID, TestCol1, TestCol2

INTO #MyTemp

FROM dbo.BrandieTemp;

ALTER TABLE dbo.BrandieTemp

...

Eugene Elutin (5/17/2012)

---

Could...

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...