We need more details... What software were you using to actually make the connection? There are numerous ways to do such a thing, including SSIS,...

I agree with GSquared - without access to your data or at least a sanitized test copy thereof, determing a cause could be difficult if not impossible. However,...

What this boils down to is a data type problem. I'm not aware of another solution, but have you Googled it ? SSIS uses what it...

Chris Harshman (12/12/2012)

---

tanvishriya (12/12/2012)

---

-- Creating Unique constraint on [ESId] in table 'ES'

ALTER TABLE [dbo].[ES]

ADD CONSTRAINT [IX_ESID] UNIQUE ( [ESID] )

GO

-- Creating foreign key on [EStId] in table 'ES'

ALTER TABLE [dbo].[ES]...

I think someone needs to rethink the idea that human beings are going to be able to make much use of a report with 1024 + columns. The...

Ok, that's a start, but I still don't know what "can't load" means. What is the basic process to load this file? Is the web page...

The ED table needs at least 1 unique field, and you can create the UNIQUE constraint right in the table definition if you don't care what name it has. ...

So, are you performing this migration with SQL 2005 ? This is a SQL 2008 forum. However, the KB article clearly indicates what causes the problem...

DataAnalyst011 (12/12/2012)

---

Thanks for your reply also.

I didn't do a very good job setting this up. I just tried to create a quick example to ask about a concept -...

I can appreciate that sometimes you can't say exactly what you're doing, but for anyone to help in this scenario, you're going to have to at least be more specific...

Sean Lange (12/12/2012)

---

I merely suggested changing the existing table...

How many rows do you have? The function to do it is RTRIM. CONVERT isn't necessary. You create a Linked Server on the new...

Well, I managed to find a working example, and perhaps you can tailor this to suit:

declare @a table (a int null, b int null)

insert @a values (1, 1), (1,...

Ok, how about:

select cr.sup, cr.part, cr.loc, cr.countrank, cr.days,

NTILE(days) OVER (PARTITION by cr.days, LOC order by countrank desc) as partitionday

from cc_v_countrank cr

and if the results aren't quite right, try reversing the...

Without table data to work with, I have no testing capacity, but I want to know what you get when you do something like this:

select cr.sup, cr.part, cr.loc, cr.countrank, cr.days,

NTILE(cr.days)...