I agree with Alvin. A cte is nothing but chatter in this instance. If you used a cte it would look like this.

with MyCTE as

(

SELECT .... FROM Active_Table WHERE ......

UNION...

eval_stuff (8/13/2014)

---

Returning the four characters "NULL" is NOT the same as returning something that indicates that the content is NULL or that there is nothing to return. A DBMS should...

eval_stuff (8/13/2014)

---

Here is the bottom line and overarching issue (which a previous post touched on): NULL has a distinct meaning and use in the database-world. In the reporting-world, NULL has...

abhas (8/13/2014)

---

Hi,

I am having temp table where i am inserting records from to queries.

eg.

insert into #temp 1

select distinct ft.Teacher,ft.Namefrom #Freqteacher1 ft

insert into #temp 1

select distinct ...

Not soon enough...but scheduled at least. 😀

Not completely sure what you are trying to do here but shouldn't you be referencing INSERTED somewhere in there?

Qira (8/13/2014)

---

Sean Lange (8/13/2014)

---

Not sure what the question is here. Where does job vacancy come from? The structure you have posted seems reasonable enough but I don't at all understand...

Over (sadly)

Not sure what the question is here. Where does job vacancy come from? The structure you have posted seems reasonable enough but I don't at all understand where all of...

Vacation

Lynn Pettis (8/7/2014)

---

Sean Lange (8/7/2014)

---

Well off for vacation for a few days to Colorado Springs. Will be nice to be in cooler air for a few days. See you all...

Well off for vacation for a few days to Colorado Springs. Will be nice to be in cooler air for a few days. See you all next week at some...

Here is one way.

declare @Table table (someString varchar(25))

insert @Table

select 'asdf - 10' union all

select 'asdf - jeik - 10'

select left(someString, len(someString) - charindex('-', REVERSE(someString)) - 1)

from @Table

Take a look at this article from Jeff Moden. It does exactly what you are asking for. http://www.sqlservercentral.com/articles/T-SQL/71550/%5B/url%5D

SQLRNNR (8/7/2014)

---

Sean Lange (8/7/2014)

---

jcrawf02 (8/7/2014)

---

Sean Lange (8/7/2014)

---

GilaMonster (8/7/2014)

---

Speaking of... If you tried running a query against a table (a simple select)...