Convert SQL to FetchXML for SSRS
$10-25 USD
Paid on delivery
I have 4 queries that need to be converted to FetchXML.
Please ONLY apply to this job if you know FetchXML well enough to complete the task.
Please note that some of the queries may or may not be able to be converted to FetchXML, and in that case I need you to be able to figure out a way to do it in SSRS.
I will be using all of the FetchXML queries that you convert in SSRS.
The queries are:
SELECT isfiscalperiodmonthbased,
fiscalcalendarstart,
fiscalperiodformat,
fiscalperiodsperyear = CASE fiscalperiodtype
WHEN 2000 THEN 1
WHEN 2001 THEN 2
WHEN 2002 THEN 4
WHEN 2003 THEN 12
WHEN 2004 THEN 13
END,
fiscalyeardisplaycode,
fiscalyearformat,
fiscalyearperiodconnect
FROM filteredorganization
------------------------------------------
SELECT [login to view URL] AS 'fullname',
[login to view URL] AS 'calendartype',
[login to view URL] AS 'uilanguageid'
FROM filteredsystemuser AS systemuser
INNER JOIN filteredusersettings AS usersettings
ON [login to view URL] = [login to view URL]
WHERE [login to view URL] = dbo.Fn_finduserguid()
------------------------------------------------
SELECT dateformat,
dateformat + ' ' + timeformat AS DateTimeFormat,
numberlanguagecode,
calendartype,
numberformat_0_precision,
numberformat_1_precision,
numberformat_2_precision,
numberformat_3_precision,
numberformat_4_precision,
numberformat_5_precision,
currencyformat_0_precision,
currencyformat_1_precision,
currencyformat_2_precision,
currencyformat_3_precision,
currencyformat_4_precision,
currencyformat_5_precision
FROM dbo.Fn_getformatstrings()
-----------------------------------------------
DECLARE @SQL NVARCHAR(max)
SET @SQL =
'select [login to view URL] as ''stepname'', [login to view URL] as ''name'', opportunity0.crm_moneyformatstring as ''crm_moneyformatstring'', opportunity0.estimatedvalue_base as ''estimatedvalue_base'', [login to view URL] as ''owneridname'', [login to view URL] as ''ownerid'', [login to view URL] as ''customeridname'', [login to view URL] as ''customerid'', [login to view URL] as ''estimatedclosedate'', [login to view URL] as ''opportunityid'', opportunity0.mssp_licenserevenuetotal_base as ''LicenseRevenue'', opportunity0.mssp_maintenancerevenuetotal_base as ''MaintenanceRevenue'', opportunity0.mssp_servicesrevenuetotal_base as ''ServicesRevenue'', opportunity0.mssp_managedservicesrevenuetotal_base as ''ManagedServicesRevenue'', opportunity0.gbs_nextsteps as ''NextStep'' from ('
+ @CRM_FilteredOpportunity
+ ') as opportunity0'
EXEC(@SQL)
-------
Please note that no milestones will be releases until you provide the work ( this is the site's policy).
Project ID: #6954781
About the project
6 freelancers are bidding on average $58 for this job
I'd love to discuss your project in more detail to see how and if I can be of service. I can assure you of perfection in my work and the work will be of high accuracy. Please provide more information about the project. More
Hello! Interested in your offer, I can get to work immediately. I will be glad to cooperate. Best regards