Hi Again,

I've just added another server named "BP-SQL\BPSQLSERVER" and I'm having issues executng a query from the main server. Here is an example

SELECT p.PatientID, p.LastName, p.FirstName, '1' as ProgramId

FROM [BP-SQL\BPSQLSERVER].dbo.PATIENTS...

I have found a way around this issue, but it is NOT the best solution. Any functions on the linked server that needs to be called, I've had to duplicate...

Thanks for the replies. I've got the linked server working with stored procedures (SP) that don't contain a function in them. How can I execute a SP that contains a...

Hi Joe,

Thanks for the reply. I've decided not to go the UDF route. Based on the first reply I've implemented the Calendar table, its looking good so far. But today,...

Hi Kenneth,

Thank for the reply. I will take a look at the link you provided. Thanks again. Now for some MORE reading, lol.

Michael