help on multiple column updates - backtracking data for 30 days

i need to back track data should there be changes for the last 30 days.
help!
thank you!misheL wrote:

> i need to back track data should there be changes for the last 30
> days.
Are you seriously expecting many posters to respond and take the time
to answer your question considering the amount of time you have put
into formulating your question?
Kind regards,
Stijn Verrept.|||On Tue, 13 Dec 2005 17:30:02 -0800, misheL wrote:

>i need to back track data should there be changes for the last 30 days.
>help!
>thank you!
Hi misheL,
Please provide better specifications. See www.aspfaq.com/5006.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

help on insert a record on sql server with identity column as key

Hi, All:
Please help. I use sql server as back end and Access 2003 as front end
(everything is DAO).
A table on SQL server has an identity column as the key.
We have trouble on adding records to this table using the following SQL.
strSQL = "INSERT INTO myTableOnSQLServer (A, B, C, D, E) SELECT A, B, C, D,
E FROM myTableonAccessLocal"
db.execute strSQL
The schema of the table "myTableOnSQLServer" and the schema of the table
"myTableonAccessLocal" are all the same except that the "myTableOnSQLServer"
has an identity column (ID). The key of the "myTableOnSQLServer" is "ID" and
the table "myTableonAccessLocal" does not have a key.
When we try to run the query, it gives errors indicating the key is violated
or missing.
Should I figure out the autonumber for it first and then add to the SQL
server table?
Many thanks,
HS
"Hongyu Sun" wrote:

> Hi, All:
> Please help. I use sql server as back end and Access 2003 as front end
> (everything is DAO).
> A table on SQL server has an identity column as the key.
> We have trouble on adding records to this table using the following SQL.
> strSQL = "INSERT INTO myTableOnSQLServer (A, B, C, D, E) SELECT A, B, C, D,
> E FROM myTableonAccessLocal"
> db.execute strSQL
> The schema of the table "myTableOnSQLServer" and the schema of the table
> "myTableonAccessLocal" are all the same except that the "myTableOnSQLServer"
> has an identity column (ID). The key of the "myTableOnSQLServer" is "ID" and
> the table "myTableonAccessLocal" does not have a key.
> When we try to run the query, it gives errors indicating the key is violated
> or missing.
> Should I figure out the autonumber for it first and then add to the SQL
> server table?
> Many thanks,
> HS
As a common an identity column generates values by itself. If you need to
insert values into an identity column use this command:
SET IDENTITY_INSERT myTableOnSQLServer ON
After the insert has been completed issue the following statement:
SET IDENTITY_INSERT myTableOnSQLServer OFF
Good luck

help on insert a record on sql server with identity column as key

Hi, All:
Please help. I use sql server as back end and Access 2003 as front end
(everything is DAO).
A table on SQL server has an identity column as the key.
We have trouble on adding records to this table using the following SQL.
strSQL = "INSERT INTO myTableOnSQLServer (A, B, C, D, E) SELECT A, B, C, D,
E FROM myTableonAccessLocal"
db.execute strSQL
The schema of the table "myTableOnSQLServer" and the schema of the table
"myTableonAccessLocal" are all the same except that the "myTableOnSQLServer"
has an identity column (ID). The key of the "myTableOnSQLServer" is "ID" and
the table "myTableonAccessLocal" does not have a key.
When we try to run the query, it gives errors indicating the key is violated
or missing.
Should I figure out the autonumber for it first and then add to the SQL
server table?
Many thanks,
HS"Hongyu Sun" wrote:

> Hi, All:
> Please help. I use sql server as back end and Access 2003 as front end
> (everything is DAO).
> A table on SQL server has an identity column as the key.
> We have trouble on adding records to this table using the following SQL.
> strSQL = "INSERT INTO myTableOnSQLServer (A, B, C, D, E) SELECT A, B, C, D
,
> E FROM myTableonAccessLocal"
> db.execute strSQL
> The schema of the table "myTableOnSQLServer" and the schema of the table
> "myTableonAccessLocal" are all the same except that the "myTableOnSQLServe
r"
> has an identity column (ID). The key of the "myTableOnSQLServer" is "ID" a
nd
> the table "myTableonAccessLocal" does not have a key.
> When we try to run the query, it gives errors indicating the key is violat
ed
> or missing.
> Should I figure out the autonumber for it first and then add to the SQL
> server table?
> Many thanks,
> HS
As a common an identity column generates values by itself. If you need to
insert values into an identity column use this command:
SET IDENTITY_INSERT myTableOnSQLServer ON
After the insert has been completed issue the following statement:
SET IDENTITY_INSERT myTableOnSQLServer OFF
Good lucksql

