You could use SSIS for this.

If you have an OLE DB or ODBC provider for your non-SQL Server sources, it should be no problem.

Make sure you have up-to-date providers.

I don't think you can skip that many versions in one step.

You might need to upgrade to SQL 2005 first, and then to 2008R2.

edit: it seems Gail can type faster...

mister.magoo (10/10/2013)

---

ali.m.habib (10/10/2013)

---

I want to select top 1 value either null or value from this query

select top 1 column5 from table2 where table2.column1ID = 5

if the whole value of...

Take a look at Qlikview and Tableau.

I would go for option 2. More concise and less confusing.

Sean Lange (10/10/2013)

---

Here is another way without using the ROW_NUMBER window function.

select top 1 column5 from

(

SELECT [column5], 1 as SortOrder FROM [dbo].[table2] WHERE [column1ID] = 5

UNION

SELECT NULL, 2

)x order...

niklasrene (10/10/2013)

---

Hi, simple question:

Is it possible to connect to a SQL 2008 Db table with ms excel 2010, and edit the fields directly from excel?

Like the same way as...

You mean something like this:

SELECT * FROM

(SELECT * FROM myTable WHERE col = 'A') tmp;

Subquery Fundamentals

You can still alter any area as you please.

The wizard is just a shortcut to get you started.

Although, if you have for example chosen a table report in the wizard,...

Found a query that works:

WITH CTE_ResultSet AS

(

SELECT [column5] FROM [dbo].[table2] WHERE [column1ID] = 5

UNION

SELECT NULL

)

SELECT [column5] FROM

(SELECT [column5], ROW_NUMBER() OVER(ORDER BY [column5] DESC) AS RID FROM CTE_ResultSet) tmp

WHERE...

If the value of this column is null,...

Google for a tuturial on SQL Server functions and read it.

You are responsible for your data and before you let any update statement loose on it, you should understand what...

Guitar_player (10/10/2013)

---

Hi ,

I am Having a Column full of Capital Letter words like "ABC DEF GHI " , i want to convert that into "Abc Def Ghi"...

You can hide the databases if you really...

Just because he...