YSLGuru,

Sorry for being off topic but I'd really like to know who said that quote in your signature.

I live in Bangkok and I'm not sure if you know what is...

Because Historical is an INT data type. When you insert ' ' to it, SQL converts it to 0. Look at the output from your first query.

So you...

I wrote this FUNCTION a long time ago. Note that it is case sensitive.

CREATE FUNCTION [dbo].[NestedReplace]

-- Author: D. Camps

-- Date: 24-Jan-2013

-- Remarks: NestedReplace is designed to repeatedly apply...

DataEnthusiast (2/18/2014)

---

I'm barely decent with Sql and I never understood how CTEs work. So I used the Cross Apply route :-p

P.S: How do you paste your code in separate...

zulfansari (2/18/2014)

---

Hi Guys,

Hoping you could help out again, I've been working on this all day long but no luck.

I got the query in the system, based on the following results,...

Thanks for letting me know that Sean....

jcrawf02 (2/18/2014)

---

dwain.c (2/17/2014)

---

Jeff Moden (2/17/2014)

---

dwain.c (2/17/2014)

---

Jeff Moden (2/17/2014)

---

zulfansari (2/17/2014)

---

Hi Jeff, Dwain.c and SQLRNNR,

You guys are AWESOME..

I really appreciate your help and learned new tips and tricks from all of you..

God...

I suggest then that you reduce the date range (from, to)...

Jeff Moden (2/17/2014)

---

dwain.c (2/17/2014)

---

Jeff Moden (2/17/2014)

---

zulfansari (2/17/2014)

---

Hi Jeff, Dwain.c and SQLRNNR,

You guys are AWESOME..

I really appreciate your help and learned new tips and tricks from all of you..

God bless you...

Jeff Moden (2/17/2014)

---

zulfansari (2/17/2014)

---

Hi Jeff, Dwain.c and SQLRNNR,

You guys are AWESOME..

I really appreciate your help and learned new tips and tricks from all of you..

God bless you all!

Just an FYI,...

You're right! That was kind of doggy wasn't it? Try this instead:

CREATE TABLE dbo.OriginsDestinations

(

Origin INT

,Destination INT

,PRIMARY...

With some DDL including indexing on your table it might offer a clue.

Looks like an awful lot of work and an awful lot of DISTINCTs. Wouldn't this be simpler?

WITH SampleData (Origin, Destination) AS

(

SELECT 1, 2

UNION ALL SELECT 2, 1

UNION ALL SELECT...

The Newton-Raphson approach to finding roots can also be done in an rCTE:

Exploring Recursive CTEs by Example [/url]

You can also just use:

NULLIF(@device, '*') IS NULL