Convert SQL to FetchXML for SSRS

Closed Posted Jan 8, 2015 Paid on delivery
Closed 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).

CRM Microsoft SQL Server MySQL Software Architecture SQL

Project ID: #6954781

About the project

6 proposals Remote project Active Feb 14, 2015

6 freelancers are bidding on average $58 for this job

yubor

A proposal has not yet been provided

$45 USD in 3 days
(36 Reviews)
4.5
senpaiit

A proposal has not yet been provided

$22 USD in 1 day
(19 Reviews)
4.2
thegrchet

I've worked with Dynamics CRM 2011 till Dyanamic CRM 2015. I'm completely aware of the issue you're facing and it can be fixed. I've also used SSIS to retrieve CRM data to create a local CRM data source every day. H More

$50 USD in 1 day
(8 Reviews)
4.3
myaug

A proposal has not yet been provided

$61 USD in 1 day
(3 Reviews)
3.6
ashuagrawal

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

$35 USD in 3 days
(8 Reviews)
3.5
JJGroup

Hello! Interested in your offer, I can get to work immediately. I will be glad to cooperate. Best regards

$133 USD in 5 days
(1 Review)
0.0