Viewing 15 posts - 11,641 through 11,655 (of 13,876 total)
Although I agree with you, did you notice that it's his/her first forum post?
Maybe when they get to 30 or 40 posts, you can start slamming them for any dumb...
February 3, 2011 at 5:19 am
That's better. You can do that using a subquery - something like this (untested):
SELECT
t2.SumGross,
t.BOOKING_ID,
t.KL_EQUIPMENT_TYPE_CD,
etc etc
FROM tablename t
JOIN
(select t1.Booking_ID, Sum(t1.Gross_Wgt) SumGross
from tablename t1
group by t1.Booking_ID) t2
on t.Booking_ID...
February 3, 2011 at 4:55 am
Probably.
But unless you provide a better description of what you are trying to achieve, that's the best answer I can provide.
February 3, 2011 at 4:09 am
Stringzz (2/1/2011)
Thanks Phil, I actually had a lightbulb go off before I saw your post, but you would have directed to the correct solution if I hadn't figured it out.
Haha,...
February 1, 2011 at 9:44 am
Stringzz (2/1/2011)
February 1, 2011 at 9:36 am
You'd be wise not to mention the 'c' word in this forum 🙂
Have you tried SELECT ... rather than RETURN?
February 1, 2011 at 9:30 am
Koen (da-zero) (1/28/2011)
Phil Parkin (1/28/2011)
The power of Google is there for you as well as me, but since you're new I've done it for you, just this once. Check here.
The...
January 28, 2011 at 7:31 am
The power of Google is there for you as well as me, but since you're new I've done it for you, just this once. Check here.
January 28, 2011 at 7:14 am
Try removing the double quotes from your expression:
@[User::LopVariable]==@[User::IterlopVariable]
January 28, 2011 at 12:42 am
Are you running the package as yourself, or another user? It is good practice to use a UNC path to your file, rather than drive letters, as these are not...
January 27, 2011 at 9:15 am
I'm with Koen. There was no need for an SP - running the count query and assigning the result to an SSIS variable can all be done in a single...
January 26, 2011 at 8:54 am
Please post the text of the error message from the job history.
January 26, 2011 at 6:36 am
Or it might be possible via a conditional split (just redirect all the unwanted rows to an unused output and keep the good stuff) - don't use SQL Server at...
January 26, 2011 at 4:34 am
Viewing 15 posts - 11,641 through 11,655 (of 13,876 total)