Hi

thanks, i was referred to a pretty cool tool, sql developer, and then inside of sql developer

go to Tools

Migration, select translation scratch editor,

this allowed me to convert from sql to...

thank you

Thank you

thanks, i had to click a property on the actual ODBC driver set up and that took care of the issue

Thank you so much that was right on the money.

thank you. i will try to write in modern times in the future when posting.

thanks that works

the following code snippet worked:

Search Case

select

case

when len([Closing Memo Date]) = 0 THEN null

...

i have tried a direct cast

select cast([Closing Memo Date] as datetime)

from OpenQuery(psclaims_linked,'Select * from [Sheet1$]');

and i get the same error:

Server: Msg 241, Level 16, State 1,...

hi

i get the following:

Syntax error converting datetime from character string.

ok, sorry about that.

i removed the rpc and rpc out and everything appears to be working now.

any idea, why it did not like me setting the rpc

i ran the following:

dbcc traceon(3604,7300)

go

EXEC daps_linked.master.dbo.sp_help 'a1_pipe_snapshot'

go

i get

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider...

Hi

I ran it,

now i can see my tables in any of the link servers

and when i run any query against the link servers they just kind of hang.

I went into...