Jeff Moden (5/22/2011)

---

Wayne is absolutely spot on about the possible performance problem associated with joined UPDATEs. The "target" of the UPDATE MUST be somewhere in the FROM clause (I...

You are nearly there, but you need to think in terms of sets of data, rather than individual rows.

UPDATE [dbo].[bokningar]

SET

[dbo].[bokningar].[Webbokningsnr] = ISNULL(D.Webbokningsnr,I.Webbokningsnr)

FROM

deleted D

JOIN

...

Nils Gustav Stråbø (5/20/2011)

---

Function, procedure, view definitions etc are stored in the database where they are created. This definition is stored on disk, guaranteed.

A CTE declared inside a stored procedure...

sperry-750868 (5/20/2011)

---

Do with it as you wish. 🙂

I do not have to deal with negative numbers but it is not to hard to explain, what changes would i have to...

Gosh! maybe I should put that in...

Yes, that's right - do you have to handle negatives? If so, it is slightly different because of...

Sorry, found my mistake

SELECT ROUND(16499.00,0-LOG10(1000))

EDIT: mistake in code see next post

I want to be first...

cast the result and the rounding value as integers, then divide, then multiply.

SQLRO (5/20/2011)

---

SELECT TOP 10 Col1,Col2,Col3

FROM myTable WITH(READPAST)

WHERE Col1='XYZ'

AND Col2='ABC'

I believe this will get you ten records that are not locked for update.

Can I lock the records / rows...

SELECT TOP 10 Col1,Col2,Col3

FROM myTable WITH(READPAST)

WHERE Col1='XYZ'

AND Col2='ABC'

I believe this will get you ten records that are not locked for update.

Have you restarted SQL Server Service since the sp_addserver?

Never tried it - can't think of one off the top of my head!

True - at least I had a nice steak in the middle...