Click here to Skip to main content
15,892,005 members

Comments by njdcjk (Top 15 by date)

njdcjk 18-Jul-14 5:14am View    
Sorry.I think u did'nt get my requirement properly.
Here is my table's structure..With three columns

Id Address Name
1 Street A John
2 Street B kim


And the expected output is like this:



Id_1 Address_1 val_1 Id_2 Address_2 Val_2
1 Street A John 2 Street_B Kim


For example purpose i have taken two columns only....but this will be more and the column names should come accordingly..
njdcjk 18-Jul-14 3:53am View    
I want everything to be in a single row
njdcjk 6-Dec-13 8:21am View    
can u explain in detail
njdcjk 6-Dec-13 8:08am View    
I have tried again.But still it's not working..
It will work when something is there in remarks column.If remarks column is null it will not work..
njdcjk 6-Dec-13 6:33am View    
I tried but it's not working..reason is still null only