SQL Server 2008 :: Upload 1000 Text Files Into One Table - Skip Last Row?

Jul 19, 2015

Im trying to upload 1000 txt files into one table in SQL. I'm using the following query, to upload one txt file at a time:

bulk insert [dbo].AAA_2013_2015
from 'dataserverSQL Data FilesSQL_EMELIZFC x Bloque Detallada201308 Detalle FacturasFACT_BLOQ_AGO13 (4).txt'
with (firstrow = 2,
lastrow = ???,
fieldterminator = ';',
rowterminator = '0x0A')

I'm trying that the query skip the last row because gives me the following error:

Msg 4866, Level 16, State 1, Line 1
The bulk load failed. The column is too long in the data file for row 1, column 17. Verify that the field terminator and row terminator are specified correctly.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

know a command to skip the last row, something like lastrow= all-1...or something like that.

I also executed using MAXERRORS command...like this:

bulk insert [dbo].AAA_2013_2015
from 'dataserverSQL Data FilesSQL_EMELIZFC x Bloque Detallada201308 Detalle FacturasFACT_BLOQ_AGO13 (15).txt'
with (firstrow = 2,
fieldterminator = ';',
MAXERRORS = max_errors,
rowterminator = '0x0A')

does not recognize MAXERRORS command, also tried to put a number of error instead of max_errors.

View 0 Replies


ADVERTISEMENT

Upload Text Files Thru DTS/SSIS

Jan 31, 2007

I have created a DTS package which imports text file into single sql server table with 8 columns (SourceData). The DTS package uses 'Test1.txt' file. Now i have around 200 text files (Test1,Test2,.....Test200). I need to import them one by one into 'SourceData' table. Could you pls. help me out in getting solved.

Thanks,

Hemal

View 4 Replies View Related

SQL Server 2008 :: Skip Code If Certain Condition Not Met In Stored Procedure

Mar 18, 2015

I have a stored procedure with several insert into statements. On occasion one of the insert into queries doesn't return any data. What is the best way to test for no records then, skip that query?

View 5 Replies View Related

Upload Text File To A Table

Nov 1, 2007

I do have a comma separated text file.
"firstname","lastname","ssn","dob"
"firstname1","lastname1","ssn1","dob1"

The text file can have 50000 records. What is the best way to upload the file into a table. The table structure looks like:

Table1:
Fname varchar(50)
lname varchar(50)
ssn varchar(50)
dob varchar(50)

Any thoughts???

View 4 Replies View Related

SQL Server 2008 :: Query A Column Of XML Files In A Table

Apr 30, 2015

I want to query a column of xml files in a table,

use mysql1
declare @bp xml
select @bp=xml
;WITH XMLNAMESPACES('http://schemas.openehr.org/v1' as bp,'http://www.w3.org/2001/XMLSchema-instance' as xsi,'OBSERVATION' as type)
select * from (
select
m.c.value('(./bp:data/bp:items[1]/bp:value[1]/bp:magnitude)[1]','int') as systolisch
from
BloodpressureMitSchema cross apply
@bp.nodes('/bp:content/bp:data/bp:events') as m(c))m

But with this "cross apply" I can only query all the values in one xml and repeat them. Is there something wrong at "declear"

View 2 Replies View Related

[MSSQL] Blob-upload In Table With Full Text Index Goes Slow

Oct 31, 2005

i have a MSSQL 2000 database with about 30 tables in it. On one of those tables i've defined an full text index on an image field. In this table are around 500 records with binary files.

it functioned well for a time but now when i try to upload a file into the table this goes extremely slow (300 KB takes over 3 minutes).

i tried disabling "change tracking" but this didn't help a thing

adding blobs to other tables (without fulltext index on it) still goes fast.

what could be a reason that the uploading goes so slow??

View 3 Replies View Related

SQL Server 2008 :: Table And Column Name Where Given Text Is Matching

Jul 31, 2015

I need a script which will tell me Table name and column name where a given text is matching.

Example: search string = "I want to search something"

Output: Table T1 , Column C3.

DB: Microsoft SQL Server 2005 / 2008

View 1 Replies View Related

Browsing For Files (Images) To Upload To Server

Jun 9, 2007

 How do i Browser for files in computer, and upload them to Server? then link the file's URL(on server) into a Database.What i am wanting to do: Upload pictures (For products) for use in product pages What i think i need: Browse for images on local computerUpload the file to ServerStore the Image URL(relative to server) in DB

