Brandie Tarvin (7/17/2008)

---

...

Case QuantityShipped WHEN 0 THEN 0

ELSE ( SUM(ISNULL([Unit Price],0)) * QuantityShipped)

/ QuantityShipped END as...

This would be my guess at what you're trying to do...

SELECT CONVERT(varchar(11), ShipDate, 106) AS...

Thanks GSquared.

By the way, I've just noticed that Test3 references string1 several times. Is that supposed to be the case?

Slow down!

The link from 2002 says:

I'm pretty convinced now that it requires 6 REPLACEs. I think that, using...

As usual, different methods will be better in different situations. They're all tools for the toolbox 🙂

GSquared, your last idea also cropped up in 2002...

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

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(colname,

...

Hehe - you've made my...

Jeff Moden (7/16/2008)

---

RyanRandall (7/14/2008)

---

Another technique which can be useful in some circumstances...

update #TEST set Descr = replace(replace(replace(Descr, ' ', '¬ '), ' ¬', ''), '¬', '') where Descr like '%...

mathewspsimon (7/16/2008)

---

The query should fetch the all the visit-ids which is for another date like below for the sample data I gave.

Visit_Id Med_Id Date ...

So what would you want the results to look like for this sample data?

Here's one way...

--sample data

declare @t table (s varchar(100))

insert @t

select 'ANALYSIS RECORDS (APPROX 100 PPS)'

union all select 'REVIEW MANUAL (75+ PAGES)'

union...

You can use something like this to append the bits together...

--sample data

declare @t table (WoNumber varchar(20), LineNumber int, Detail varchar(100))

insert @t

...

Just divide by 60000.0 - or is there more to it?

Something like...

update TableA set value = 1 from TableA inner join TableB on TableA.id1 = TableB.id1 and TableA.id2 = TableB.id2 where TableB.id = 12345

which looks a bit nicer if you...

The last post here might be useful (as might this thread)...

http://www.sqlservercentral.com/Forums/Topic158858-21-1.aspx

select log(1.0 * 150/100)

returns 0.405465108108164