Hi Eirik is there performance difference between pivot and cross tab? Curious to know. Thanks

Hello Jayanth,

thanks for the replay and i am not sure what do you meant by idle. Lets proceed with example, i have to deal with 500*1000 records using the...

thank you allen, eirik and sgmunson.

opps. Sorry for the confusion. I meant to say, those two records should be displayed in the output because it was wrongly mapped.

Hi Chris,

Sorry, Am not sure whats wrong in the test data. Please help me on understanding what wrong in test data.

Hi Eirik,

Thanks for your sample.

Hi Chris,

Thanks for your reply and @Process and at @steps are two tables.

select ProcessName,S.Stepname as parent,S.stepname as child from @Process P join @steps S.......

any suggestions and sample please

Hi Eirik,

This is excellent approach and did clean almost. Thank you very much Gentle Man!!!.

Hi Eirik,

I am into trouble now about some street names having names city name and the current logic removed the the street name as well

ex:

address = '555 Manhatten street,...

thankns Ralls

thank you jeff for your time on this. below is my version. But your version is much more cleaner and straight forward.

;WITH Rel AS

(

SELECT ParentId, name,company,Salary,ValidUser,...

Thank you Eirik.

This is my try and working fine for meSELECT coalesce(CM.message,CMT.message)

FROM @comp C

LEFT JOIN @compMessage CM ON CM.idcomp = C.idcomp

LEFT JOIN @clientMessage CMT ON CMT.idcomp = C.idcomp

where c.idcomp = @idcomp.

Any suggestion/alternative...

Wonderful and appreciated your help. Worked like charm.

Thanks Grant

hi Grant,

Thanks for your reply and if that is the case what is the best way to achieve this. If am not, the proc modified (adding removing column or etc),...