J Livingston SQL (10/28/2011)

---

Hi Ki

I will try again with your test rig....earlier on I thought it was my PC playing up...until I saw Jeff's post.

think I will reboot and start...

Hi Ki

I now where you're going with this construction (APPLY with row generation), it makes sense and looks cool - but it's quite expensive. In this case, plain old-fashioned syntax...

If you can't write to the database, then and only then your best option is a recursive CTE, as follows:

DROP TABLE #MySample

CREATE TABLE #MySample (ID INT, [counter] INT)

INSERT INTO #MySample...

Our...

It's easy to think Sort = bad, but that's not necessarily the case, just...often.

SET STATISTICS TIME OFF;

PRINT '===== Mark''s Code (98% of batch) ================================================================================='

SET STATISTICS TIME ON;

WITH AllAlpha(Letter) AS (

...

Heh all finished? Here's another way:

SELECT String = SUBSTRING('ABCDEFGHIJKLMNOPQRSTUVWXYZ', start, length)

FROM (VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26)) t1 (start) ...

ekant_alone (10/17/2011)

---

I have a table enployee and a column gender.

The possible values in the table are 'm' or 'f'

In this puzzle i need to swap m with f and f...

SQL Kiwi (10/17/2011)

---

Just remembered: there's an optimizer improvement in Denali SQL Server 2012 RC0 (not...

Aspet Golestanian Namagerdi (10/15/2011)

---

Actually I need the output.

If I remove the select statment runs very fast.Is there anyway to remove that select statment.this code has been generated from Stored Procedure...

An index containing childid and parentid (and nothing else).

You could also consider creating the clustered index over these two columns - unique if possible.

What other columns are there in...

You could pivot the result of a rCTE but this is easier to code and tons easier to get your head around:

SELECT n1.PARENT_ID, n1.CHILD_ID, n2.CHILD_ID, n3.CHILD_ID, n4.CHILD_ID, n5.CHILD_ID

FROM TABLE1 n1

LEFT...

Jack Corbett (10/7/2011)

---

You don't want the UNION you want 1 query with 2 COUNTs like this:

SELECT

tblUCSU.strLocationName,

COUNT(dbo.tblTACSU.Pen) AS Trunks,

...

jared-709193 (10/3/2011)

---

PEOPLE!

If this query:

SELECT CHARINDEX('</t2>', data)

FROM TableName

WHERE CHARINDEX('</t2>', data) < 4

returns ANY data, (which it has already stated it does) the substring will fail every time on the data...

Yes, several, but union (without ALL) would be best. Why do you...

Nope, but it sure will make it easier to find - this time and the next.