troubleshooting Question

sql function

Avatar of aneilg
aneilgFlag for United Kingdom of Great Britain and Northern Ireland asked on
SSRSSQL
4 Comments1 Solution377 ViewsLast Modified:
i am trying to create the following sunction but i get an error, near the begin.


USE ReportServer

/****** Object:  StoredProcedure [ExecutionLogReport]    Script Date: 02/07/2012 11:14:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

CREATE FUNCTION [dbo].[rptListReportingDataSources]

(@DataSourceID uniqueidentifier)


BEGIN

SET NOCOUNT ON

SELECT    
      cast(null AS uniqueidentifier) AS DataSourceID
    , 'All' AS DataSourceName

UNION ALL

SELECT    
      ItemID
    , [Name]

FROM    
      ReportServer.dbo.Catalog dscat WITH (NOLOCK)
WHERE    
      [Type] = 5
return @DataSourceID

END

GO
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros