How do I test a Table-Valued Function in SQL Server Management Studio?

You want to use FROM E. G : select ... FROM fn_GetConfigurationByProfile('DEFAULTPROFILE') SQL Server User-defined Functions.

Thanks for the timely response. I feel like a total noob to not have though of this since it was a table-valued function :/ – Jeff Oct 15 '09 at 12:41 read the like that I given. Hope that will help you more :) – anishMarokey Oct 15 '09 at 12:43.

Try this SELECT * FROM dbo. Fn_GetConfigurationByProfile('DEFAULTPROFILE').

You use it in the FROM clause, eg : SELECT .... FROM dbo. Fn_GetConfigurationByProfile('DEFAULTPROFILE') You can also join it to tables or use a where clause against it, among other things.

Others have shown how you can call your Table function within a standard query. However, can I suggest that you may prefer to create a View rather than a function? CREATE VIEW dbo.

ConfigurationView AS SELECT system_settings_profiles. Ssp_name, system_settings_groups. Ssg_id, system_settings_groups.

Ssg_name, system_settings_groups. Ssg_parent_group_id, system_settings_names. Ssn_name, system_Settings_names.

Ssn_display_name, system_settings_values. Ssv_value FROM system_settings_profiles JOIN system_settings_values ON system_settings_profiles. Ssp_id = system_settings_values.

Ssv_ssp_id JOIN system_settings_names ON system_settings_names. Ssn_id = system_settings_values. Ssv_ssn_id JOIN system_settings_groups ON system_settings_groups.

Ssg_id = system_settings_names. Ssn_ssg_id GO Then you can use it in your SQL like this. SELECT * FROM ConfigurationView WHERE ConfigurationView.

Ssp_name = 'DEFAULTPROFILE' You will have the added options of indexing the view and also filtering on other data easily should you require it.

Thanks, I'll check this out. – Jeff Oct 15 '09 at 13:22.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.