Viewing 15 posts - 18,076 through 18,090 (of 18,926 total)
Ya the least we can say is that he has a colorfull style
.
April 20, 2005 at 2:31 pm
I really got to get that book...
and read it eventually
.
April 20, 2005 at 2:07 pm
Solution :
Select the distinct groups
cross join to the ref so you get all possible combinaisons
left join that to the calculated sum of your first partial solution
isnull() the missing columns...
April 20, 2005 at 1:14 pm
WOW... and I thaught I was starting to know something about t-sql.
Where did you learn to do that?? (I know it's just a little trick but still it's not that...
April 20, 2005 at 12:58 pm
You don't need dynamic sql to do this task, please stay away from it.
April 20, 2005 at 6:36 am
But it is a nice way to create a few version of the same proc and see which one performs the best.
April 19, 2005 at 2:03 pm
Why not truncate / reinsert??
Might save you the permission problem in this case.
April 19, 2005 at 1:37 pm
Create proc MyProc @Operator as varchar(2), @EquipmentCount as INT,
AS
Set nocount on
select count (*) as carrier_count from dbo.v_MTSTM_EquipmentCountByCarrier where 0 <
case when @Operator = '<' and equipment_count ' and equipment_count...
April 19, 2005 at 1:36 pm
Maybe we should find a way to scare these guys away
.
April 19, 2005 at 12:59 pm
And from my belly profile you could see that you'd have plenty of room to bounce things off me
.
April 19, 2005 at 12:56 pm
I for one just ain't afraid of that tiny shark... he's gonna have to try harder to scare me off this board
.
April 19, 2005 at 12:44 pm
Is it possible that you forgot 1 column in the exists?..
or that the diff ljoin screwed up more data than you thaught?
April 19, 2005 at 12:25 pm
Seems ok from here... what's the problem??
Did you do a select into of the full statements or only the last join that was causing problems?
April 19, 2005 at 12:16 pm
Viewing 15 posts - 18,076 through 18,090 (of 18,926 total)