Cool. Glad that you figured out a solution. You could simplify your query to...

cbrammer1219 (10/6/2014)

---

I just did this..

select distinct

extension

from tblEmpData

where LEN(extension) > 3 and extension not like '6%' and DEPARTMENT like 'Service%'

union all

select distinct

case

when agent_id is not null...

cbrammer1219 (10/6/2014)

---

Because there is also a extension field, sorry guys copied the wrong query. I am trying to put extension, agent_ID and agent_ID into extension, sometimes one extension will have...

Yummy!!!

jvkondapalli (10/6/2014)

---

Hello,

We have Identical hardware on two servers. Also, Index fragmentation and statistics are same. But, Execution plan is different for the same query.

Server 1 was generating bad plan....

Something like this if I understand what you are after.

SELECT AGENT_ID

FROM [AA_Helper].[dbo].[tblEmpData]

where AGENT_ID is not null

group by AGENT_ID

union all

SELECT agent_id2

FROM [AA_Helper].[dbo].[tblEmpData]

where agent_id2 is not null

group by agent_id2

Now unless you include...

cbrammer1219 (10/6/2014)

---

I created one cte, and then union all the select of agent_ID2..Like this

;with

csServiceExtAgentID(Extension) as

(SELECT DISTINCT

CASE WHEN [AGENT_ID] is not null then AGENT_ID end as extension

FROM...

LittleDuck (10/6/2014)

---

Hi all,

I'm trying to create some SQL to then run a Cognos report. This is what I have so far but I am finding that every few runs...

Here is a hilarious video. Anybody involved in Scouting should appreciate this. I am sure there are others involved with scouting besides Grant and myself. http://www.youtube.com/watch?feature=player_embedded&v=mgmbwRgfVhc

Ed Wagner (10/2/2014)

---

Jeans...

Corduroy (more ack)

Divan

This is one of those rare times when you can get away without defining the scale of a varchar. When you use varchar you should ALWAYS specify the scale.

Fuzzies

Koen Verbeeck (10/2/2014)

---

Sean Lange (9/29/2014)

---

Koen Verbeeck (9/29/2014)

---

Sean Lange (9/29/2014)

---

I know that this is not neccesarily your design but starting all your table names with tbl_ and storing the datatype used...