Viewing 15 posts - 45,106 through 45,120 (of 59,063 total)
AFCC Inc. Com (2/16/2009)
I have to remember that the price is computed from the .% in the length width columns. SO my...
February 16, 2009 at 12:20 pm
Ok... the following should work... read the comments... the advantage of this particular set based method is that you can create a view from it at the expense of just...
February 16, 2009 at 12:05 pm
Is it possible to post the sproc? I can give it a try for you.
February 16, 2009 at 11:12 am
Ah... got it. Thanks, Toni.
Erik... how 'bout it? Got data?
February 16, 2009 at 11:05 am
Steve Jones - Editor (2/16/2009)
I'll give Oracle one thing. they seem to have found a way to convince management to pay more for DBAs on average!
Heh... yeah, I agree with...
February 16, 2009 at 11:01 am
Thanks for the feedback, Norbert. And, consider this... since the code is so simple, are you sure you want the system to "suffer" through the overhead associated with a...
February 16, 2009 at 10:53 am
AFCC Inc. Com (2/16/2009)
select orderid, size, cost, case when size <= basemeasure then cost
...
February 16, 2009 at 10:49 am
J (2/16/2009)
Cast the output as CONVERT(VARCHAR(DesiredColumnWidthHere), long_column_name) AS long_column_name.Interesting.
So I suppose this is more efficient than SUBSTRING ?
Regards
Sorry to use the ol' cliche`, but it depends... sometimes SUBSTRING won't...
February 16, 2009 at 10:45 am
David Jackson (2/16/2009)
Ours is not to reason why, but to do and die... :Whistling: 🙂
Heh... I really hate it when THAT happens. 😛
February 16, 2009 at 10:42 am
sunny1_liu (2/15/2009)
February 16, 2009 at 10:39 am
AFCC Inc. Com (2/15/2009)
Now if it is blinds they are priced by width and height, "a grid"
I have attached an example grid that is used by the blind manufacturers and...
February 16, 2009 at 10:26 am
Heh... well said. Actually, I hated the old outer join notation... especially since Oracle and SQL Server did it exactly the opposite from each other.
February 16, 2009 at 10:20 am
Derek Dongray (2/16/2009)
bitbucket (2/13/2009)
shhh tell no one, but heck it was better than using a slide rule to do the calculations.
I still have my slide rule and can even remember...
February 16, 2009 at 10:16 am
Derek Dongray (2/16/2009)
Take a rat. Drop it in a maze. If it takes the wrong path, it gets shocked. If it takes the right path, it gets...
February 16, 2009 at 10:14 am
Bruce W Cassidy (2/15/2009)
Jeff Moden (2/15/2009)
Anything that won't even allow for more than a 30 character object name certainly isn't the most flexible of the two.
[font="Verdana"]Okay, now I have to...
February 16, 2009 at 9:58 am
Viewing 15 posts - 45,106 through 45,120 (of 59,063 total)