There are also a few people who didn't consider the possibility of unique constraints being defined in the same CREATE TABLE statement, for instance because they have the habit of...

At this point it seems the two of you are putting in far more effort on this than the OP. 😉

http://www.aicas.com/jamaica/3.4/doc/jamaica_api/java/net/NoRouteToHostException.html

Googled here

This is almost certainly a network issue. Can you ping the sql box from your app box?

Open a command prompt

ping [servername]

That is one of two things. Either you can't see the sql server on the network (Can you ping it?) or the server does not allow remote connections. To check...

Or if your dates are not always in sequence you could do something like this.

;with cte as

(

select *, ROW_NUMBER() over(partition by ID order by ModifiedDate desc) as RowNum from @test-2

)

select...

TrippBlunschi (6/14/2012)

---

Sean Lange (6/14/2012)

---

There are a few ways to do this. Here is one of them.

select * from

(

select *, ROW_NUMBER() over(partition by ID order by ModifiedDate desc) as RowNum from...

If you google that error it seems the issues is much like what the description says, the application server is unable to communicate with sql. Given that your app has...

You are quite welcome. Fell free to post back if you have problems getting it implemented.

Or maybe it is just that the tools for it are horrible. The last time I worked with Oracle their query and admin tools were written in java and were...

Sounds like you maybe some network issues at that point or something. Glad to hear it is working now.

There are a few ways to do this. Here is one of them.

select * from

(

select *, ROW_NUMBER() over(partition by ID order by ModifiedDate desc) as RowNum from @test-2

) x

where RowNum...

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns [/url]

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs [/url]

Take a look at the article in my signature about splitting strings. The version Jeff wrote will blow the doors of the while loop style splitter. The article goes in...

That sounds like your application machine can't see the sql server. Can you ping the sql box from your app box and are the sql ports open in your firewall?