(dfalso, btw)

No...

Another way you can go is making a temp table (#) and use that in the stored proc. As long as you create it in the outer session that's calling...

Trader Sam (3/17/2008)

---

I...

I tried this on a SQL 2005 box here and my third resultset is empty.

I get 5 records, 5 records, 0 records, 3 records, and 13 records.

As noted above, you should definitely put brackets (QUOTENAME()) around your column names in the column list generation.

If I had this issue, the first avenue I would explore is whether I could order the partcodes in the order I thought was correct. If so, your best bet...

xpscodes (3/10/2008)

---

Thanks for the review. I thought no one will bother looking at the query as the original poster was satisfied with Mark's solution.

One of the issues I saw above...

Sorry, I should have been more clear. The poster needs to be very, very sure that none of his dates are in day/month/year format, which you see used in Europe...

With the gigantic caveat that your slashed data is always stored month/day/year.

What is your table structure? I didn't see this explicitly...may make a difference.

Note that I wrote this still using your PK values as the series identifier, but if the timestamp values is better (see my previous comment), you should change the code...

Not to trash on your code, xpscodes, but I don't think it works completely like the original poster wants (or ultimately needs, if I understand the goals correctly). But I...

I'm not sure why you're trying to create a temp table in an exec statement, but I have some ideas because I used to do it myself. So I have...

Chris Schanno (3/6/2008)

---

Jeff,

Yes, I would consider using a cursor over the set based approach depending on the circumstances such as the size of the dataset and use for which I...

eddy (3/3/2008)

---

Hello tony,

Can i include (or create) views based on functions .??

I already noticed that the possibility of including stored procedures is not possible...

Chriss, tnx for the tip on the...