Can some help with the Tsql query to bring data as per below aligned format without null values. Need it urgent. ![alt text] ![alt text] : /storage/temp/3712-2016-10-07-1249.png : /storage/temp/3713-untitled.png
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.