March 7, 2016 at 3:47 am
Hello,
I have a real weird xml that I need to put in a table in columns.
The problem is that the xml itself repeats itself over and over again.
so when i write the code to parse it it keeps going to the first part
x.value('(clear-fraud/clear-fraud-stabilities/clear-fraud-stability/name[1]/text())[1]',
how do i tell it to make the columns in the order of the xml?
here is the xml code
<xml-response>
<clear-fraud>
<clear-fraud-stabilities>
<clear-fraud-stability>
<name>drivers_license</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>bank_account</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>home_address</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>zip_code</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>home_phone</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>cell_phone</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>2</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>work_phone</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>2</ninety-days-ago>
<threesixtyfive-days-ago>3</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>monthly_income</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>3</thirty-days-ago>
<ninety-days-ago>3</ninety-days-ago>
<threesixtyfive-days-ago>5</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>email_address</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
</clear-fraud-stabilities>
</clear-fraud>
</xml-response>
thanks
astrid 🙂
March 7, 2016 at 4:07 am
Quick suggestion, use the .nodes function
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @TXML XML = '<xml-response>
<clear-fraud>
<clear-fraud-stabilities>
<clear-fraud-stability>
<name>drivers_license</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>bank_account</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>home_address</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>zip_code</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>home_phone</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>cell_phone</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>2</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>work_phone</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>2</ninety-days-ago>
<threesixtyfive-days-ago>3</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>monthly_income</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>3</thirty-days-ago>
<ninety-days-ago>3</ninety-days-ago>
<threesixtyfive-days-ago>5</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>email_address</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
</clear-fraud-stabilities>
</clear-fraud>
</xml-response>';
SELECT
CFS.DATA.value('(name/text())[1]','varchar(100)') AS [clear-fraud-stability]
FROM @TXML.nodes('xml-response/clear-fraud/clear-fraud-stabilities/clear-fraud-stability') AS CFS(DATA);
Output
clear-fraud-stability
----------------------
drivers_license
bank_account
home_address
zip_code
home_phone
cell_phone
work_phone
monthly_income
email_address
March 7, 2016 at 4:27 am
Thanks, but that is not what i need.
I need to make a table with columns that contain the values of each one.
and the source is a table that each row contain an xml, i just posted a sample of part of the xml (the one who is having personality issues :w00t:)
March 7, 2016 at 5:31 am
astrid 69000 (3/7/2016)
Thanks, but that is not what i need.I need to make a table with columns that contain the values of each one.
and the source is a table that each row contain an xml, i just posted a sample of part of the xml (the one who is having personality issues :w00t:)
Suggest you post your full and complete requirements, I'm good at SQL but no good at guessing;-)
😎
March 7, 2016 at 5:54 am
I have a table with rows that contain an xml.
I take that table and create a new table with columns containing the data of the xml.
most of the xml is no problem
that part it is cause it repeats itself :doze:
March 7, 2016 at 11:20 am
It would help tremendously if you posted your whole query instead of just the one part. That being said, it sounds like you are using an absolute path instead of a relative path, or you are using a relative path from too high in the document tree.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
March 7, 2016 at 10:59 pm
I know what the problem is now, I am supposed to get a full path and somehow I am not getting it even though they say is being sent.
thanks again for all your help!
March 8, 2016 at 12:39 am
astrid 69000 (3/7/2016)
I know what the problem is now, I am supposed to get a full path and somehow I am not getting it even though they say is being sent.thanks again for all your help!
Didn't you understand the suggestion I posted earlier on this thread?
😎
USE tempdb;
GO
SET NOCOUNT ON;
-- BEGINNING OF SAMPLE SCHEMA AND DATA
IF OBJECT_ID(N'dbo.TBL_CLEAR_FRAUD') IS NULL
BEGIN
CREATE TABLE dbo.TBL_CLEAR_FRAUD
(
CF_ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_DBO_TBL_CLEAR_FRAUD_CF_ID PRIMARY KEY CLUSTERED
,CF_XML XML NOT NULL
);
END
IF OBJECT_ID(N'dbo.TBL_CLEAR_FRAUD_STABILITY') IS NULL
BEGIN
CREATE TABLE dbo.TBL_CLEAR_FRAUD_STABILITY
(
CFS_ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_DBO_TBL_CLEAR_FRAUD_STABILITY_CFS_ID PRIMARY KEY CLUSTERED
,CF_ID INT NOT NULL CONSTRAINT FK_DBO_TBL_CLEAR_FRAUD_STABILITY_CF_ID FOREIGN KEY REFERENCES dbo.TBL_CLEAR_FRAUD (CF_ID)
,[name] VARCHAR(100) NOT NULL
,[one-minute-ago] INT NOT NULL
,[ten-minutes-ago] INT NOT NULL
,[one-hour-ago] INT NOT NULL
,[twentyfour-hours-ago] INT NOT NULL
,[seven-days-ago] INT NOT NULL
,[fifteen-days-ago] INT NOT NULL
,[thirty-days-ago] INT NOT NULL
,[ninety-days-ago] INT NOT NULL
,[threesixtyfive-days-ago] INT NOT NULL
);
END
DECLARE @TXML XML = '<xml-response>
<clear-fraud>
<clear-fraud-stabilities>
<clear-fraud-stability>
<name>drivers_license</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>bank_account</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>home_address</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>zip_code</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>home_phone</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>cell_phone</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>2</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>work_phone</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>2</ninety-days-ago>
<threesixtyfive-days-ago>3</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>monthly_income</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>3</thirty-days-ago>
<ninety-days-ago>3</ninety-days-ago>
<threesixtyfive-days-ago>5</threesixtyfive-days-ago>
</clear-fraud-stability>
<clear-fraud-stability>
<name>email_address</name>
<one-minute-ago>1</one-minute-ago>
<ten-minutes-ago>1</ten-minutes-ago>
<one-hour-ago>1</one-hour-ago>
<twentyfour-hours-ago>1</twentyfour-hours-ago>
<seven-days-ago>1</seven-days-ago>
<fifteen-days-ago>1</fifteen-days-ago>
<thirty-days-ago>1</thirty-days-ago>
<ninety-days-ago>1</ninety-days-ago>
<threesixtyfive-days-ago>1</threesixtyfive-days-ago>
</clear-fraud-stability>
</clear-fraud-stabilities>
</clear-fraud>
</xml-response>';
INSERT INTO dbo.TBL_CLEAR_FRAUD (CF_XML)
SELECT @TXML UNION ALL
SELECT @TXML UNION ALL
SELECT @TXML UNION ALL
SELECT @TXML UNION ALL
SELECT @TXML UNION ALL
SELECT @TXML
;
-- END OF SAMPLE SCHEMA AND DATA
INSERT INTO dbo.TBL_CLEAR_FRAUD_STABILITY
(
CF_ID
,[name]
,[one-minute-ago]
,[ten-minutes-ago]
,[one-hour-ago]
,[twentyfour-hours-ago]
,[seven-days-ago]
,[fifteen-days-ago]
,[thirty-days-ago]
,[ninety-days-ago]
,[threesixtyfive-days-ago]
)
SELECT
CF.CF_ID AS CF_ID
,CFS.DATA.value('(name/text())[1]' ,'VARCHAR(100)' ) AS [name]
,CFS.DATA.value('(one-minute-ago/text())[1]' ,'INT' ) AS [one-minute-ago]
,CFS.DATA.value('(ten-minutes-ago/text())[1]' ,'INT' ) AS [ten-minutes-ago]
,CFS.DATA.value('(one-hour-ago/text())[1]' ,'INT' ) AS [one-hour-ago]
,CFS.DATA.value('(twentyfour-hours-ago/text())[1]' ,'INT' ) AS [twentyfour-hours-ago]
,CFS.DATA.value('(seven-days-ago/text())[1]' ,'INT' ) AS [seven-days-ago]
,CFS.DATA.value('(fifteen-days-ago/text())[1]' ,'INT' ) AS [fifteen-days-ago]
,CFS.DATA.value('(thirty-days-ago/text())[1]' ,'INT' ) AS [thirty-days-ago]
,CFS.DATA.value('(ninety-days-ago/text())[1]' ,'INT' ) AS [ninety-days-ago]
,CFS.DATA.value('(threesixtyfive-days-ago/text())[1]','INT' ) AS [threesixtyfive-days-ago]
FROM dbo.TBL_CLEAR_FRAUD CF
CROSS APPLY CF.CF_XML.nodes('xml-response/clear-fraud/clear-fraud-stabilities/clear-fraud-stability') AS CFS(DATA);
SELECT
CFS.CF_ID
,CFS.[name]
,CFS.[one-minute-ago]
,CFS.[ten-minutes-ago]
,CFS.[one-hour-ago]
,CFS.[twentyfour-hours-ago]
,CFS.[seven-days-ago]
,CFS.[fifteen-days-ago]
,CFS.[thirty-days-ago]
,CFS.[ninety-days-ago]
,CFS.[threesixtyfive-days-ago]
FROM TBL_CLEAR_FRAUD_STABILITY CFS;
Output
CF_ID name one-minute-ago ten-minutes-ago one-hour-ago twentyfour-hours-ago seven-days-ago fifteen-days-ago thirty-days-ago ninety-days-ago threesixtyfive-days-ago
----------- ------------------- -------------- --------------- ------------ -------------------- -------------- ---------------- --------------- --------------- -----------------------
1 drivers_license 1 1 1 1 1 1 1 1 1
1 bank_account 1 1 1 1 1 1 1 1 1
1 home_address 1 1 1 1 1 1 1 1 1
1 zip_code 1 1 1 1 1 1 1 1 1
1 home_phone 1 1 1 1 1 1 1 1 1
1 cell_phone 1 1 1 1 1 1 1 1 2
1 work_phone 1 1 1 1 1 1 1 2 3
1 monthly_income 1 1 1 1 1 1 3 3 5
1 email_address 1 1 1 1 1 1 1 1 1
2 drivers_license 1 1 1 1 1 1 1 1 1
2 bank_account 1 1 1 1 1 1 1 1 1
2 home_address 1 1 1 1 1 1 1 1 1
2 zip_code 1 1 1 1 1 1 1 1 1
2 home_phone 1 1 1 1 1 1 1 1 1
2 cell_phone 1 1 1 1 1 1 1 1 2
2 work_phone 1 1 1 1 1 1 1 2 3
2 monthly_income 1 1 1 1 1 1 3 3 5
2 email_address 1 1 1 1 1 1 1 1 1
3 drivers_license 1 1 1 1 1 1 1 1 1
3 bank_account 1 1 1 1 1 1 1 1 1
3 home_address 1 1 1 1 1 1 1 1 1
3 zip_code 1 1 1 1 1 1 1 1 1
3 home_phone 1 1 1 1 1 1 1 1 1
3 cell_phone 1 1 1 1 1 1 1 1 2
3 work_phone 1 1 1 1 1 1 1 2 3
3 monthly_income 1 1 1 1 1 1 3 3 5
3 email_address 1 1 1 1 1 1 1 1 1
4 drivers_license 1 1 1 1 1 1 1 1 1
4 bank_account 1 1 1 1 1 1 1 1 1
4 home_address 1 1 1 1 1 1 1 1 1
4 zip_code 1 1 1 1 1 1 1 1 1
4 home_phone 1 1 1 1 1 1 1 1 1
4 cell_phone 1 1 1 1 1 1 1 1 2
4 work_phone 1 1 1 1 1 1 1 2 3
4 monthly_income 1 1 1 1 1 1 3 3 5
4 email_address 1 1 1 1 1 1 1 1 1
5 drivers_license 1 1 1 1 1 1 1 1 1
5 bank_account 1 1 1 1 1 1 1 1 1
5 home_address 1 1 1 1 1 1 1 1 1
5 zip_code 1 1 1 1 1 1 1 1 1
5 home_phone 1 1 1 1 1 1 1 1 1
5 cell_phone 1 1 1 1 1 1 1 1 2
5 work_phone 1 1 1 1 1 1 1 2 3
5 monthly_income 1 1 1 1 1 1 3 3 5
5 email_address 1 1 1 1 1 1 1 1 1
6 drivers_license 1 1 1 1 1 1 1 1 1
6 bank_account 1 1 1 1 1 1 1 1 1
6 home_address 1 1 1 1 1 1 1 1 1
6 zip_code 1 1 1 1 1 1 1 1 1
6 home_phone 1 1 1 1 1 1 1 1 1
6 cell_phone 1 1 1 1 1 1 1 1 2
6 work_phone 1 1 1 1 1 1 1 2 3
6 monthly_income 1 1 1 1 1 1 3 3 5
6 email_address 1 1 1 1 1 1 1 1 1
1 drivers_license 1 1 1 1 1 1 1 1 1
1 bank_account 1 1 1 1 1 1 1 1 1
1 home_address 1 1 1 1 1 1 1 1 1
1 zip_code 1 1 1 1 1 1 1 1 1
1 home_phone 1 1 1 1 1 1 1 1 1
1 cell_phone 1 1 1 1 1 1 1 1 2
1 work_phone 1 1 1 1 1 1 1 2 3
1 monthly_income 1 1 1 1 1 1 3 3 5
1 email_address 1 1 1 1 1 1 1 1 1
2 drivers_license 1 1 1 1 1 1 1 1 1
2 bank_account 1 1 1 1 1 1 1 1 1
2 home_address 1 1 1 1 1 1 1 1 1
2 zip_code 1 1 1 1 1 1 1 1 1
2 home_phone 1 1 1 1 1 1 1 1 1
2 cell_phone 1 1 1 1 1 1 1 1 2
2 work_phone 1 1 1 1 1 1 1 2 3
2 monthly_income 1 1 1 1 1 1 3 3 5
2 email_address 1 1 1 1 1 1 1 1 1
3 drivers_license 1 1 1 1 1 1 1 1 1
3 bank_account 1 1 1 1 1 1 1 1 1
3 home_address 1 1 1 1 1 1 1 1 1
3 zip_code 1 1 1 1 1 1 1 1 1
3 home_phone 1 1 1 1 1 1 1 1 1
3 cell_phone 1 1 1 1 1 1 1 1 2
3 work_phone 1 1 1 1 1 1 1 2 3
3 monthly_income 1 1 1 1 1 1 3 3 5
3 email_address 1 1 1 1 1 1 1 1 1
4 drivers_license 1 1 1 1 1 1 1 1 1
4 bank_account 1 1 1 1 1 1 1 1 1
4 home_address 1 1 1 1 1 1 1 1 1
4 zip_code 1 1 1 1 1 1 1 1 1
4 home_phone 1 1 1 1 1 1 1 1 1
4 cell_phone 1 1 1 1 1 1 1 1 2
4 work_phone 1 1 1 1 1 1 1 2 3
4 monthly_income 1 1 1 1 1 1 3 3 5
4 email_address 1 1 1 1 1 1 1 1 1
5 drivers_license 1 1 1 1 1 1 1 1 1
5 bank_account 1 1 1 1 1 1 1 1 1
5 home_address 1 1 1 1 1 1 1 1 1
5 zip_code 1 1 1 1 1 1 1 1 1
5 home_phone 1 1 1 1 1 1 1 1 1
5 cell_phone 1 1 1 1 1 1 1 1 2
5 work_phone 1 1 1 1 1 1 1 2 3
5 monthly_income 1 1 1 1 1 1 3 3 5
5 email_address 1 1 1 1 1 1 1 1 1
6 drivers_license 1 1 1 1 1 1 1 1 1
6 bank_account 1 1 1 1 1 1 1 1 1
6 home_address 1 1 1 1 1 1 1 1 1
6 zip_code 1 1 1 1 1 1 1 1 1
6 home_phone 1 1 1 1 1 1 1 1 1
6 cell_phone 1 1 1 1 1 1 1 1 2
6 work_phone 1 1 1 1 1 1 1 2 3
6 monthly_income 1 1 1 1 1 1 3 3 5
6 email_address 1 1 1 1 1 1 1 1 1
7 drivers_license 1 1 1 1 1 1 1 1 1
7 bank_account 1 1 1 1 1 1 1 1 1
7 home_address 1 1 1 1 1 1 1 1 1
7 zip_code 1 1 1 1 1 1 1 1 1
7 home_phone 1 1 1 1 1 1 1 1 1
7 cell_phone 1 1 1 1 1 1 1 1 2
7 work_phone 1 1 1 1 1 1 1 2 3
7 monthly_income 1 1 1 1 1 1 3 3 5
7 email_address 1 1 1 1 1 1 1 1 1
8 drivers_license 1 1 1 1 1 1 1 1 1
8 bank_account 1 1 1 1 1 1 1 1 1
8 home_address 1 1 1 1 1 1 1 1 1
8 zip_code 1 1 1 1 1 1 1 1 1
8 home_phone 1 1 1 1 1 1 1 1 1
8 cell_phone 1 1 1 1 1 1 1 1 2
8 work_phone 1 1 1 1 1 1 1 2 3
8 monthly_income 1 1 1 1 1 1 3 3 5
8 email_address 1 1 1 1 1 1 1 1 1
9 drivers_license 1 1 1 1 1 1 1 1 1
9 bank_account 1 1 1 1 1 1 1 1 1
9 home_address 1 1 1 1 1 1 1 1 1
9 zip_code 1 1 1 1 1 1 1 1 1
9 home_phone 1 1 1 1 1 1 1 1 1
9 cell_phone 1 1 1 1 1 1 1 1 2
9 work_phone 1 1 1 1 1 1 1 2 3
9 monthly_income 1 1 1 1 1 1 3 3 5
9 email_address 1 1 1 1 1 1 1 1 1
10 drivers_license 1 1 1 1 1 1 1 1 1
10 bank_account 1 1 1 1 1 1 1 1 1
10 home_address 1 1 1 1 1 1 1 1 1
10 zip_code 1 1 1 1 1 1 1 1 1
10 home_phone 1 1 1 1 1 1 1 1 1
10 cell_phone 1 1 1 1 1 1 1 1 2
10 work_phone 1 1 1 1 1 1 1 2 3
10 monthly_income 1 1 1 1 1 1 3 3 5
10 email_address 1 1 1 1 1 1 1 1 1
11 drivers_license 1 1 1 1 1 1 1 1 1
11 bank_account 1 1 1 1 1 1 1 1 1
11 home_address 1 1 1 1 1 1 1 1 1
11 zip_code 1 1 1 1 1 1 1 1 1
11 home_phone 1 1 1 1 1 1 1 1 1
11 cell_phone 1 1 1 1 1 1 1 1 2
11 work_phone 1 1 1 1 1 1 1 2 3
11 monthly_income 1 1 1 1 1 1 3 3 5
11 email_address 1 1 1 1 1 1 1 1 1
12 drivers_license 1 1 1 1 1 1 1 1 1
12 bank_account 1 1 1 1 1 1 1 1 1
12 home_address 1 1 1 1 1 1 1 1 1
12 zip_code 1 1 1 1 1 1 1 1 1
12 home_phone 1 1 1 1 1 1 1 1 1
12 cell_phone 1 1 1 1 1 1 1 1 2
12 work_phone 1 1 1 1 1 1 1 2 3
12 monthly_income 1 1 1 1 1 1 3 3 5
12 email_address 1 1 1 1 1 1 1 1 1
March 8, 2016 at 1:00 am
ohhhhh :ermm: :ermm: :ermm:
no I didn't....
now I feel embarrassed :w00t:
thanks! I love learning new things 🙂
March 8, 2016 at 1:10 am
astrid 69000 (3/8/2016)
ohhhhh :ermm: :ermm: :ermm:no I didn't....
now I feel embarrassed :w00t:
thanks! I love learning new things 🙂
You are very welcome.
😎
April 14, 2016 at 7:53 am
Nice it is completed
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply