MackF (3/29/2013)

---

I am now testing this one:

CREATE FUNCTION fnSplitString(@str nvarchar(max),@sep nvarchar(max))

RETURNS TABLE

AS

RETURN

WITH a AS(

SELECT CAST(0 AS BIGINT) as idx1,CHARINDEX(@sep,@str) idx2

UNION ALL

SELECT idx2+1,CHARINDEX(@sep,@str,idx2+1)

FROM a

WHERE idx2>0

)

SELECT SUBSTRING(@str,idx1,COALESCE(NULLIF(idx2,0),LEN(@str)+1)-idx1) as value

FROM a

Execution is more...

mrivero1961 (3/28/2013)

---

Sean Lange (3/28/2013)

---

This is MySql. If you want to join multiple queries together you probably need to use UNION.

I really can't tell from what you have posted what the...

Then you...

This is MySql. If you want to join multiple queries together you probably need to use UNION.

I really can't tell from what you have posted what the actual issue is...

mrivero1961 (3/28/2013)

---

Thank you for help.

I've modified the query, but the output not change:

SELECT

DATE_START,

COALESCE (idDGIG, 'Tot') AS sGIG,

`NUMBER`

FROM

(

SELECT

CA.DATE_START AS DATE_START,

LEFT (CA.idDGIG, 2) AS sGIG,

COUNT(CA.idDGIG) + COUNT(A.EVENT) AS NUMBER

FROM

TABLE_LONG CA

JOIN TABLE_SHORT...

kk1173 (3/28/2013)

---

Then why is the performance fast if i go directly against the employer table instead of view.

For e.g.

select * from Myview where display like '%aarp%'

returns 26706 rows in 51...

texpic (3/28/2013)

---

Well I think it is a different question because I haven't seen it asked.

If I do not have a join, I can do a query like this:

SELECT * FROM...

The queries you posted have some stuff missing.

In all cases you don't need to get the left 2 characters and then use like '%%'. The left can't possibly return anymore...

Check out this article from Gail. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

Then performance is never going to be very good for this. This is looking through...

Actually I can read java without much effort.

Honestly I don't think converting this to straight t-sql is feasible in an online forum.

There are least a dozen methods that have not...

Code-1029433 (3/28/2013)

---

I'm needing to store a SQL statement in a VARCHAR(MAX) column in a database table, however I'm having trouble getting statemen to insert. What is the best aproach to...

Brandie Tarvin (3/28/2013)

---

Sean, This won't necessarily work for...

You can certainly come up with something that will not be so ugly. However it is not possible for anybody to offer much more than vague ideas at this point...

Actually this won't run it for every row. The...