Viewing 15 posts - 1 through 15 (of 28 total)
so, I got the xml file
BUT... I can't import it because the LongDescription has thousands of characters each
so I was wondering if I was able to import everything BUT DescriptonLong
June 24, 2014 at 1:43 am
<ProductsResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Webservices.ServiceModel.Operations">
<Products xmlns:d2p1="http://schemas.datacontract.org/2004/07/Webservices.ServiceModel.Types">
<d2p1:Product>
<d2p1:Attributes i:nil="true"/>
<d2p1:Autorisation>AA99</d2p1:Autorisation>
<d2p1:Bike>false</d2p1:Bike>
<d2p1:Blocked>false</d2p1:Blocked>
<d2p1:DateCreated>2007-12-27T00:00:00</d2p1:DateCreated>
<d2p1:DeliveredPer>1.000</d2p1:DeliveredPer>
<d2p1:Description>Tacx stuurinrichting VR</d2p1:Description>
<d2p1:DescriptionLong>
Tacx Virtual Reality stuurframe , Wordt standaard geleverd bij de Fortius Multiplayer en is als optie leverbaar bij de andere twee VR trainers....
June 19, 2014 at 7:42 am
well,
I fixed the problem
though I do not know why it got fixed...
what I did:
I changed ever A to SP and every SP to A (Turned around the script so it'd...
June 11, 2014 at 7:59 am
yes, but what can I do with this information?
June 11, 2014 at 5:47 am
so according to what you are saying, the problem in my script is the float point
I've tried to run my script without any float's (Just the description, which is nvarchar)...
June 11, 2014 at 4:48 am
-Artikelen -Verkoopprijs
Length: 8
Numeric Precision: 53
-SparePartsUpdate -Verkoopprijs
Length: ...
June 11, 2014 at 3:56 am
USE [Hofstede]
GO
/****** Object: Table [dbo].[sparepartsupdate] Script Date: 11-6-2014 11:22:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sparepartsupdate](
[id] [int] IDENTITY(1,1) NOT NULL,
[PartNrFabrikant] [nvarchar](35) NULL,
[omschrijving] [nvarchar](50) NULL,
[groep]...
June 11, 2014 at 3:23 am
I see...
but is that my problem?
and if it is, how may I fix it?
June 11, 2014 at 3:09 am
a.price sp.price
11,53 11,53
5,7 5,7
1,67 1,67
100,57 ...
June 11, 2014 at 2:49 am
there are loads of differences, about 1000 of the 2054 have differences in the price
June 11, 2014 at 2:44 am
what should I check?;p
June 11, 2014 at 2:36 am
It returns the 2054 rows that it is going to change...
...which never happens for some reason
I really just don't get it anymore;p
brains can't handle.
June 11, 2014 at 2:24 am
they are the same in both tables
June 11, 2014 at 2:17 am
Viewing 15 posts - 1 through 15 (of 28 total)