View 13 Replies View Related

DTS: Copying Data From Text Files To A SQL Server Table

Sep 10, 2001

Hi all,

I got a situation here.....

From a source table (in SERVER1) I get ids of candidates and from another source (in SERVER2) I get their CVs (text files stored in various Folders). My destination table (in SERVER3) has two fields, CandidateId & CandidateCV.

I have to transfer the data in above fashion for nearly 1 million records.
How can I write a DTS package which picks up the text file from SERVER2 based on the CandidateId which comes from SERVER1? Probably I need some kind of looping mechanism which changes the candidate id & his CV file.

Can anyone help???

Thanks...

View 2 Replies View Related

Exporting Databse Table Data In SQL Server 6.5 Into Text Files

Mar 11, 1999

Hi,

I have to export the table data from my databse into text files as I nedd to put it in Informix database using a sheel script. Is there a way by which I can do this.

Is there any other way by which I can put the data from SQL Server to Informix.

Any takers,

Thanking you in advance.

Bye for now,

Himauhu

View 1 Replies View Related

Can I Upload A Report From Reporting Services 2008 Into SQL Server 2005?

Jan 28, 2008

Would that be compatible or do I need SQL Server 2008 to display the report?

Thanks,
Steven

View 5 Replies View Related

SQL Server 2008 :: Concatenating Multiple Text Fields Into One Field In Another Table

Oct 7, 2015

SQL code for the following? (SQL Server 2008 R2 - SQL Server 2012).

I have Table1 Containing two fields with the below entries

VehicleType Name

Two Wheels Bicycle
Two Wheels Scooter
Two Wheels Motorcycle
Four Wheels Sedan
Four Wheels SUV
Four Wheels Pickup
Four Wheels Minivan

The result I'm looking for would be

Table2

Vehicle Type
Two Wheels Bicycle, Scooter, Motorcycle
Four Wheels Sedan, SUV, Pickup, Minivan

View 1 Replies View Related

DB Design :: Database XYZ Has More Than 1000 Virtual Log Files Which Is Excessive

Jun 8, 2015

I am getting this massage in error log .

"Database XYZ has more than 1000 virtual log files which is excessive. Too many virtual log files can cause long startup and backup times. Consider shrinking the log and using a different growth increment to reduce the number of virtual log files."

I am using  sql server 2008r2.

View 5 Replies View Related

Linked Server To Text Files: Is Possible To Detect Changes Made To Those Files? (SQL Server 2005)

Sep 3, 2007

Hi gurus,

I've created a linked server (and set up the corresponding schema.ini file) in order to perform bulk-inserts from some CSV text files into SQL tables (from my standpoint the text files are just for reading purposes). The linked server works fine (I can select the data in the files without a problem).

Now the question: is possible to automatically detect when one or more of those files change in order to start the import process automatically? Something like having a trigger created on the CSV files Or there's no easy way to do that so I have, to say something, to create a Job that periodically checks if the files have changed programatically (say, recording each file's timestamp everytime is imported and comparing the recorded value with the current one, or whatever)?


Thanks a lot in advance!

View 1 Replies View Related

SQL Server 2014 :: Query Causing Blocking / Locks Table For 1000 Seconds?

Feb 11, 2015

I have a sql snippet from a 3rd party application that will not complete its transaction. The SELECT statement executes but does not finish. Instead the statement just sits in AWAITING COMMAND for 1000 seconds then dies, thus killing the UPDATE statement that is supposed to follow.

The CROSS JOIN and CROSS APPLY seem suspect.

