So you sent yourself an email? The website for this app is literally in your bio. By all means...

Here's a resource with some answers

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/199769c2-25c1-4077-9e64-bd95a16c8535/ssrs-get-current-logged-in-user-to-be-used-as-parameter?forum=sqlreportingservices

Essentially though the User!UserID property is what you need to get you started. You can just pass whatever you need from that into the...

You have a couple of syntax errors regarding extra commas/strings etc.. Try the following...

F OBJECT_ID('tempdb..#TempData')IS NOT NULL
DROP TABLE #TempData
;WITH CTE(SrNo , InvoiceDate , InvoiceNo , PayerName ,...

• This reply was modified 3 years ago by  PB_BI.
• This reply was modified 3 years ago by  PB_BI.

These might help

https://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/connect-sqlserver.htm

https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/sql-access-to-geodatabase-data.htm

GROUP BY/COUNT DISTINCT ignores NULL in a column, so you probably have NULLs in your UniqueClaimID column.

Try this

SELECT COUNT (DISTINCT ISNULL([UniqueClaimID], '0')) AS UniqueClaimID, ProvOrgNm AS ProvOrgNm
FROM...

From the download site:

Microsoft SQL Server 2012 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP3. This service pack contains up...

You need to specify your encoding, at the moment you are encoding using $Null. So change this:

# Create the XML file.
$xmlWriter = New-Object System.XMl.XmlTextWriter($fullFilePath,$Null)

To this:

This reply was modified 3 years, 1 month ago by  PB_BI.