OK, well, one thing I overlooked is that I created my SQL Server Agent job in SQL Server 2012, but the above problems are presenting in the Configuration Manager next...

Final solution that worked and site that helped me realize this http://www.skylinetechnologies.com/Blog/Article/1309/Querying-Active-Directory-through-SQL-Server-Using-OpenRowset-and-OpenQuery.aspx

declare @name nvarchar(100)

declare @sql nvarchar(max)

set @name = 'Sanjay'

set @sql=

'SELECT * FROM OPENQUERY (

ADSI,

''SELECT givenname ,

...

getting close after reading this thread http://stackoverflow.com/questions/12184670/using-openquery-to-connection-to-active-directory

Query parses this time (no error message), but without results (just column headings), which I know are there.

declare @name nvarchar(100)

declare @sql nvarchar(max)

set @name...

yes, it's still not working. I really don't have a clue about how to solve.

Error is

Msg 102, Level 15, State 1, Line 5

Incorrect syntax near 'SELECT * FROM OPENQUERY (

ADSI,

'SELECT...

OK, you're right about SQL Server not running. It's also stopped and I can't get it to start, either.

I click start, a progress bar shows a lot of...

I think you are right. And in my case the AD must be limited to 901.

OK. Thanks.

the query that errored only returned 901 rows, so I don't think it's that...unless MaxPageSize is limited to 901 on our AD. You really think so?

Thank you. By combining ISNULL and NULLIF functions it's the most elegant handling of the true NULL and text NULL scenario I've seen. Few months back I was doing it...

i'm partial to parulprabu showing me how to make query 2 work using this join.

join location_history loch on loch.date_assigned = lh.Last_Date_Assigned and loch.iphone_id=lh.iphone_id.

really appreciate.

Thanks to you both for...

i supplied ddl. Can you show? I don't understand, otherwise, what you're getting at.

personally, don't understand why the group by in QUERY 1 isn't working.

OK, I found an entirely different approach to a problem at hand, which eliminates need to compare variable with string.

I appreciate it (as always/over the top!)

sorry, did that. I showed that in second example, but forgot to edit in the first.

ok it was char(13). OK, thanks so much to both of you. Two replaces resolves the leading white spaces.

cha cha cha! You see I wouldn't have lasted to 160 if I'd started with char(0), char(1), char(2). I would have given up long before 160 thinking it...

I tried to see if converting to binary would expose a character type, but the beginning of binary out looks same in both cases.

DECLARE @REALNAME varchar(255)

SET @REALNAME = 'Ricki Ricardo'---leading...