:-D, my usual method is look at the wall;-)

wolfkillj (10/24/2013)

---

Greg Edwards-268690 (10/24/2013)

---

Reading this I would say vector.

Good listing of...

Greg Edwards-268690 (10/23/2013)

---

wolfkillj (10/23/2013)

---

Greg Edwards-268690 (10/23/2013)

---

Koen Verbeeck (10/23/2013)

---

wolfkillj (10/23/2013)

---

I've published my first technical blog post. I'd appreciate any feedback from this group on both the technical aspects and the writing....

Luis Cazares (10/22/2013)

---

How would you even calculate the average of active patients? You could count them, but an average needs something from which we could calculate it. Average by doctor?...

Hi

I put quotes around your dates, otherwise the dates are messed up.

I also noticed an issue with the query I provided and have updated it so that it now only...

Hi

I'm not sure if this is the logic you want, but this might help you get started. Unfortunately your insert statements need the dates fixed and I was unable...

Jeff Moden (10/20/2013)

---

I believe what we have here is homework about how to use WHILE loops and the instructor probably never heard of...

The 'no reverse' is an interesting requirement. Here's my attempt at it

with stringList as (

SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) ID, String,

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(String,' ',''),'.',''),',',''),'''',''),'-','') Compact --More replaces are likely

FROM...

Bill Talada (10/18/2013)

---

Nice! It seems like a strange request but I get it often. The boss generally wants a few exact match clauses and a subset of several...

Hi

This should do the trick for you

with cte as (

select PhoneNum, PhoneType, PhoneLocation, FileDate

,ROW_NUMBER() OVER (PARTITION BY PhoneNum ORDER BY PhoneType, PhoneLocation, FileDate) -

ROW_NUMBER() OVER (PARTITION BY PhoneNum...

Since you inputs are char(20) the fastest (but least flexible) option would be something like

select id, somevalue, positions =

stuff(

case substring(SomeValue,1,1) when 'X' then ',1' else '' end +

case substring(SomeValue,2,1) when...

Hi

This should do what you want. There is likely to be other better ways though

with sampledata as (

SELECT *

FROM (VALUES

(1,' X')

,(2,'...

No problem ... glad to help

On the FULL OUTER join query, a CASE statement would do it.

SELECT fs.FirstItem, ss.SecondItem,

CASE WHEN fs.FirstItem = ss.SecondItem THEN 1

WHEN fs.FirstItem...

Hi

Here's another option

select case when u = 1 then dateadd(dd,1,unitDate) else unitDate end unitDate, unitID,

case when u = 1 then 'Unit no longer available' else 'Newly available unit' end

from (

select...