Example of using fn_GetSFDate

Example for fn_GetSFDate.sql

declare @soql nvarchar(1024), @sql nvarchar(1024)
-- This is s SOQL statement with SQL datetime, it will return all user 
-- records created today.
-- We use it for illustration purposes only, also demonstrating a technique
-- for providing dynamic arguments for OPENQUERY() parameter. 
select @soql = 'select * from user where createddate > ' 
               + dbo.fn_GetSFDate(GETDATE())

-- We need to wrap it into another string, as openquery cannot be called 
-- with parameters
select @sql = 'select * 
from openquery(SALESFORCE, ''' + @soql + ''')'

-- Let's see the final statement
print @sql

-- and execute it against our SFDC isntance
exec sp_sqlexec @sql