(
@p0 DATETIME,
@p1 INT,
@p2 INT,
@p3 NVARCHAR(4000),
@p4 INT,

[code]....

View 9 Replies View Related

Text Files To SQL Table ...

Mar 30, 2006

Hello!, I have two applications that import data from text files to Access 97 tables. One of this applications is in Access 97 and the other in VB6, know they are requesting me to import this text information to a SQL table. I do not have any experience with SQL Server, can some one give a idea of what I could do to accomplish this?, I would appreciate a lot anyone's help!, thanks! ...

View 4 Replies View Related

Transact SQL :: Importing Bulk Excel Files Into A Table In 2008?

Nov 2, 2015

I have around 100 XL Files in a folder ,i want to import all the files dynamically and load all the data in a single table in sql server 2008. Without using SSIS i want to query using openrowset.

View 11 Replies View Related

Deploying Web App, Which SQL Files Do I Upload?..

Nov 24, 2004

I'm working on a web application that uses SQL Server 2000. Once I'm ready to upload my website to a production server, I need to know how to upload my SQL Server database files to the server. Are there actual files that can be uploaded? I've only deployed a website that works with MySQL to a production server, and there were no files to upload... the database had to be created on the server, and then the data itself had to be exported to text files (on my computer), then imported/uploaded to the production server using SQL statements...

How do I do this?

Thanks~

View 2 Replies View Related

Bulk Upload Files

Jun 22, 2008

i have tried to move upload of files from SQL2000 to SQl2005.
in SQL2005 i have created a JOB in which has 2 steps,each one of them activates the same batch files i used in SQL2000 (where i have change the server name and so on),for example :

for %%f in ( %BULK_UPLOAD_BASE%Temp%1*.txt) do bcp "db1.dbo.Test_TargetTable" in %%f -S SERVER-REP -U n145 -h "TABLOCK" -e %BULK_UPLOAD_BASE%ErrorErr10.txt -o %BULK_UPLOAD_BASE%LogsOutput10.txt -P n145 -C RAW -f %BULK_UPLOAD_BASE%format_with_RawData_4test.fmt


when irun this code in a bat file, the data is loaded with no problem.
when i run the JOB i see in the LOG that everything was ok, but actually the data fromthe files was not loaded - any idea why?
thnaks in advance
peleg


Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

View 1 Replies View Related

Upload Files And Downloading A Pdf File

Mar 5, 2008

what data type am i going to put to my uploadedFiles column in my database... uploaded files are in document format or .txt
 also.. how can i make those files converted into pdf files.. also enable users to download it..
tnx!!!
forums.asp.net = "great help"

View 7 Replies View Related

How Can I Upload The Files(any Kinda) Onto The Database???

Apr 15, 2005

Hi everyone,
I am developing an web-database application using ASP.NET, C# and sql server 2000 .
In the application i want to upload different scanned files (pdf,doc,excel,jpeg,ttf,etc) onto the database.. how can i carry out this task :-?
If any one got the solution.. then, please let me know...
thanks in advance
 

View 7 Replies View Related

Upload Files To Image Column

Nov 6, 2006

Anyone have any luck using "Upload multiple files to SQL Server Image column"
www.databasejournal.com/features/mssql/article.php/3444771

View 3 Replies View Related

How Do I Automate Importing All Text Flat Files Into SQL 7 Table????

Jan 19, 2000

How do I automate importing "All Text Flat Files" into a SQL 7 table. The key is that there is no validation neccessary for the data and I do not want to manually import the data. I just to delimited the data and import it using either a script or a schedular of some type that can do it for me. Some Please Help

View 1 Replies View Related

Import Data From Two Text Files Into One Database Table

Feb 12, 2008

I am learning SQLServer Integration Services.

I created a file People.txt containing firstName, LastName seperated by a pipe.

------------------content-----------
John | Doe
Mike | James
Adam | Smith
-----------------------------------------

and another one called gender.txt

------------------content-----------
M
---------------------------------------

I will would like to create integration services package that compines each record of the first file with the record of the second file and inserts the result into table.

--------------Result table content------------------




John
Doe
M

Mike
James
M

Adam
Smith
M




-----------------------------------------------------------

Thanks




View 5 Replies View Related

Import Multiple Text Files Into Single Table

Jan 29, 2007

How to import multiple text files (residing in single folder) into SQL Server table? I know how to import single file but not sure how multiple files could be loaded? Pls. guide.



Thanks,

HShah

View 1 Replies View Related

Using FTP Connection Manager In SSIS To Upload Files

May 12, 2015

I am using FTP Connection manager in SSIS to upload files. Does it close session after it completes the task?

View 2 Replies View Related

T-SQL (SS2K8) :: Import To Table From Varying Tab Delimited Text Files

Feb 10, 2014

I need to import data to a MSSql table from massive (read: a million and a half rows, every single day) logs that come in .txt format separated in tabs with a ";" symbol and then have some stored procedures analyze that data to generate some reports in an excel file with that info. The text files include the column headers in the first row and the data starts on the second one.

The challenge is that the text files differ in column order and count every single day.

The analysis that I need to do only needs about 15 columns from the nearly 90-120 that those files include, and those columns sadly happen to be in a different order in those files.

View 8 Replies View Related

T-SQL (SS2K8) :: How To Write A Procedure To Upload XML Files Into Above Tables

Jul 15, 2014

There are two tables in my database HotelList_Temp, AsiaHotelChildrenAges_Temp

I need to write a procedure to upload the xml files into above tables .xmlfile is in my pc

xml to table column mapping are given below

<HOTEL>
<SEQNO>1</SEQNO>
<GRADE>5</GRADE> --StarRating
<PRODUCT>H</PRODUCT>
<CITYAREA>CKOWM</CITYAREA> --CityLocation
<CITY>HKG</CITY> --ResortCode
<CITYAREANAME>Mong Kok </CITYAREANAME> --ResortName

[code]....

View 9 Replies View Related

Dynamic Transformation To Upload Flat Files Into Database

Feb 6, 2007

Hi,

My scenario:

I have 4 different flat files types each having different no. of column, order of columns etc. I want to upload all the 4 types into the same destination table in the SQL database. Before uploading I need to apply transformation to each column in the flat files. The transformations could be like

1) Multipying the source column by 100

