I gang

Help with XML query MS SQL server database

I want to query an SQL database using a Stored Procedure using xml.

I already have the SP set up using standard datatypes such as int and varchar, this part oif the Query is working well.

But I want to add a whole list of extra possible values in xml format to the Query and match them to the query using some sort of xml table.

@xmlCustomFieldValueList nvarchar(4000) = null,

/*if this is not null then*/

IF (@xmlCustomFieldValueList IS NOT NULL)

BEGIN

SET @Query = @Query + '

INNER JOIN

CustomFieldInstanceValue AS cfiv ON

[url removed, login to view] = [url removed, login to view]

'

END

I can get my c#.net to send the required information in a xml format something like this:

<?xml version="1.0" encoding="UTF-16"?>

<customfields>

<customfield>

<customfieldgroupid>1</customfieldgroupid>

<optionlookupgroupid>1</optionlookupgroupid>

</customfield>

<customfield>

<customfieldgroupid>1</customfieldgroupid>

<optionlookupgroupid>2</optionlookupgroupid>

</customfield>

<customfield>

<customfieldgroupid>2</customfieldgroupid>

<optionlookupgroupid>11</optionlookupgroupid>

</customfield>

<customfield>

<customfieldgroupid>2</customfieldgroupid>

<optionlookupgroupid>14</optionlookupgroupid>

</customfield>

<customfield>

<customfieldgroupid>3</customfieldgroupid>

<optionlookupgroupid>17</optionlookupgroupid>

</customfield>

</customfields>

So basically I just need help with the SQL side

Færdigheder: .NET, SQL

Se mere: sql query to get list of database, n query, need sql help, sql server xml query null, xml to my sql, sql, send query, query table, null, int, get sql help, sql query format, xml help, sql required, xml database procedure, xml quot, net server using, help using, net help, stored procedure list, standard procedure, help set, query query, sort table, server sql

Om arbejdsgiveren:
( 17 bedømmelser ) ALICANTE, United Kingdom

Projekt-ID: #604744

Tildelt til:

avijitgorai

check my pm

$30 USD in 2 dage
(0 bedømmelser)
0.0

12 freelancers are bidding on average $173 for this job

AlosDeveloper

Hello, please see PMB

$75 USD in 0 dage
(56 bedømmelser)
6.8
garex

Hi. Please provide additional details to all posters: CREATE scripts of table and SP, example SQL, that is generated by your program. Thanks.

$999 USD in 99 dage
(11 bedømmelser)
6.5
phil999

please check pm

$128 USD in 4 dage
(26 bedømmelser)
6.0
mishazh

Please check your inbox. We've sent you PM.

$100 USD in 2 dage
(7 bedømmelser)
4.4
friman78

Dear gentlemen, I can do this work, I am ready, thank you.

$150 USD in 5 dage
(6 bedømmelser)
4.2
ProfSandokan

Hello, I can do it. Check PM. Thanks.

$200 USD in 10 dage
(0 bedømmelser)
0.0
akovalev

i have large experience in extract data from xml in sp and store it into database tables. i can did this work quickly.

$100 USD på 1 dag
(0 bedømmelser)
0.0
mpegueroc

I can do that. Contact me i will help you

$50 USD på 1 dag
(0 bedømmelser)
0.0
gavrilyuk

Contact me when need help

$40 USD på 1 dag
(0 bedømmelser)
0.0
spartiategroup

We have a good experience in working with XML + SQL.

$120 USD in 6 dage
(0 bedømmelser)
0.0
maurezen

Greetings, my good man. Please, check PM. Thanks.

$80 USD in 2 dage
(0 bedømmelser)
3.1