asked
!!!T-SQL Query Help
Can some help with the Tsql query to bring data as per below aligned format without null values. Need it urgent. ![alt text][1] ![alt text][2] [1]: /storage/temp/3712-2016-10-07-1249.png [2]: /storage/temp/3713-untitled.png
I have tried everything right from joins to pivot. tried cte too. now I am doing it by while loop but its not accurate.. I think its not possible to bring such data in the given format. And also data is not constant in each column so in this case I dont think it can be done.
If there's no key between what makes 970469 come together with 963005, there's no way to solve this. Data in a table is unordered by definition (regardless of clustering key and therefore physical sort order on disk). In order to solve this, you need a key to order the data on. Even if a Query gives you the result that 970469 comes Before 1027486, it might just as well end up the other way around the next time you run a select Query. Perhaps you have a primary key in this table, which is not shown in your example, but if you don't, you have a problem which cannot be solved.
18 People are following this question.
