Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #178

Re: Use External value and use it from some views

Show all headers | View raw

omtechguy (omtechguy@gmail.com) writes:
> On 2 ???, 10:55, Erland Sommarskog <esq...@sommarskog.se> wrote:
>> omtechguy (omtech...@gmail.com) writes:
>> Are these the actual queries, or are they just sketches of the real
>> views?
>>
>> If they are the real McCoy is there an index on TheValue? Is that a
>> clustered or a non-clustered index?
>>
>> With a hardcoded value, the optimizer has more exact information than
>> if you have something variable.
>>
>> I would try an inline-table function, and then use OPTION(RECOMPILE)
>> when I query the function.
> 
> Can you please share an example?

CREATE FUNCTION myfunc(@myglobbval int) RETURNS TABLE AS
RETURN (SELECT * FROM MyTable where TheValue = @myglobval)
go
SELECT @myglobvalue = myglobalvalue 
FROM   MySettingTable
SELECT * FROM myfunc(@myglobval)
OPTION (RECOMPILE)
 

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Re: Use External value and use it from some views omtechguy <omtechguy@gmail.com> - 2011-04-12 23:15 -0700
  Re: Use External value and use it from some views Erland Sommarskog <esquel@sommarskog.se> - 2011-04-13 23:54 +0200

csiph-web