Viewing 15 posts - 1,381 through 1,395 (of 4,080 total)
123.987 is 123.9
????
Cory, explain please.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 2:14 pm
That would be truncation.
Will you ever have numbers like 14.567 or 143.953?
If so, do you want the answer to be 14?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 2:11 pm
Congratulations on 20k, Gail. 🙂
saimddr:
The question is whether or not you want to round the data or truncate the data.
Rounding the data can increase or decrease its value.
Truncating the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 2:06 pm
Again, there are a lot of articles and forums out there if you just search on the keyword "Concatenate". There is a technique using FOR XML that should...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 1:52 pm
You can also search this site for articles or threads with the keyword "Crosstab" to see the old school way of converting rows to columns using SUM(CASE statements) and GROUP...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 8:49 am
You're welcome.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 7:13 am
Give this a try:
UPDATE A1
SET bookno = COALESCE(ChangeBookNo,BookNo)
FROM A A1
OUTER APPLY ( Select Top 1 ChangeBookNo
From B
Where BookNO BETWEEN BookNoFrom and BookNoTo
Order by ChangeBookNo) oa
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 20, 2010 at 9:28 pm
Trey Staker (9/20/2010)
Steve Jones - Editor (9/20/2010)
I have...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 20, 2010 at 9:18 pm
I like your second solution, Lowell. If these values are all integers, why bother storing them as char/varchar?
I believe they are called computed columns in BOL.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 20, 2010 at 4:06 pm
Yes.
Defining an expression to appear as a column called a computed column in Books Online. You can find information about computed columns under the CREATE...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 20, 2010 at 8:03 am
You certainly know how to win friends and influence people, Mike. A lot of us share your sentiments.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 19, 2010 at 8:58 pm
Please do, Paul. I hear your blog is well written and enjoys a HUGE following in Hyderabad. 😉
I am behind on my reading but the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 17, 2010 at 10:36 pm
Kit G (9/17/2010)
Steve Jones - Editor (9/17/2010)
The Dixie Flatline (9/17/2010)
Apostrophes are also good for accenting sounds which are unpronounceable by human mouths.Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn
Is that Klingon?
No, I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 17, 2010 at 3:09 pm
If you can afford the disk space and maintenance load, specialized covering indexes are always on the path to optimal query performance.
Thanks for posting your...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 17, 2010 at 1:49 pm
You sure can.
I'm not sure why we're stuck on using a values clause to do this, but the expressions in a value clause may include sub-queries so long as they...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 17, 2010 at 1:05 pm
Viewing 15 posts - 1,381 through 1,395 (of 4,080 total)