Sean Lange (1/20/2015)

---

Ed Wagner (1/20/2015)

---

Brandie Tarvin (1/20/2015)

---

Sean Lange (1/20/2015)

---

We are finally starting to move our ERP to a new system (well new to us but still rather antiquated). In the...

I suggest you read this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I am not a...

Not to repeat myself or nuthin'

ashokputta9 (1/19/2015)

---

Hi everyone i want split the data this below format..

1.Split the RR ("PL:TW RR:1.8%,PL:TX RR:0.9%") into LowendRR ("PL:TW RR:1.8%") and HighendRR ("PL:TX RR:0.9%")

2.Split the LowendRR ("PL:TW RR:1.8%") into LowendPL...

With DDL and some consumable sample data, I'm sure you'd get a working solution pretty quickly.

Barring that, the right track is to use a calendar table:

http://www.sqlservercentral.com/blogs/dwainsql/2014/03/30/calendar-tables-in-t-sql/

WITH SampleData (RR) AS

(

SELECT 'PL:TW RR:1.8%,PL:TX RR:0.9%'

)

SELECT LowendRR, HighendRR

,LowendPL = RIGHT(ls, CHARINDEX(':',...

Another solution for those inclined to the cryptic:

SELECT XBit, CreateDate, b

,ROW_NUMBER() OVER

(

...

As if you really need my...

About the only thing this doesn't do is reformat the date into precisely the string you want (I used CONVERT with the 106 argument to demonstrate).

DECLARE @Year DATE...

GilaMonster (1/15/2015)

---

Sean Lange (1/15/2015)

---

I am having a discussion with somebody who swears that using

EXISTS(select 1

is way faster than just select *. I know Gail has an article on her...

Jeff Moden (1/16/2015)

---

Hi Dwain,

Great article, as usual. It spawned some pretty good discussion, as well. Well done and thanks for taking the time to write something like this.

I...

As several folks have pointed out, it is not necessary to use the IS NOT NULL test in a CTE to get the INDEX SEEK, as the same query plan...

Post deleted. I thought I was in the SQL 2012 forum...

Using VPV's setup data:

WITH Daytab AS

(

SELECT 'Daytab' AS src, 2014012 AS acctg,'West' AS region,'UT' AS state, '1st' AS Half, '12/6/2014' AS date, 178.00 AS amount UNION ALL

SELECT 'Daytab' AS src,...

Using JeeTee's sample data:

WITH a as

(

select myKey = 1, someVal = 'A' union all

select myKey = 2, someVal = 'B'

), b as

(

...