SELECT326.76 * 1.105 / 1.21,

CEILING(326.76 * 1.105 / 1.21 * 100.0) / 100

You did?

Then I didn't have to explain the algorithm here?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100990

Why post the same question again when you got an answer here

http://www.sqlservercentral.com/Forums/Topic484231-8-1.aspx

http://support.microsoft.com/kb/297466

SELECT CONVERT(CHAR(8), DATEADD(SECOND, @Seconds, '00:00:00'), 108)

Derek Dongray (4/14/2008)

---

Including the update, this is 50% faster. Excluding the update, it's 100% faster.

The only thing I'm dubious about is whether the update will always get the records in...

Also asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100812

Add a

AND t1.id = t2.id

and you produce the same result too!

And if "= NULL"

do not work, try "IS NULL" instead.

Try this

UPDATEt

SETt.Img = s.Img

FROMMyTable AS t

INNER JOINOPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB) AS s(Img)

An EXISTS might be a better choice depending on number of records.

SELECTp.*

FROML_RPT_INV_PERSON_INFO AS p

WHEREEXISTS (SELECT * FROM L_RPT_INV_INFO AS i WHERE i.INFORMATION_CHANGED_FLAG = 'Y' AND i.RPT_INV_ID = p.RPT_INV_ID AND i.RPT_INV_TP...

From looking at the OP, I would guess a last closing paranthesis...

Try this one...

;WITH Yak (id, st, date, rowid, col)

AS (

SELECTid,

st,

date,

ROW_NUMBER() OVER (ORDER BY id, date),

0

FROM#t

)

SELECTid,

MAX(CASE WHEN col = 0 THEN st ELSE '' END) AS sta,

MAX(CASE WHEN col = 0...

Use NVARCHAR data type.

NVARCHAR(MAX) can hold 1 billion characters. I do...