If considering doing something similar in production you might want to ensure your 'words' source doesn't include things like the F and C bombs 🙂

Thanks John.  I realised about 2 minutes after posting.  It's code I have come across due to the error today and isn't how I'd have done it.  My approach would...

PLease ignore question - i had missed the obvious and have figured it out.

I can't speak for anyone else, but my complain about the point was done with my tongue firmly in my cheek! 😉

Give me my point !!!!!

Seems to be missing the AS s aliasing.

select cast(case datepart(dw,Loaddate)

when 1 then dateadd(ww,-0,Loaddate-6)

when 2 then dateadd(ww,-0,Loaddate)

when 3 then dateadd(ww,-0,Loaddate-1)

when 4 then dateadd(ww,-0,Loaddate-2)

when 5 then dateadd(ww,-0,Loaddate-3)

when 6 then dateadd(ww,-0,Loaddate-4)

when 7 then dateadd(ww,-0,Loaddate-5)

end as...

Thanks everyone. I've found a solution. I've added Row_Numbers partitioned by Model, and then used CASE and the rownumbers to return the Features into columns - easy when...

< sound of penny dropping >

Drew, you've given me the solution - concatenate the Features (with a delimiter) in one column.

As the purpose is essentially to populate an excel...

That's worked. Thanks a lot.

Jason

. . . . oh, and BTW, thanks to everyone on SSC - I couldn't have done it without the articles & help that I'ver picked up on the forums!

That's the one!!

That's it! thanks.

I've had to shuttle the data into tempdb on one of our 2005 servers though to get this to work.

Do you know if this is even possible...

Thanks for the reply, but that doesn't quite work. Try this, and you'll see what I mean:

create table #t (Data VARCHAR(30))

INSERT #t (Data)

VALUES ('abcssdef'),

('abc[ss]def'),

('abc[70ps]def')

select * from #t

where data...

This is a fairly poor Featured Script. Isn't the point to shed some light on the methodology rather than simply posting script and result. And where's the DDL...