Viewing 15 posts - 4,411 through 4,425 (of 9,715 total)
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...
May 17, 2012 at 11:02 am
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
...
May 17, 2012 at 10:53 am
Eugene Elutin (5/17/2012)
Brandie Tarvin (5/17/2012)
...I'm a little confused. Why don't you just ALTER the table and set AllocationID as an IDENTITY field? You wouldn't have to fuss with variables, then.
Could...
May 17, 2012 at 10:49 am
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.
May 17, 2012 at 10:42 am
Alexeins (5/17/2012)
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...
May 17, 2012 at 10:38 am
SJanki (5/17/2012)
AllocationID is a PK.
Depending on certain condition I have to insert multiple records in Allocations table.
I get the...
May 17, 2012 at 10:35 am
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...
May 17, 2012 at 6:43 am
saidapurs (5/16/2012)
May 16, 2012 at 10:37 am
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().
May 16, 2012 at 10:08 am
mtassin (5/16/2012)
capn.hector (5/16/2012)
IF @Input <> (good input)
BEGIN
SELECT 'you have bad input'
RETURN
END
kills it...
May 16, 2012 at 9:37 am
Matt Miller (#4) (5/16/2012)
Now - the examples aren't very good since they encapsulate everything in IF statements...
Exactly the problem I was having when reading the entries. I hate BOL examples...
May 16, 2012 at 9:10 am
Thank everyone for the relevant highlights and links. I can't believe I missed that.
May 16, 2012 at 9:07 am
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.
May 16, 2012 at 8:36 am
saidapurs (5/16/2012)
If possible please do the changes & update me.
Just an FYI: This is a bad way to phrase a request for help. It raises the hackles of forum regulars...
May 16, 2012 at 8:20 am
SQLRNNR (5/16/2012)
jcrawf02 (5/16/2012)
Brandie Tarvin (5/16/2012)
L' Eomot Inversé (5/15/2012)
May 16, 2012 at 6:52 am
Viewing 15 posts - 4,411 through 4,425 (of 9,715 total)