2) Put an if condition for 2 source columns and then select one column to be copied into the destination.

I have the flat files schema with me and also all the transformations that are required.

Question:

Can SSIS provide me with a component that can read the flat file schema and the transformations from the database and apply them to the source data and then upload it to the constant destination table? Can derived column transformation be provided with the input columns list and the transformation to be done on each dynamically?

Why I want this way?

In future there can be an addition of extra flat file formats and we want to keep the changes to the SSIS packages to he mininum. Just entereing the addiional schema and transformation details in the database should run the package on the new flat file successfully.

Thanks for your time.

Regards,

$wapnil

View 15 Replies View Related

Upload Images And Text To Database

Mar 22, 2008

 I have a form that inserts text and also allows the user to upload 3 images.  I have the text part working, but can't figure out how to get the images uploaded. Here is the form.  I just inserted the 3 upload controls in the form and in the datasource to show what I am trying to do.  If anybody can help me I appreciate it.   1 <h3><br />Add Listing</h3><hr />
2 <div style="margin:auto;">
3 <table align="center" >
4 <tr>
5 <td align="right">
6 Address:</td>
7 <td>
8 <asp:TextBox ID="TbAddress" runat="server" MaxLength="62" Width="250px"></asp:TextBox> </td>
9 </tr>
10 <tr>
11 <td align="right">
12 City:</td>
13 <td align="left">
14 <asp:TextBox ID="TbCity" runat="server" MaxLength="62" Width="250px"></asp:TextBox></td>
15 </tr>
16 <tr>
17 <td align="right">
18 State:</td>
19 <td align="left">
20 <asp:DropDownList ID="DdState" runat="server">
21 </asp:DropDownList>
22 </td>
23 </tr>
24 <tr>
25 <td align="right">
26 Zip Code:</td>
27 <td align="left">
28 <asp:TextBox ID="TbZipCode" MaxLength="15" Width="75px" runat="server"></asp:TextBox>
29 </td>
30 </tr>
31
32 <tr>
33 <td align="right">
34 Listing Price:</td>
35 <td align="left">
36 <asp:TextBox ID="TbListingPrice" runat="server" MaxLength="30" Width="125px"></asp:TextBox></td>
37 </tr>
38 <tr>
39 <td align="right">
40 Taxes/Half:</td>
41 <td align="left">
42 <asp:TextBox ID="TbTaxes" runat="server" MaxLength="30" Width="125px"></asp:TextBox></td>
43 </tr>
44 <tr>
45 <td align="right">
46 Subdivision:</td>
47 <td align="left">
48 <asp:TextBox ID="TbSubdivision" runat="server" MaxLength="60" Width="225px"></asp:TextBox></td>
49 </tr>
50 <tr>
51 <td align="right">
52 County:</td>
53 <td align="left">
54 <asp:TextBox ID="TbCounty" runat="server" MaxLength="60" Width="225px"></asp:TextBox></td>
55 </tr>
56 <tr>
57 <td align="right">
58 School District:</td>
59 <td align="left">
60 <asp:TextBox ID="TbSchoolDistrict" runat="server" MaxLength="60" Width="225px"></asp:TextBox></td>
61 </tr>
62 <tr>
63 <td align="right">
64 Bedrooms:</td>
65 <td align="left">
66 <asp:DropDownList ID="DdBedrooms" runat="server">
67 </asp:DropDownList>
68 </td>
69 </tr>
70 <tr>
71 <td align="right">
72 Bathrooms:</td>
73 <td align="left">
74 <asp:DropDownList ID="DdBathrooms" runat="server">
75 </asp:DropDownList>
76 </td>
77 </tr>
78 <tr>
79 <td align="right">
80 Living Space:</td>
81 <td align="left">
82 <asp:TextBox ID="TbLivingSpace" runat="server" MaxLength="30" Width="125px"></asp:TextBox></td>
83 </tr>
84 <tr>
85 <td align="right">
86 Stories:</td>
87 <td align="left">
88 <asp:DropDownList ID="DdStories" runat="server">
89 </asp:DropDownList>
90 </td>
91 </tr>
92 <tr>
93 <td align="right">
94 Building Style:</td>
95 <td align="left">
96 <asp:TextBox ID="TbBuildingStyle" runat="server" MaxLength="60" Width="225px"></asp:TextBox></td>
97 </tr>
98 <tr>
99 <td align="right">
100 Year Built:</td>
101 <td align="left">
102 <asp:TextBox ID="TbYearBuilt" runat="server" MaxLength="30" Width="125px"></asp:TextBox></td>
103 </tr>
104 <tr>
105 <td align="right">
106 Bastment:</td>
107 <td align="left">
108 <asp:DropDownList ID="DdBasement" runat="server">
109 </asp:DropDownList>
110 </td>
111 </tr>
112 <tr>
113 <td align="right">
114 Heating:</td>
115 <td align="left">
116 <asp:DropDownList ID="DdHeating" runat="server">
117 </asp:DropDownList>
118 </td>
119 </tr>
120 <tr>
121 <td align="right">
122 Cooling:</td>
123 <td align="left">
124 <asp:DropDownList ID="DdCooling" runat="server">
125 </asp:DropDownList>
126 </td>
127 </tr>
128 <tr>
129 <td align="right">
130 Image 1:</td>
131 <td align="left">
132
133 <asp:FileUpload ID="FileUpload1" runat="server" />
134 </td>
135 </tr>
136 <tr>
137 <td align="right">
138 Image 2:</td>
139 <td align="left">
140 <asp:FileUpload ID="FileUpload2" runat="server" />
141 </td>
142 </tr>
143 <tr>
144 <td align="right">
145 Image 3:</td>
146 <td align="left">
147 <asp:FileUpload ID="FileUpload3" runat="server" />
148 </td>
149 </tr>
150 <tr>
151 <td>
152 &nbsp;</td>
153 <td>
154 &nbsp;</td>
155 </tr>
156 <tr>
157 <td align="right">
158 <asp:Button ID="Button1" runat="server" Text="Save" />
159 </td>
160 <td>
161 &nbsp;</td>
162 </tr>
163
164
165 </table>
166
167 </div>
168
169
170 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:treesConnectionString %>"
171 InsertCommand="INSERT INTO SueHorvath(Address, City, State, ZipCode, ListPrice, Taxes, Subdivision, County, SchoolDistrict, Bedrooms, Bathrooms, LivingSpace, Stories, BuildingStyle, YearBuilt, Basement, Heating, Cooling, Image1, Image2, Image3) VALUES (@Address, @City, @State, @ZipCode, @ListPrice, @Taxes, @Subdivision, @County, @SchoolDistrict, @Bedrooms, @Bathrooms, @LivingSpace, @Stories, @BuildingStyle, @YearBuilt, @Basement, @Heating, @Cooling, @Image1, @Image2, @Image3)" >
172 <InsertParameters>
173 <asp:ControlParameter Name="Address" Type="String"
174 ControlID="TbAddress" />
175 <asp:ControlParameter Name="City" Type="String"
176 ControlID="TbCity" />
177 <asp:ControlParameter Name="State" Type="String"
178 ControlID="DdState" />
179 <asp:ControlParameter Name="ZipCode" Type="String"
180 ControlID="TbZipCode" />
181 <asp:ControlParameter Name="ListPrice" Type="String"
182 ControlID="TbListingPrice" />
183 <asp:ControlParameter Name="Taxes" Type="String"
184 ControlID="TbTaxes" />
185 <asp:ControlParameter Name="Subdivision" Type="String"
186 ControlID="TbSubdivision" />
187 <asp:ControlParameter Name="County" Type="String"
188 ControlID="TbCounty" />
189 <asp:ControlParameter Name="SchoolDistrict" Type="String"
190 ControlID="TbSchoolDistrict" />
191 <asp:ControlParameter Name="Bedrooms" Type="String"
192 ControlID="DdBedrooms" />
193 <asp:ControlParameter Name="Bathrooms" Type="String"
194 ControlID="DdBedrooms" />
195 <asp:ControlParameter Name="LivingSpace" Type="String"
196 ControlID="TbLivingSpace" />
197 <asp:ControlParameter Name="Stories" Type="String"
198 ControlID="DdStories" />
199 <asp:ControlParameter Name="BuildingStyle" Type="String"
200 ControlID="TbBuildingStyle" />
201 <asp:ControlParameter Name="YearBuilt" Type="String"
202 ControlID="TbYearBuilt" />
203 <asp:ControlParameter Name="Basement" Type="String"
204 ControlID="DdBasement" />
205 <asp:ControlParameter Name="Heating" Type="String"
206 ControlID="DdHeating" />
207 <asp:ControlParameter Name="Cooling" Type="String"
208 ControlID="DdCooling" />
209
210 <asp:ControlParameter Name="FileUpload1" Type="String"
211 ControlID="FileUpload1" />
212 <asp:ControlParameter Name="FileUpload2" Type="String"
213 ControlID="FileUpload2" />
214 <asp:ControlParameter Name="FileUpload3" Type="String"
215 ControlID="FileUpload3" />
216
217
218 </InsertParameters>
219
220 </asp:SqlDataSource>
  And here is the code behind   1
