sure....probably....kinda. You just need to read the data out of the source table in the old database and write it into the new table in the new database. Thats the "sure" part of the answer. the...

i answered a different question. Should have read the question better. mwasif got it right

Oh. So thats what it feels like to look like an idiot. I forget if I go more then 20 minutes without putting my foot in my mouth. I'll read more carefully next time

function modifyObject(o) {
o.value = 'Bullocks to that';
return o;
}

obj = new Object();
alert((modifyObject(obj)).value);

I can see right off the bat that you are missing the closing curly brace for the function definition in the onload event handler of the body. Plus it is missing quotes. After i fix that i just get...

This forum is for MySQL. an open source SQL server. This post belongs in the MS SQL forum. They will have your answer. But you could try sqlcmd if the command line doesn't scare you. It should...

if they are all coming from a single table...call it testTable... then you would just say


SELECT location1, location2, location3 FROM testTable WHERE ....

and then you can fill in whatever...

Or maybe something along the lines of


Function EnableRadioButtons ( array Elements )
if (button of interest is checked) {
For each Element in Elements
Set Element Enabled...

Ok...when i change the line this.value = this.dummy(value) to this.value = this.prototype.dummy(value) the code runs. Does anybody have any idea what this is about? isn't the point of the prototype...

Hello,

I am messing around with javascript. I am trying to create a function to which i can pass a constructor and recieve back an object. Kinda (read exactly) like the new keyword. call it a...

Sorry mate, my earlier comments would have nothing to do with why your script fails. I was just pointing out general coding style. never rely on semi-colen insertion. as to your problem...

in...

Also you seem to be relying on the javascript semi-colon insertion "feature". the language does require semi-colons at the end of every statement. It's just that it will supply them for you if you...

Please post the results. I am curious too see which is fastest. thanks

Give this a shot from within sqlcmd or osql....



EXEC sp_addumpdevice 'DISK', 'MyBackupToFTPland', 'DirectoryYouCanFTPFrom\backup.bak'

BACKUP DATABASE yourdatabase
TO MyBackupToFTPLand

Cursors are slooowwwwwww. you can add the ON DELETE CASCADE option to the foreign key in the sale_detail and sale_address tables. This makes it so that whenever you delete an entry in the parent...

HELLOOOOOO THERREEEE!!!! IT SOUNDS LIKE YOU WANT SEPERATE TABLES IF THE COLUMNS ARE ALL LINKED TO EACH OTHER!!!! YOU SHOULD COME CLOSER SO WE DON"T HAVE TO YELL!!!

It seems to be exactly what the original poster wanted. What exactly do you mean by 'its a static solution?' Wouldn't any query need to be recalculated every time to ensure accurate real time...

You want something like:

SELECT columnyouwant1,...,columnyouwantn, rowcount = COUNT(B.ForeignKey)
FROM TableB AS B
GROUPBY B.ForeignKey


Load that into a temporary table. lets call it T. ...

One last thing. If there is enough information to calculate the overall mark from the database then you might want to go ahead and do it as it is part of the notion of a normalized relational...

Sounds like a bad design to me. I am not familiar with foxpro but i would say that it is stupid to have to download the whole data base for any look up. it defeats the point of having a server. ...

I am not so familiar with ce but i would say try


IF OBJECT_ID(tablename) IS NULL
CREATE table
(
...
)

First off, the only two tables that are in any sort of normal form are Students and Subjects.
The others do not have a primary key. Secondly, you are repeating information from the StudentSubjects...

To be honest, I am not entirely sure. I do not believe that it would help with search speed in this example. It seems to be standard practice that every table have an IDENTITY column that serves...

I think you want to introduce a third table.

CREATE TABLE Moves
(
MoveID int IDENTITY NOT NULL PRIMARY KEY,
Date datetime NOT NULL
)

CREATE TABLE Items
(

The solution that I found is


UPDATE Test1
SET Value = Value + t2vs
FROM Test1 t1
INNER JOIN (SELECT Value, t2vs = SUM(Value)
FROM Test2 t2
GROUP BY...

Hello,

I am new to SQL. I assume that this is very simple. I have had trouble understanding the
relevant example in the BOL as my installation (Express edition) does not seem to have the...

Thanks for the reply. I edited this starter w/out realizing that it would start a new thread. The solution I came up with on the other thread was too just treat the HTML as XML and parse it that...

Hello All,


I have a user define class,



<Serializable()> Public Class City

Public Name As String = ""

I figured out that I can do what I need wtih the system.XML namespace and httpwebrequest/response.

Hi,

I am new to VB. I am trying to parse an html file. I would like not to use a WebBrowser control because it seems like overkill. The HtmlDocument class appears not to work outside of a...

Hi,

I am new to VB. I am trying to parse an html file. I would like not to use a WebBrowser control because it seems like overkill. The HtmlDocument class appears not to work outside of a ...