Help needed with SQL SERVER 2000 Analysis Manager

I am going through the tutorial and I got to the portion on Set Dimension Custom Rollups, Write Back and more. I selected the Parent-Child dimension, and followed all of the steps as directed until it asked me to Select advanced options. The Write Back option is not listed and it has to be selected in order for me to complete this section. Please help.Same for me, I even try to change connexion without any success
any help ?

HELP- need to convert SQL 6.5 Back Up to 2000

HELP- need to convert SQL 6.5 Back Up to 2000
I have made enterprise manager back ups of two databases
on a SQL 6.5 server. The back ups are .dat files. I
want/need to convert these to SQL 2000 or SQL 7.0. I have
a SQL 2000 server. I tried to create a new database on
the SQL 2000 server and then restore the back ups to the
SQL 2000 server's new database I just created. I get an
error saying that the back up is not valid.
What is the procedure for getting this .dat 6.5 back up to
SQL 2000?
mick2767@.hotmail.comWhat you should do is to use the Upgrade Wizard... If you have the SQL 6.5
server with the dbs installed... Simply go to program files -> SQL Server
and you will find the upgrade wizard... That's the way to go.!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<mick2767@.hotmail.com> wrote in message
news:0cc201c3adf9$da109e50$a501280a@.phx.gbl...
> HELP- need to convert SQL 6.5 Back Up to 2000
> I have made enterprise manager back ups of two databases
> on a SQL 6.5 server. The back ups are .dat files. I
> want/need to convert these to SQL 2000 or SQL 7.0. I have
> a SQL 2000 server. I tried to create a new database on
> the SQL 2000 server and then restore the back ups to the
> SQL 2000 server's new database I just created. I get an
> error saying that the back up is not valid.
> What is the procedure for getting this .dat 6.5 back up to
> SQL 2000?
> mick2767@.hotmail.com|||When you do your restore, make sure that under options...Force restore
over existing database is checked. That might solve your problem.
"Wayne Snyder" <wsnyder@.ikon.com> wrote in message news:<e#z$IxfrDHA.1880@.TK2MSFTNGP09.phx.gbl>...
> What you should do is to use the Upgrade Wizard... If you have the SQL 6.5
> server with the dbs installed... Simply go to program files -> SQL Server
> and you will find the upgrade wizard... That's the way to go.!
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <mick2767@.hotmail.com> wrote in message
> news:0cc201c3adf9$da109e50$a501280a@.phx.gbl...
> > HELP- need to convert SQL 6.5 Back Up to 2000
> >
> > I have made enterprise manager back ups of two databases
> > on a SQL 6.5 server. The back ups are .dat files. I
> > want/need to convert these to SQL 2000 or SQL 7.0. I have
> > a SQL 2000 server. I tried to create a new database on
> > the SQL 2000 server and then restore the back ups to the
> > SQL 2000 server's new database I just created. I get an
> > error saying that the back up is not valid.
> >
> > What is the procedure for getting this .dat 6.5 back up to
> > SQL 2000?
> >
> > mick2767@.hotmail.com|||As Wayne said in his post: you cannot restore a 6.5 database into 7.0 or 2000.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Indigo Montoya" <Indigo_Montoya_2@.hotmail.com> wrote in message
news:f18452ec.0311181645.5b561bc7@.posting.google.com...
> When you do your restore, make sure that under options...Force restore
> over existing database is checked. That might solve your problem.
>
> "Wayne Snyder" <wsnyder@.ikon.com> wrote in message news:<e#z$IxfrDHA.1880@.TK2MSFTNGP09.phx.gbl>...
> > What you should do is to use the Upgrade Wizard... If you have the SQL 6.5
> > server with the dbs installed... Simply go to program files -> SQL Server
> > and you will find the upgrade wizard... That's the way to go.!
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Computer Education Services Corporation (CESC), Charlotte, NC
> > www.computeredservices.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> > <mick2767@.hotmail.com> wrote in message
> > news:0cc201c3adf9$da109e50$a501280a@.phx.gbl...
> > > HELP- need to convert SQL 6.5 Back Up to 2000
> > >
> > > I have made enterprise manager back ups of two databases
> > > on a SQL 6.5 server. The back ups are .dat files. I
> > > want/need to convert these to SQL 2000 or SQL 7.0. I have
> > > a SQL 2000 server. I tried to create a new database on
> > > the SQL 2000 server and then restore the back ups to the
> > > SQL 2000 server's new database I just created. I get an
> > > error saying that the back up is not valid.
> > >
> > > What is the procedure for getting this .dat 6.5 back up to
> > > SQL 2000?
> > >
> > > mick2767@.hotmail.com