Hi jeff. Do you know if this is still possible?

As a side note, the app we're using wouldn't need to render all rows as a selection would probably be made to limit the amount of data returned.

Maybe that would...

yeah, I think i see what you mean. I guess it will grow exponentially

:/

I think I may have misled you. in the text file, there's around 18000 records in total per month. Below is what I wrote previously. However, the last sentence,...

There around 18000 rows in total.

🙂

That's right Jeff. I did a Distinct on the ProductID column and that was the amount of unique productID's that were returned.

Cheers

I think we could break the query into separate months so each query would only show days of the same month and then load that into a table.

There is around...

Thanks again.

I'm sorry, I've not really used code in Visual studio and I'm perplexed. I added the code. Do you know if I'll still be using a Execute...

Thanks for your reply. I'm not really sure how to build an sql query statement using the function MessageBox

Am I right in saying I click on Edit Script on...

Hi Jeff,

Please see below more info about the data and schema. The data I'm using has been extracted from a cube into a text file. the 'Day' column has...

I appreciate the help Jeff.

I think I should add that day 2 does not exist in the current table at all. It would look more like this.

Day...

Repeat post mistake

mark-101232 02/09/10

This may be slightly better

SELECT x.FaultID,

x.StoreID,

x.CallOut

FROM #Sample x

WHERE EXISTS (SELECT * FROM #Sample s

...

Just to let you know. I tried this one from another forum and it touched 56 rows. I've not tried your method yet Wayne, but I wil let...

Hey Matt, very smart, thanks a lot for this. It seems to work and performance seems ok

🙂