You got zero (0) because...

May actually want to use DENSE_RANK() instead.

Matt Miller (#4) (8/5/2014)

---

put a ";" in front of the WITH. WITH is very finnicky about having a separation between it and any previous SQL statements

As in:

Select *

From CampServ.dbo.SampleFakeCustomerData

//This...

rohitnegi09 (8/5/2014)

---

Hi All,

i am doing search through Date Range but didn't get correct result.

For Example if i created a Task on 5/8/2014 and when i have take Date Range from...

Well, that's good. Too bad there is nothing there to indicate order of rows.

Really need to start at step one, which is to read the first article I link...

DDL (Data Definition Language), in this case the CREATE TABLE statement(s) for the table(s) involved in your query. ...

e1(n) <<...

New_2SQL (8/4/2014)

---

Hi Lynn Pettis,

Thanks for your help and sincere efforts. The view is working as desired.

I have gone through your Forum Etiquette and understood it well. My future postings will...

Greg Edwards-268690 (8/4/2014)

---

SQLRNNR (8/4/2014)

---

Lynn Pettis (8/4/2014)

---

Don't you just love people that ask for help but tell you it can't be a certain way, especially when the way the say it...

All it takes is some converting (and perseverance) and you can convert an itvf into nested derived tables. Glad this is a SQL Server 2008 forum as it did...

Don't you just love people that ask for help but tell you it can't be a certain way, especially when the way the say it can't be done is the...

Using a function, your solution is this simple:

CREATE TABLE #Test

(MyName varchar(10), MyCommaData varchar(50));

INSERT INTO #Test

SELECT 'Tom', '10,20,30,40' UNION ALL

SELECT 'Ed', '11,21,31' UNION ALL

SELECT 'Sue', '10' UNION ALL

SELECT 'Jill', '';

go

select

...

Please explain why you can't use a function? That requirement makes no sense unless this is a homework assignment.

From what to what?

Whom ever has the Great Mystical Crystal Ball, you are needed here.