Re: Help! my compaq laptop wont turn on Hardware and Software Microsoft Windows by akyra83 … message...hundreds of these but with different number after "DWH" this time i wrote it down MISSING: \DEVICE\HARDDISKVOLUME1… Re: Object reference not set to an instance of an object Programming Software Development by user220 …; <add name="connstring" connectionString="Data Source=DWH;Initial Catalog=Test;Integrated Security=True"/> </connectionStrings… DWH Data In Wrong Column Programming Databases by shujat132 I am working in a dataware house and few things are not clear to me that is why I wanna discus here. For example, I have 10 MS Access files, and each of they have more than 5000658 number of rows, and data is in such a format like **Plz check attached image currentState.png** Whereas I have to import this large amount of data into MSSQL which … Re: DWH Data In Wrong Column Programming Databases by LastMitch >So now plz tell me that what to do in this situation how to bring data in correct format, so that it will give right answer when I will run quires in MSSQL. It's the weekend. I doubt if someone have MSSQL to test a query. What query do you have so far or what format are you trying to created. Any samples? Just to get an idea what you are … Re: DWH Data In Wrong Column Programming Databases by shujat132 to know about required format plz check attached image of table. and i am atucally working in data ware house. Re: DWH Data In Wrong Column Programming Databases by LastMitch >to know about required format plz check attached image of table. and i am atucally working in data ware house. I don't understand your situation. I feel you are not asking or doing a query now but you want to know how to speed up the query meaning getting the data from the database quickly? Is that what you want to do? Re: DWH Data In Wrong Column Programming Databases by shujat132 dear brother actually i have explained it in first post, i know how to speed up query for that purpose i need to do proper indexing. for now, i want to actually data is misplaced in column like data of "Name" column is in "Address" or "Date" column. so i want to put data in their original column. to get better … Re: DWH Data In Wrong Column Programming Databases by JorgeM I dont see how you are going to fix this programatically. I dont even see a pattern here. I know this sounds cray, but what I would do is export this into a spreadsheet (Excel) and try to group the rows into sections that "match" There should only be 5 groups because you have 5 columns. One of the groups is going to be correct. So … Re: DWH Data In Wrong Column Programming Databases by shujat132 Any other solution….? Because it’s quite difficult and lengthy and very soon I will have more records of 230 million number of rows. So I will not be able to so that much lengthy works. Can some body suggest me any better solution.