Hi mister,

nope, the data is not consistent.

Hi WayneS,

thank you so much for working query. I am curious to learn about cross apply used here. I will play with that. Appreciated...

thanks Steve and to avoid & charecter issue, slightly modified your query. Thanks for your base query

SELECT

t1.zipcode,

t1.State,

t1.City,

STUFF(t2.[Name],1,1,'') AS [Name]

FROM

(SELECT DISTINCT zipCode, [State], City FROM @table) t1

CROSS APPLY

(

SELECT

(

SELECT ',' + [Name]

FROM...

Sure. thanks Gail and Luis

Hi Gail,

When i see the table structure and question, i am also confused with the same questions. i still didn't get authorization to see the data. I am...

Hi Eirik,

this is the structure i could see. I don't see any indices. any query please

Thank you guys. I figured out and adding a condition to drew's code worked for me.

much appreciated for your time.

Hi Drew/Sumngson,

thanks for your response. once condition is missed on your query. If the offer is not available at company level then we need to check on client level based...

Thanks you lynn and Sean, much appreciated.

I have created months table. trying with charindex but no idea how to move forward. would you like to help me in this please

Hey sean,

Thanks for your reply, i am sorry that i misspelled. it is 3 char month. JAN/FEB/MAR/APR/MAY/JUN...

Any thought/ sample pelase

Wonderful. thank you so much. i will work with my real data and post back to you in case of any tricky situation. much appreciated.

Hi Eirik,

appreciated your time and wonderful help. My ultimate goal is to clean up the address field. address field should only have the address. Any thoughts please.

Hi Eirik,

thanks for your time on this, please assume that i have city,state,zip in a separate table called tbl_city_state. please proceed with your suggestion/sample based on tbl_city_state table

thanks

Hey Guys,

thanks for your reply.

I Eirik,

before i though of posting on this forum, i thought about using Jeff's delimit function what you have suggested. But i am sorry that i...

Thanks Eirik for the reply.

My thought is that the cost of explicitly/implicitly creating a temp table and populating it by far outweighs the cost of running the query twice (or...