a.id is an integer and the identity column for a (CDT_DEM_Pages)
a.alphanumeric is an nvarchar(50) that is NOT NULL
MGM out...
MGM
Last Activity: Jul 31 '08, 11:47 AM
Joined: Aug 2 '07
Location:
-
Well the problem with that is that the text that I need to append is not static and is actually a row inside another table (CDT_DEM_Pages) . That is to say, CDT_DEM_Pages has a column named alphanumericnam e that has text in it, this text need's to be appended to the end of [CDT_DEM_DATA_] so that I can get the data I need. The bold part in the query below is what needs to be changed:
...Code:SELECT id, name, (SELECT COUNT(*)Leave a comment:
-
Appending strings in query to create table name?
Hello everyone,
I once again have a problem :p I need to write a query to get the total amount of rows in a table. Problem is, the table name is dynamic and part of its value is stored in another table. Here's my query:
...Code:SELECT id, name, (SELECT COUNT(*) AS amtColumns FROM CDT_DEM_Columns WHERE (pageid = a.id)) AS amtColumns, (SELECT COUNT(*) AS amtRows -
I actually ended up changing my table structure around so no need for all of the above. Thanks for the help however, it was a very interesting read to see what solutions you guys could come up with.
MGM outLeave a comment:
-
String sent to function, needs to return only alphanumeric values
Hey everyone, I had a quick problem:
I want to be able to send a string of data to a function and have it return that same string but only in alphanumerics. That is to say, if I sent it:
"Hello world 1!"
It should return:
"Helloworld 1"
Is this possible? I know I can do a verification using RegEx, but I want to actually alter the string to return only... -
Joining two values together across multiple tables
This is a bit hard to explain but I'll try my best.
I have 2 tables. One table has a row with the following value:
2,3
The two numbers are both ID's that are in the second table. I need to write a query that will ultimately give me the values of the second table, merged together as follows:
Data One, Data Two
Instead of just the id's. Is this possible? I tried to figure... -
If I wanted to edit 50,000 rows in one of the smaller datasets before uploading to the TOTAL database, what would be the fastest way of achieving this?
MGM outLeave a comment:
-
I have a large database that needs editing
I have a bunch of fairly large databases, each going anywhere from 1,000 rows to 50,000 rows. These databases, however, need some editing. They have extra columns that need to be removed and certain other columns that need to be populated. What would be the fastest way in doing this?
I'll also need to add these database to another large database (a "total" database) that contains all of the data. Should I do the edits... -
Has anyone come up with a solution yet? I would really like to get back to work on this project but cannot do so while this problem still exists...
MGM outLeave a comment:
-
I apologize, due to a case of misinformation among my fellow co-workers, I seem to have recieved the wrong information on this subject. Let me start over.
We have 4 columns. We have ColID, ColNameA, ColNameB, and ColQuantityA. Now, most dbf files won't have the ColQuantityA, in which case the entire table simply needs to be uploaded to SQL Server.
Some DBF files WILL have the ColQuantityA column. If it exists, what...Leave a comment:
-
Basically, I have a table in the dbf with 3 columns. There's Column ID, Column A, and Column B. Column A is supposed to be there, and has X data. Column B is NOT supposed to be there, and has Y data. Now, each DBF file may or may not have Column B. If Column B DOESN'T exist, it's a simple matter of copying over the entire table to the SQL Server.
If Column B DOES exist, then we go through the entire table row by row. If the row...Leave a comment:
-
Need to transfer many DBF files, while editing them at the same time
Alright, so here's my issue. I have a bunch of .dbf files, about 40 or so by summer's end, I'd say. These dbf files somewhat differ from each other as far as number of columns and data is concerned. I need to transfer all of these dbf files over to a SQL Server database so that I may write ASP pages for pulling statistics from them.
My problem is, this needs to be done in as easy a manner as possible, because we'll be getting more... -
It's fine. I haven't gotten any timeout errors since last time. I got an exception error of some sort while running this over the weekend however, so I STILL haven't gotten this thing running. I figured it out and fixed it, and as of right now everything is running properly. I'm going to be checking this throughout the day to make sure it stays running properly. If so, I'll leave it running over night and hopefully it'll be done by tomorrow....Leave a comment:
-
I looked at that page's SQL Server strings and didn't find anything on timeouts...
MGM outLeave a comment:
-
I converted it to an vb.net app and running it right now. A few times during the running I did get a timeout error for this line:
...Code:connSQL2.Open() Dim sqlComm2 = New SqlCommand("UPDATE phasedetails SET " & title & "='" & newDevphasing1 & "', " & title2 & "='" & newDevorien1 & "' WHERE ID=" & id, connSQL2) sqlComm2.ExecuteNonQuery()Leave a comment:
-
The ABC are the column names, and the numbers are different (132 to 123, and 564 to 546).
I uploaded it to SQL Server and wrote a quick ASP web page to do the conversion and it seems to do it much, much faster. It'll still take a while, but hopefully not as long. Only problem is, I can only do about 300 rows at a time or else it gives me a Timeout error. Any way to get past this? Would doing it in vb.net be faster?
...Leave a comment:
-
It's more like this:
A | B | C
------------
1 | 3 | 2
5 | 6 | 4
Needs to turn into this:
A | B | C
------------
1 | 2 | 3
5 | 4 | 6
Notice how the second row changes according to how the first row's order is changed (to numerical)?
And I don't really see how making it into 50k chunks would help, as it would still take the same...Leave a comment:
-
I already tried having this run overnight and it only completed about 30% of it. It would take about 3 full days for this to get done. If I were to let this run over the weekend, and if something were to go wrong, I wouldn't know about it until Monday, which probably means I'd have to start it all over again.
I need something that can get this done as quickly as possible, preferably a few hours, and no more than a day (so that...Leave a comment:
-
Very slow updating access table using vb.net
Hey everyone, I'm having some issues here. I have a large Access .mdb (over 400,000 rows).
What I need to do is, there are 12 columns that need to be reordered (quite literally as simple as if it is XZY, change to XYZ, but the row next to it must ALSO be changed accordingly, as in, WEC to WCE [in other words, however the first row's order was changed, the second row must also be changed in the exact same order]).
...
No activity results to display
Leave a comment: