Duplicate post, please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1266908-338-1.aspx

Like stated above you will have to do some string manipulation to remove the last 3 decimal places.

Aside from that the code you posted conflicts with what you are...

I believe that sparse columns was not available until 2008.

No such thing as SQL Server 2006...but I believe the IN keyword for procedures is from MySql and not SQL Server. 😉

If you post your original sql into a ssms window the create schema will be red squiggly. On mouse over it will tell you exactly that. 😉

You have a few syntax issues there. Not sure where you came up with "IN". I assume you are trying to indicate an inbound parameter? Also your parameter is a...

I think you would probably spend as much, if not more, time writing a solution to automate this than it would take to just do it manually. The upside of...

LOL. Sorry to add rework to your plate. 😛 What you describe sounds like a pretty solid approach. I don't know if the additional table is needed for the "other"...

CREATE SCHEMA must be in its own batch. What that means in context of your script if you will need to execute your create schema via dynamic sql.

thbaig1 (3/14/2012)

---

Hi,

I want to move data from one node to another. Data is corrupted by developers , so I can't move all.

I want to know that is there a way...

LOL the link is actually in my signature but it is certainly a good primer for new folks.

You can get your desired output a little more clean by using IFCode...

Take a look at Gail's blog post on catch all queries. It sounds like you are doing something similair??

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

No idea what the benefit of something like this would be but in order to get your desired output you are going to have to become very familiar with dynamic...

It sounds like the table you are starting this conversation is not normalized. It contains columns 2-10 which are in effect the same type of information. The scenario you are...

satishchandra (3/13/2012)

---

My Actual tables has more than 50 columns, of which only 3 columns needs to be distinct, on any row, and has many data rows. Tried to simulate the...