Why does the result set only show data for vendor_id = 15?

It looks like the second result set is either a repetition of previous columns or an aggregation. In...

GilaMonster (1/10/2012)

---

SQLKnowItAll (1/10/2012)

---

mdonald 98074 (1/10/2012)

---

You guys are right. I will go the route of counting my delimiters and adding 1. Thank you. Sometimes you look at something...

still not clear. Please provide the expected output in a readable format (not mangled by the code mystiprettifier)

Why don't you tell us what you think and why you think the questions are tricky and/or what your answer would be?

I think it's fair enough to have a discussion...

On some questions the answer would be "E: none of the above / it depends" (or C, respectively)

Very nice sample data but the expected result is anything but clear.

Can you post in a different way what you're looking for? (maybe even attaching a jpeg)

And if the expected...

Please take the time to read and follow the advice given in the first article referenced in my signature and provide some ready to use sample data.

Furthermore I'd like to...

Something like this?

SELECT TOP 1 xyz FROM table1 ORDER BY xyz DESC

xiaoxiaoli72 (1/10/2012)

---

Or call one of you: BI published on air max 90 Vancouver, STI, as well as B lackspot irreverant advertising and consumption of sneakers, you know a fair trading...

royce.bacon (1/10/2012)

---

Before calling this a bad design you need to consider the functionality the software is providing. If the software allows the users to define the field names and...

Bob Cullen-434885 (1/10/2012)

---

Nick -

I don't know if it matters, but Paul's solution doesn't quite do what you specified, as it doesn't return data for the last date in the report...

Ninja's_RGR'us (1/10/2012)

---

Hey guys, what ressource can you recommend for worldwide list of countries, provinces, zip code, etc. The more the better. We ship to over 100 countries so...

Well, from 600 rows in 5hrs to 4366 rows in 4 sec is quite an improvement!!

Thank you for posting the result!

And again, I'm sorry for not detecting the .query issue...

And here's the CrossTab solution I had in mind:

;

WITH cte AS

(

SELECT

ProductId,

Picture,

ROW_NUMBER() OVER(PARTITION BY ProductId ORDER BY Picture ) AS row

FROM @table2

)

SELECT

t1.ProductId,

t1.SKU,

t1.[Description],

MAX(CASE WHEN t2.row=1 THEN t2.Picture...

Join the two tables and pivot the data using the CrossTab method as described in the related link in my signature should do the trick.