Thursday, 4 July 2019

SQL Check Query Return Results

DECLARE @query nvarchar(MAX); SET query = N'SELECT * FROM Table WHERE id=_id' EXEC sp_executesql @queryToPass IF ( @@ROWCOUNT > 0) BEGIN -- action END

No comments:

Analysis Service in Power BI Report Server

 We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly... link