http://www.reactiongifs.com/wp-content/uploads/2011/05/popcorn_yes.gif

>Greg,
>
>How does your function sample relate to the question?
>
>>>>Hi
>>>>
>>>>If I have
>>>>
>>>>set @tablename = 'example_tablename'
>>>>
>>>>How do I select from that table
>>>>
>>>>ie select * from @tablename
>>>>
>>>>Thanks
>>>>
>>>>Nick
>>>
>>>I need to use dynamic SQL
>>>like
>>>declare @q varchar(1000)
>>>set @q = 'select * from ' + @tablename + ' where failure_reason is not NULL '
>>>exec (@q)
>>
>>Look at creating a table function:
>>
>>

>>SET ANSI_NULLS ON
>>GO
>>SET QUOTED_IDENTIFIER ON
>>GO
>>-- =============================================
>>-- Author:		<Author,,Name>
>>-- Create date: <Create Date,,>
>>-- Description:	<Description,,>
>>-- =============================================
>>CREATE FUNCTION Z_CHECK_ACROSS_ROLES_PK_SK
>>(
>>	-- Add the parameters for the function here
>>	@MDM_BUSINESS_PARTNER_ID int
>>)
>>RETURNS 
>>	TABLE 
>>AS
>>	RETURN (
>>		SELECT
>>			CAST(A11_TEXT_F600.TextField AS nvarchar(15)                       AS CATEGORY,
>>			CAST( CAST(A2i_1_251_BP_ROLES.SubId AS float) AS int)     AS BUSINESS_PARTNER_ROLE_MDMINTERNALID
>>
>>		FROM
>>			dbo.A2i_1 AS A2i_1_BPMain WITH (NOLOCK) 
>>
>>			LEFT OUTER JOIN -- Category Flat Table join to Business Partner Main Table
>>			dbo.A2i_11 AS A2i_11_F606 WITH (NOLOCK) ON A2i_1_BPMain.F606 = A2i_11_F606.Id  
>>
>>		WHERE
>>			CAST(CAST(A2i_1_BPMain.F48 AS float) AS int) = @MDM_BUSINESS_PARTNER_ID
>>	)
>>	
>>GO
>>