Viewing 15 posts - 10,261 through 10,275 (of 13,874 total)
so that means Brenda Smith was subordinator of Alexander Tuckings
Why? Why not a subordinate of someone else?
There is no ordering of data and there is no way for SQL...
December 31, 2012 at 3:28 am
popq79 34287 (12/31/2012)
If there is one order placed, then I want both min/max to contain the same long with...
December 31, 2012 at 2:51 am
Does the OrderId column follow an ascending pattern? What I mean is, can we assume that, for each customer,
Min(OrderId) is the first order
and
Max(OrderId) is the most recent order
?
Also, if a...
December 31, 2012 at 1:58 am
axwack (12/26/2012)
December 31, 2012 at 1:44 am
Saravanan, can you answer Dave Ballantyne's question? It is a critical point.
December 31, 2012 at 1:35 am
ngreene (12/28/2012)
I added the string conversion "(DT_STR,50,1252)" incase you are inserting into a varchar field. ...
December 28, 2012 at 2:28 pm
Jon Jaroska (12/28/2012)
There...
December 28, 2012 at 9:12 am
krishnasrisatya (12/28/2012)
December 28, 2012 at 6:10 am
Jon Jaroska (12/26/2012)
December 28, 2012 at 2:13 am
This is an essential troubleshooting tool for variables (though there may be others) that will help you nail down the problem.
There are others - simply setting a pre-execute breakpoint on...
December 28, 2012 at 2:09 am
i wonder if you all took care of scenario whereby package i executed before or at 8am.
My solution handles that.
December 28, 2012 at 2:04 am
Here's my pseudo-code expanded a bit to accommodate the start and end date bits:
declare @StartDate datetime
,@EndDate datetime
set @EndDate = dateadd(hour, 8, DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(HOUR, - 8, getdate()))))
set @StartDate...
December 28, 2012 at 12:33 am
Phil Parkin (12/27/2012)
asita (12/26/2012)
Could you please help me out here, i am totally stuck here,
i have total 20 tasks in my ssis package (dataflow, execute sql task, etc)
at 16...
December 27, 2012 at 4:25 am
santoooo (12/27/2012)
I also had the same problem,
In my table Timestamp column is there which is not supported by the OLEDB DESTINATION connection.
Please cross check the data types in your...
December 27, 2012 at 4:14 am
10e5x (12/27/2012)
You are right, definately will have overhead. i try to get it done first before looking at efficiency issue. Actually my problem is defining startDate and endDate. Thanks phil
OK,...
December 27, 2012 at 4:12 am
Viewing 15 posts - 10,261 through 10,275 (of 13,874 total)