Gosh :blush: thanks! Hang around here, read the articles...you'll soon pick it up.

winmansoft (3/7/2013)

---

ChrisM@Work (3/7/2013)

---

yes - do this instead:

DECLARE @Parameter VARCHAR(8000)

SET @Parameter = 'seh,jyo,mhf'

SELECT *

INTO #Elements

FROM dbo.DelimitedSplit8K (@Parameter,',')

SELECT m.*

FROM...

SELECT MAX(Ticket_Closed_DateTime)

FROM Tussen_Tickets

-- returns '2013-01-17 10:22:00.000'

DECLARE @ItemCod VARCHAR(8000) = 'T1;T2;T3;'

DECLARE @ItemName VARCHAR(8000) = 'Pencil Box;Eraser;Mouse Pad;'

DECLARE @Amount VARCHAR(8000) = '1900;2000;8900;'

SELECT

c.ItemNumber,

ItemCod = c.Item,

ItemName = n.Item,

Amount = a.Item

FROM dbo.DelimitedSplit8K(@ItemCod,';') c

INNER JOIN...

purushottam2 (3/7/2013)

---

Which one is more performance oriented query?

1. SELECT 1 FROM table1 WHERE Id IN (SELECT Id FROM table2)

2. SELECT 1 FROM table1 t1 INNER JOIN table2 t2 ON t1.Id...

This is called "Islands and Gaps". An island is a set of rows where the dates are consecutive, bounded by rows with non-consecutive dates. Jeff Moden has a great Spackle...

winmansoft (3/6/2013)

---

Thank you

I found that i can do this

DECLARE @Parameter VARCHAR(8000)

SET @Parameter = 'seh,jyo,mhf'

DECLARE @Elements TABLE

(

...

Revenant (3/6/2013)

---

I am calling it a day. I will head to Black Raven http://blackravenbrewing.com/ to down a pint of their Totem Ale (or two).

BTW, the linked page gives you a...

geert.de.vylder (3/6/2013)

---

ChrisM@Work (3/6/2013)

---

I've no idea, Geert. Folks here on SSC will help you with coding decisions; this is more of a business decision. A date filter seems sensible to me...

geert.de.vylder (3/6/2013)

---

ChrisM@Work (3/6/2013)

---

I've no idea, Geert. Folks here on SSC will help you with coding decisions; this is more of a business decision. A date filter seems sensible to me...

If there really are always four elements, then you could use PARSENAME (look it up in BOL):

;WITH SampleData AS (

SELECT MyString = 'Scrap : Part Assembly : Surface Defects :...

geert.de.vylder (3/6/2013)

---

ChrisM@Work (3/6/2013)

---

I meant in terms of potentially reducing the rowcount.

Let's call a set from this table containing the same day, all of the intervals, and the same Event_Channel,...

geert.de.vylder (3/6/2013)

---

I have to...

Ratheesh.K.Nair (3/6/2013)

---

Thanks Chris for the reply.

Problem i am facing is When selecting I am getting same data while using symbol F or F as search criteria both are giving the...

That sounds about right. The matrix table contains 1,180,224 rows (all dates and event channels...