Retry

Nice Chris, I hope that this helps Eliseo.

I think that I understand what you're saying about the TOP filtering before the aggregate, even if the execution plan indicates otherwise with...

This site can help you: http://docs.oracle.com/cd/E18283_01/nav/portal_booklist.htm

Also, even if it's supposed to be used to move from Oracle to SQL Server, this could help you to check differences and similarities: https://mva.microsoft.com/en-us/training-courses/sql-server-2014-essentials-for-oracle-dbas-9062?l=VGDAvmR4_7004984382

Just convert your ntext column to nvarchar.

ChrisM@Work (7/7/2016)

---

That was my first thought too Luis so I set up...

Was that post a downgraded version of this one: https://www.brentozar.com/archive/2012/06/sql-server-poor-performance-checklist/ ?

Are you looking for this function?

NULLIF (Transact-SQL)

It seems that you could have a data issue. The amount of data is not similar on both dates.

The TOP 1000 is not helping because it needs to group the...

Your condition is the same as writing WHERE R.RoleName = @String

Either you split the values (the best splitter can be found here: http://www.sqlservercentral.com/articles/Tally+Table/72993/) and remove the quotes.

SELECT DISTINCT UT.TaskID, UT.TaskName,...

PJ_SQL (7/6/2016)

---

Sorry to keep changing requirement:

ColA:

AAAA-AOP/W 00160000

ASSSS-DOU/W00160000

O/OF EEEE 00000000

So, I need to split the column on the criteria that if it starts with 0 then split it...

You're really not helping us to help you. My suggestion would be to use the DelimitedSplit8k which can be found here along with its explanation:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Having that, the query would be...

PJ_SQL (7/6/2016)

---

How do I split Characters and numbers from sql:

I have this data :DEP-A CALLEJ00025000

Need

cola ...

TheSQLGuru (7/6/2016)

---

Luis Cazares (7/6/2016)

---

You're over complicating yourself. Here's a simpler version of your query.

SELECT l.pageno,

l.batchid,

l.loadid,

n AS lnidmin,...

You're over complicating yourself. Here's a simpler version of your query.

SELECT l.pageno,

l.batchid,

l.loadid,

n AS lnidmin,

...

Here's an option using a tally table. If you don't know what a tally table is, read the following article:

http://dwaincsql.com/2014/03/27/tally-tables-in-t-sql/

I'm not sure if my math is more complex that it...