2 Partial Class mylistings
3 Inherits System.Web.UI.Page
4 Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
5
6 SqlDataSource1.Insert()
7 TbAddress.Text = ""
8 TbCity.Text = ""
9 DdState.Text = ""
10 TbZipCode.Text = ""
11 TbListingPrice.Text = ""
12 TbTaxes.Text = ""
13 TbSubdivision.Text = ""
14 TbCounty.Text = ""
15 TbSchoolDistrict.Text = ""
16 DdBedrooms.Text = ""
17 DdBathrooms.Text = ""
18 TbLivingSpace.Text = ""
19 DdStories.Text = ""
20 TbBuildingStyle.Text = ""
21 TbYearBuilt.Text = ""
22 DdBasement.Text = ""
23 DdHeating.Text = ""
24 DdCooling.Text = ""
25
26
27
28
29 Response.Redirect(Request.Url.ToString(), False) ' will include the querystring
30 End Sub
31 End Class
32
  

View 7 Replies View Related

DB Table With 1000 Columns?

Feb 15, 2008

I was wondering if it is possible to have a DB table with 1000 columns?
The other way is of course to break these columns into 1000 rows and an ID which tells what exactly does it relate to.

I want to know the pros and cons of having 1000 columns/rows for one set of related data.
The reason to need 1000 columns in the first place is that there are about 1000 questions in a set whose answers need to be saved for one session (hence all should go together).

