http://www.sqlservercentral.com/Forums/Topic1434840-23-1.aspx

Try the above.

see also...

http://www.sqlservercentral.com/Forums/Topic1434840-23-1.aspx

The first 18 rows including my db show E:\program files\Microsoft SQL Server\MSSQL_10_50.MSSQL...

Then the rest show this URL \\?\GLOBALROOT\Device... most of which is referring to my db.

I restored the db from...

Thanks John great tip!

I suspected the drive or path was not found but how to fix? my gut reaction is to change the URL to the drive letter that it...

Brilliant!! never thought to use PARTITION BY

Here's what it looks like ...

A big thank you for your time.

SELECT a.custno

, RTRIM(a.firstname) +...