May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
CREATE FUNCTION TEST_TABLE ( @RequestTypeID int ) RETURNS @MyTable TABLE ( SystemID int, DateOfSubmission datetime ) AS BEGIN declare @MySQL varchar(200) set @MySQL = 'select Application_ID, Date_of_Submission from (select Request_Table_Name dbo.Request_Type where Request_Type_ID='+@RequestTypeID+')' insert @MyTable EXEC sp_executesql @MySQL return END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to structure query with count aggregate||4||60|
|qry that pulls up counts and $ totals by certain interval per sales rep for quote & sale activity, part II||16||66|
|Change this SQL to get all nodes||3||54|
|Trying to understand why my Index is so large||12||48|
Join the community of 500,000 technology professionals and ask your questions.