Sorry, I quoted the wrong response last time, this worked perfectly, thank you very much.

I must have missed it in the link earlier, most likely because I don't quite understand...

ColdCoffee (9/20/2010)

---

If your input is as what Chris Morris said, then this would help you

DECLARE @CSV VARCHAR(100)

SELECT @CSV = '1,2,3,4,5'

SELECT x.i.value('(./text())[1]','INT') AS IDs

FROM (

...

Yes, that's exactly it, here's a small portion:

SELECT 1502280,1506687,1504669,1501368,1500801,1500861,1501163,1521193,1500650,1500788,1512239,1500139,1502181,1500537,1500321,1506314,1502755,1505270,1500400,1515167,1505350,1509675,1500196,1502599,1501572,1501226,1517844,1503169,1512954

Thanks for your quick reply. I took a look and wasn't able to find a solution.

Were you referring to cross apply? I didn't think I could use that...

Worked great. Thanks again.

Luke,

I noticed something. After implementing that new query, some data isn't showing up. Specifically, Clients aren't being show where there are no associated projects. I've been...

Ahh, when I broke it down like that and only ran parts of a query one at a time it made more sense.

Thanks again, I've been working on that single...

Amazing, thanks so much for your help.

The solution works perfect, I just don't quite understand it, but I don't really need to.

Stephen

I've attached the complete table structure and some test data.

Stephen

Thanks for all of your help so far. I updated the table definitions to reflect the CreatedOn column.

I'm able to get the records that I need to determine the...

I don't believe that will work. Did you see the updated the list of columns in the respective tables?

Stephen

Sorry, I think I might have been misleading. Here are the table structures...

[Clients]

ID

Client

[Projects]

ID

Name

ClientID - Relates to Clients.ID

[ProjectStatus]

ID

Status

[ProjectStatusHistory]

ProjectID - Relates to Projects.ID

ProjectStatus - Relates to ProjectStatus.ID

CreatedOn (When the status was...

It's possible for one project to have a Status of "Open" multiple times, for example, it's it's Open, then closed, and reopened for upgrades. In that case, it would...

You're right. I think I misunderstood when I initially read it.

I don't have too much experience using views. How to I account for NULL?

The way I'm doing it...

I don't think I'd be able to use a view in this case, reason being, I need a way to track token transactions, example being reducing the amount of tokens...