Viewing 15 posts - 9,871 through 9,885 (of 13,874 total)
KoldCoffee (5/28/2013)
May 28, 2013 at 10:20 pm
Shree-903371 (5/28/2013)
May 28, 2013 at 2:20 pm
The syntax for the derived column gets difficult to maintain doing it this way, as more lookups are added.
An alternative is to use a lookup table - either physical or...
May 28, 2013 at 3:04 am
Jeff Moden (5/27/2013)
Phil Parkin (5/27/2013)
Here's a link that should get you started.
The 'asynchronous' part here refers to the...
May 28, 2013 at 12:25 am
This looks like bread and butter for an asynchronous Script Component to me.
Here's a link that should get you started.
The 'asynchronous' part here refers to the fact that the number...
May 27, 2013 at 12:26 pm
As far as I know, single procs which can return different result sets are not supported until SSIS 2012, where you can use the WITH RESULT SETS hint when calling...
May 26, 2013 at 1:50 pm
You seem to create a temp table called #ID, then INSERT and SELECT from #EID, which is not defined. Have you missed out a section from your code?
Can you possibly...
May 26, 2013 at 1:46 pm
Tobar (5/24/2013)
OK. Now I am starting to wonder about the wiseness of opening this argument. 🙂
Nah, I'm looking forward to your next thread: "would Jesus have made a good database...
May 24, 2013 at 8:47 am
Bhaskar.Shetty (5/24/2013)
Please reread my post. Use a dictionary, if necessary, to help you understand its meaning. I did not call anyone silly. I said that the post made you look...
May 24, 2013 at 7:37 am
Sergiy (5/24/2013)
Phil Parkin (5/24/2013)
Where is that post?
The first post of this topic.
But saying that you "cannot call insert like that" is clearly wrong.
Not if "like that"...
May 24, 2013 at 7:31 am
Bhaskar.Shetty (5/24/2013)
Sergiy (5/24/2013)
Phil Parkin (5/24/2013)
Where is that post?
The first post of this topic.
But saying that you "cannot call insert like that" is clearly wrong.
Not if "like...
May 24, 2013 at 7:21 am
Sergiy (5/24/2013)
Phil Parkin (5/23/2013)
Bhaskar.Shetty (5/23/2013)
You cannot call insert like that, = operator works while you are updating any row or table.
Before making blanket statements like this, I find that...
May 24, 2013 at 6:20 am
Your statement:
You cannot call insert like that, = operator works while you are updating any row or table.
Is plainly wrong - I proved it in code. And now you are...
May 23, 2013 at 1:18 am
Bhaskar.Shetty (5/23/2013)
You cannot call insert like that, = operator works while you are updating any row or table.
Before making blanket statements like this, I find that it is always...
May 23, 2013 at 1:01 am
sqlbi.vvamsi (5/22/2013)
REPLACE(LTRIM(REPLACE(field,"0"," "))," ","0") is the expression, this won't work if field value has space characters
Nice trick.
May 22, 2013 at 9:09 am
Viewing 15 posts - 9,871 through 9,885 (of 13,874 total)