Congratulations to Paul White, who's joined the elite through hard work and outstanding contributions to the community. Well done Paul, very well deserved.

kp81 (3/11/2011)

---

Let it be said Ian...you're a legend!

I've just run it up and it's spot on what I need. I think the key was also in the

case when...

BeginnerBug (3/9/2011)

---

create table #sample(sno int identity,student_no int, head int,task varchar(50))

insert into #sample (student_no,head,task) values(1,10,'tactical')

insert into #sample (student_no,head,task) values(10,20,'basket')

insert into #sample (student_no,head,task) values(20,40,'aerospace')

insert into #sample (student_no,head,task) values(40,10,'robot')

insert into #sample (student_no,head,task) values(10,40,'tackle')

insert...

Jeff Moden (3/9/2011)

---

Chris Morris-439714 (3/9/2011)

---

clarmatt73 (3/9/2011)

---

Hi All,

I have a stored procedure that has five union queries within it, the first and last queries in the code are the Header and...

You're welcome Matt. If you're still unsure, post up the whole query.

clarmatt73 (3/9/2011)

---

Hi All,

I have a stored procedure that has five union queries within it, the first and last queries in the code are the Header and Footer for the export...

Gianluca Sartori (3/9/2011)

---

Koen Verbeeck (3/8/2011)

---

Tom.Thomson (3/8/2011)

---

Kiara (3/8/2011)

---

Koen Verbeeck (3/8/2011)

---

First of all, as it is international woman day, congrats to all those woman out here!

(who for some bizarre reason love to...

Easily done. Try to get into the habit of using table aliases:

SELECT i.order_number

FROM INVOICE_DETAIL_CONF_ALL i

INNER JOIN ORDER_EXTRACT_AUTO o

ON o.[Ord No]...

Good lord Paul, they get better and better. You have an enviable skill, like Jeff M, at making the...

Dave Ballantyne (3/4/2011)

---

SQLkiwi (3/4/2011)

---

Plagiarism is when you're pretending the work is your own and not giving proper credit.

Copyright infringement is when you're reprinting the work without permission.

It is possible to...

Try this as an alternative:

;WITH CTE_Filter AS (

SELECT drugid

FROM dphadrugdata d

WHERE d.usagetype LIKE '%Non%'

AND d.active = 'Y'

GROUP BY drugid -- <<<---- dedupes, might not need this

) ...

Jim, here's an alternative method. Assuming your new codes are in column A then insert the following into B1 and B2:

="SELECT '" & A1 & "' AS NewCode UNION ALL"

="SELECT...

CirquedeSQLeil (3/1/2011)

---

Fal (3/1/2011)

---

Hey, I thought only code was barred on The...

GSquared (2/28/2011)

---

Jeff Moden (2/25/2011)

---

SQLkiwi (2/22/2011)

---

Steve Jones - SSC Editor (2/22/2011)

---

On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any...

Hocus Pocus