mpdillon (6/30/2010)

---

...

When I update a Decimal(18,6) field type by dividing two Int field types, SQL does not do an implicit conversion.

...

I was astounded to find the the integer 2...

Brandie Tarvin (6/30/2010)

---

Thanks, but your solution won't work. Even though my supplied data set only has one paired team, my actual database has multiple FranchiseIDs with multiple StoreIDs. Your update...

Actually, recursive CTE is not far from RBAR (can be even worse in performance)...

What you need can be achieved by a single update:

UPDATE Store SET FedTaxID = CAST(RAND(F.FranchiseID) * 1000000000...

This is about internal structure of SQL Server and its internal operations..

http://www.sqlmag.com/article/internals-and-architecture/sql-server-internals-viewer.aspx

Actually, it is down to MS SQLServer implementation of AUTO INCREMENTING.

You can find...

1. Using single numeric key (DocNo) will make join between your Master and Details table work faster!

2. Getting FormulaID when just retrieving details will be slower as it will require...

Jeff Moden (6/29/2010)

---

...

Actually, I have to admit, my really cool (or so I thought :blush: )method got the pants beat off it by simple nested replacements. Check out the...

Have you tried?

scott.pletcher (6/29/2010)

---

The UPDATE below will replace the first occurence of -- and any number more dashes in a row, with a single space.

Since you have multiple occurences within the string,...

Cool! It explains everything!

So, you want an average value, isn't it?...

Stefan_G (6/29/2010)

---

Well, there are two possibilities:

1) There is...

In this case, you can use FOR XML PATH (it takes much less space than FOR EXPLICIT "query from hell"), as you will only read Table_2 and Table_3 once for...

rahulsony111 (6/29/2010)

---

Hi,

I have a table with columns proj_id char(5), tenant_id char(6), lease_id char(8), Sales_yr numeric(4)

i want to distinct only proj_id, tenant_Id, Lease_id but not sales_yr how can we do...

It depends on many factors...

Have a look this: http://msdn.microsoft.com/en-us/library/ms175515.aspx

try:

UPDATE Temp set Discounturl = replace(replace(replace(Discount,'--','-~'),'-~',''),'-',' ')

EDITED AS THE ABOVE HAS A BUG.

See my next post