"instead of select" will be perfect =)

But SQL Server don't have this option.

Now i'm upgrading data every hour by SQL agent.

It's running SP, than caching views.

All be OK, but now...

Yes, i'm really need to stored it localy, becouse that data will be used by MSAS for example, or by reporting service.

But before this data can be used it must...

Simple webapp or VB script can save many time for you.

Without any coding you may create view (for different querys) and store excel connection

to this view. You can acces that...

Why you don't use Excel data import/export functionality ?

It's work fine with excel and SQL Server.

if you want sp_executesql with variables.

openquery do not allow any var's.

CREATE function [dbo].[create_SQL_string](@driver nvarchar(32), @sql nvarchar(max))

returns nvarchar(max)

with execute as caller

as begin

declare @out_sql nvarchar(max)

return 'select * from openquery('+@driver+', '''+REPLACE(@sql,'''','''''')+''')'

end

declare...