Viewing 15 posts - 1,261 through 1,275 (of 3,232 total)
In addition to what everyone else has said, I would also tighten up your use of NULLs. Setting your columns up as NOT NULL by default is a good...
July 29, 2009 at 11:26 am
Yes. Combining string values with the '+' operator results in a NULL any time one of the values contain a NULL. This is expected behavior. Since NULL...
July 29, 2009 at 11:19 am
declare @test-2 TABLE (
ID int,
Code int,
CodeType char
)
INSERT INTO @test-2
SELECT 1, 10, 'A'
UNION
SELECT 1, 20, 'B'
UNION
SELECT 2, 15, 'A'
UNION
SELECT 2, 25, 'B'
UNION
SELECT 3, 35, 'A'
UNION
SELECT 3, 45, 'B'
SELECT * FROM @test-2
SELECT...
July 29, 2009 at 10:52 am
Joshi (7/29/2009)
hmm thats interesting, I don't have "execute task" and "edit breakpoints".Thanks again
Where are you trying to execute the step from? What Adrian showed you is from BIDS.
July 29, 2009 at 10:48 am
So back to the question at hand, how to duplicate your SP logic within SSIS.
This on is pretty simple. You'll need a data flow with a flat file source...
July 29, 2009 at 10:21 am
My professional opinion would be that you're time would be better spent mastering non-cursor solutions and any other effort is wasting your time. Why spend so much time working...
July 29, 2009 at 9:50 am
I can't help but comment on the other few threads that you've started regarding advice on using cursors. Specifically, you asked in one thread about the use of nested...
July 29, 2009 at 9:39 am
Iron Chef SQL (7/28/2009)
John Rowan (7/28/2009)
Did you try it?
DECLARE @var int
IF @Var IS NULL
SELECT 'It Works'
ELSE
SELECT 'Nope'
Doesn't work 🙁 even if I change it to <=0
What do you mean...
July 29, 2009 at 9:27 am
Did you try it?
DECLARE @var int
IF @Var IS NULL
SELECT 'It Works'
ELSE
SELECT 'Nope'
July 28, 2009 at 5:17 pm
OK, so back to the question of why? What is the purpose of doing this, are you using this data elsewhere?
We're getting close by the way.....
July 28, 2009 at 3:38 pm
Lynn Pettis (7/28/2009)
I'm sorry but the second INSERT into Table1 has me totally confused.
I'm glad I'm not alone! 🙂
July 28, 2009 at 3:27 pm
The second INSERT statement in your example shows Table1 being outer joined back to itself on it's key column. An outer self-join on the key column with the IS...
July 28, 2009 at 3:14 pm
What is the deal with table1? Is this a temp table, table variable? What are you trying to accomplish with it?
July 28, 2009 at 2:59 pm
If you are staging the data in a table and then using a stored procedure to 'link' those rows to related data and insert them into your destination table, then...
July 28, 2009 at 2:28 pm
PaulB (7/28/2009)
If a partitioning strategy does not matches at least one of...
July 28, 2009 at 2:05 pm
Viewing 15 posts - 1,261 through 1,275 (of 3,232 total)