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?

Great question Hugo.

Put me in the camp of answering too quickly. I guess I didn't consider adding a clustered index on another column. DOH!!! I read the section on...

isuckatsql (6/12/2012)

---

I used a Temp Table, but it made the query a lot slower!

I also used the loop joins and nolock because they improved performance.

By combining CTE, loops joins and...

You are welcome. Did you also read the string splitter article? That splitter will blow the doors off just about anything for performance. It should be in everyone's arsenal of...

You need to either a bunch of response.writes with response.end or send error messages to the browser.