Is the Microsoft® SQL Server® 2008 Management Studio Express able to manage a 2005 database?

select datediff (day,enterdate,coalesce(leavedate,[date])) as 'totaldays'

from reservations

produces the error...

"Invalid column name 'date'."

Select (case when (leavedate is null)

then datediff (day,enterdate,[date])

else datediff (day,enterdate,leavedate) end as 'totaldays'

from reservations

produces

Incorrect syntax near the keyword...

Thanks.. your code worked great. However when I tried to adapt it to look at another field (included in the table building script below)to apply different criteria using...

I've added the needed output to original post.. thanks!

Running across a WAN in the same domain. Windows, Antivirus and other updates are not occuring at or near this time according to our WAN administrator

This sounded like a great plan, but when I tried installing it, I set it up .. click "RUN" and nothing happens...

P.S. .. I'm running it in a Terminal Sevice...

Thanks all.. I'll give it a try.

Thanks!

Me too, unfortunately, that's not an available option.

Thanks!

Well... when I run it today it does work properly, but I'm pretty confident that when I tested it after reading the post warning that it didn't work, that I...

If each rock in each pile has a sequence number on it .... would you not then know how to arrange each group, and once arranged which one is in...

I think perhaps a better explanation would be helpful ... each custlink can and does exist in multiple rows, each in turn has a field containing a unique sequence number....

As was initially requested (....I want to query the data shown below in the first dataset to return each entire row containing the nth lowest sequence number for each cuslink)...

That is a BIG IF!!! LOL. But... seriously, it needs to return the sequence number for each customer link within each custlink, without considering the custlink as part of...

Another user on this forum noted (and I verified) that this script does not work if I change value of @n to 3. The sequence of cuslink of 5432 is...