Viewing 15 posts - 9,871 through 9,885 (of 13,880 total)
Bhaskar.Shetty (5/29/2013)
Try this...
SELECT CASE WHEN StartDate IS NULL THEN 'N/A' ELSE CAST(DATEDIFF(dd,StartDate,EndDate) AS varchar) END Days
Using your code, adapted slightly:
declare @StartDate date = '20130501'
--Wednesday
declare @EndDate date = '20130507'
...
May 29, 2013 at 8:58 am
var05 (5/29/2013)
The problem is both the tables dont reside...
May 29, 2013 at 7:50 am
var05 (5/29/2013)
Say I have a table in SQL where in I add and remove the employee names.
My Execute sql task will pick up the employees in that ABC sql...
May 29, 2013 at 7:21 am
var05 (5/29/2013)
I would like to know how to pass a paramater from Execute SQL task to OLE DB source
I have an execute sql task returing a full result query....
May 29, 2013 at 6:30 am
Where to begin troubleshooting?
Put both result sets in database tables and run some queries so that you can understand what the extra rows look like. Then, maybe, you can...
May 29, 2013 at 12:52 am
KoldCoffee (5/28/2013)
May 28, 2013 at 11:50 pm
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
Viewing 15 posts - 9,871 through 9,885 (of 13,880 total)