You spin me round round, baby, right round....

????

Cory, explain please.

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?

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...

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...

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...

You're welcome.

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

Trey Staker (9/20/2010)

---

Steve Jones - Editor (9/20/2010)

---

BTW, I got an appeal from Itzik that Window functions might not make SQL 11 and he's appealing people to upvote connect items.

http://www.sqlmag.com/blogs/puzzled-by-t-sql/tabid/1023/entryid/13085/Window-Functions-OVER-Clause-Help-Make-a-Difference.aspx

I have...

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.

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...

You certainly know how to win friends and influence people, Mike. A lot of us share your sentiments.

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...

Kit G (9/17/2010)

---

No, I...

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...