Can anybody shed some light on it? Has anybody tried something so crazy before?

View 1 Replies View Related

EM - Open Table - Return Top... -1000

Jul 20, 2005

Is there a way to change the Open table - Return Top... -1000 defaultto something like 10. It should return only 10 by default? Any registrykeys?

View 1 Replies View Related

SQL Server 2008 :: Query A Column Of XML Files?

Feb 12, 2015

I have a table with lots of xml files in one column(more than 1000), like this

1. <content xmlns:xsi="http://www.w3.org/2001/XMLSchema...
2. <content xmlns:xsi="http://www.w3.org/2001/XMLSchema...
3. <content xmlns:xsi="http://www.w3.org/2001/XMLSchema...each is big

I want to query some values for all to see the duration but now I can only query one of them

declare @bp xml
select @bp=xml
from bloodpressureohneschema
;WITH XMLNAMESPACES('http://schemas.openehr.org/v1' as bp,'http://www.w3.org/2001/XMLSchema-instance' as xsi,'OBSERVATION' as type)
select * from(
select
m.c.value('(./bp:time/bp:value)[1]','date') as time,
m.c.value('(./bp:data/bp:items[1]/bp:value[1]/bp:magnitude)[1]','int') as value
from @bp.nodes('/bp:content/bp:data/bp:events') as m(c)
)m

is there somewhere I can make better?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved