Database

Sylvester george18-Jun-07 1:07

Sylvester george

18-Jun-07 1:07

Question is little confusing ...Please provide the data for NewColumn.So that I can suggest how it would be implemented

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Navneet Hegde18-Jun-07 1:21

Navneet Hegde

18-Jun-07 1:21

Hi S,

Though I have Given value above for new Column ,
Anyway

Id dateOf Entry value NewColumn
1 25/02/2007 15 15
2 26/02/2007 25 25
3 27/02/2007 18 25
4 28/02/2007 65 65

hope U get what i mean
U can just think ok Cumulative Value , but only difference is that we want the max of value's

Thanks & Wishes
Navneet Hegde
Nashik(City Of Pilgrimage)

Develop2Program & Program2Develop

Sylvester george18-Jun-07 1:52

Sylvester george

18-Jun-07 1:52

hey try this query...I tried with my table just replace with your filedname

select Created,Total, (select max(b.Total) from purchasertransactionmaster b where b.Created<=a.Created) newtotal from purchasertransactionmaster a

created = dateOf Entry
Total = value
newtotal = new column value
purchasertransactionmaster = table name

Regards,
Sylvester G
sylvester_g_m@yahoo.com

sql Server 2000 Change table datas to another table

Navneet Hegde19-Jun-07 3:58

Navneet Hegde

19-Jun-07 3:58

hello Dear ,

The Snippet really works ,
I really appretiate your help
thanks Again

Thanks And Regards
Navneet Hegde
Nashik(City Of Pilgrimage)

Develop2Program & Program2Develop

Creating a table

John.L.Ponratnam17-Jun-07 23:46

John.L.Ponratnam

17-Jun-07 23:46

Can this is possible. I want to create a table using stored procedure with parameters. The given values that I enter to the parameter must me the name of the table and the column. If so plz help me.

Regards,
LEE

Re: Creating a table

Pete O'Hanlon18-Jun-07 0:01

Pete O'Hanlon

18-Jun-07 0:01

It is possible to do this using embedded SQL, but is this really a valid design. Following the creation of the table, you would somehow have to be able to insert records into this table, update it and so on. The ability to do this would have to be persisted somewhere in your calling application. Are you really sure that this is what you want to do?

Deja View - the feeling that you've seen this post before.

Re: Creating a table

Aaron VanWieren20-Jun-07 5:00

Aaron VanWieren

20-Jun-07 5:00

I am just curious, but what exactly are you trying to do?

_____________________________________________________________________

Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.

The Enlightenment Project (paraphrased comment)

Visit Me at GISDevCafe

kankeyan17-Jun-07 23:35

kankeyan

17-Jun-07 23:35

Hello friends

i have a doubt pls clarify it. i want to transfer all data to one table to another table .How can i do it pls explain me and give syntax or tell wizard how to do it.

pls helpme urgent

kankeyan

Re: sql Server 2000 Change table datas to another table

Colin Angus Mackay17-Jun-07 23:41

17-Jun-07 23:41

At its simplest:

INSERT INTO DestinationTable
SELECT * FROM SourceTablel;

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

thank u

kankeyan17-Jun-07 23:49

kankeyan

17-Jun-07 23:49

thank u Mr colin its very simple
thanks

blob

WhiteGirl2317-Jun-07 22:41

WhiteGirl23

17-Jun-07 22:41

Hi,
I work on a function which extract a blob field from a database access with datareader but I have an error:
specified cast is not valid

The code is:

 Dim sql As String = DB_CONNECT<br />
        Dim connect As New OleDb.OleDbConnection(sql)<br />
<br />
        connect.Open()<br />
<br />
        Dim command As New OleDb.OleDbCommand("select bindata from notiz", connect)<br />
<br />
        Dim reader As OleDb.OleDbDataReader = command.ExecuteReader(CommandBehavior.SequentialAccess)<br />
<br />
<br />
        Dim i As Integer = 0<br />
        Dim v(100) As String<br />
      <br />
<br />
<br />
        While reader.Read()<br />
           <br />
                v(i) = reader.GetString(0)<br />
<br />

Maybe you have an idea.
Thanks.

Re: blob

Colin Angus Mackay17-Jun-07 23:11

DAAB January 2006 @ReturnValue Confusion

17-Jun-07 23:11

It will arrive as binary data in which case you need a byte array. I don't know enough VB to say how you declare that byte[] in C#.
Dim v() As Byte perhaps?

Then use GetBytes[^] to get the data from the column.

Brendan Vogt17-Jun-07 9:52

Brendan Vogt

17-Jun-07 9:52

Hi,

I am using DAAB January 2006. I have the following declaration, do I need it, I get an error:

db.AddOutParameter(command, "@ReturnValue", DbType.Int32, 4);

Error:

Procedure or function sp_Property_InsertProperty has too many arguments specified.

I use it to get the value returned like:

using (dr = db.ExecuteReader(command))
{
intResultCode = (int)db.GetParameterValue(command, "@ReturnValue");
}

The variable @ReturnValue is what SQL returns and need not be declared?

Please can someone help?

Regards
ma se

Re: DAAB January 2006 @ReturnValue Confusion

sam#17-Jun-07 21:59

Re: DAAB January 2006 @ReturnValue Confusion

17-Jun-07 21:59

ma se wrote:
Error:

Procedure or function sp_Property_InsertProperty has too many arguments specified.

please check every where where are passing parameters.i think problem is there

Mike Dimmick18-Jun-07 5:28

Mike Dimmick

18-Jun-07 5:28

I don't know about the DAAB, but for .NET data providers in general, set the parameter's Direction property to ParameterDirection.ReturnValue. This property is a member of the IDataParameter interface.

The actual name of the return value parameter is unimportant, but it must be the first parameter in the parameters collection.

Stability. What an interesting concept. -- Chris Maunder

How to get a better way to retrieve data from database?

davidlks17-Jun-07 0:52

davidlks

17-Jun-07 0:52

Hi all,

I am currently doing a SPC (Statiscal Process Control) software. It is related to Vision Inspection Machine. The software is doing using VC 6 MFC, and database using Microsoft Access.

I am in the final stage of the software development. Now i am facing the problem when i try to retrieve data from the table. The data was extremly huge (about 150k row for a table in a single day, it continue append) and make my software extremely slow when i display all my graph. As is keep track of each of every data that have been inspected by the machine.

At first, i get all needed data using for loop, then i put some comparison in it. If it fullfill then it will use ADO to send query to access. The processing time was horrible. Then i find out that if i retrieve the whole junk of data for the coloum i needed in a CStringArray, then only i compare the CStringArray in the for loop. The time was shorten, it take about 5 to 10 second.

My question is, am i doing the right way of getting data ? Is there any faster method ? Or is this the limitation if Microsoft Access ? Please help.

Thanks alot

Best regards,
David

Re: How to get a better way to retrieve data from database?

sam#17-Jun-07 21:53

SQL server 2005 Enterprise Edition Doubt...

17-Jun-07 21:53

again n again firing query for retrieval increases too much communication cost so it's not a good idea for retrieving data.

Suggestion 1:
create a stored procedure do all your work there and return the final result

Suggestion 2:
make a dynamic query or condition for your query and fire at once

Hope it'll help in improving performance of your data retrieving procedure

Sathyaa1516-Jun-07 23:18

Sathyaa15

16-Jun-07 23:18

Hai,

I have SQL Server 2005 Enterprise Edition in the DVD.I have Windows XP SP2 operating system in my PC.But i am unable to install the SQL Server 2005 Enterprise Edition in my PC.Why?.Please anybody give the solution for this.

And also what edition is suitable for the Windows XP Sp2 System.

Regards,
Gnanavel N

sam#17-Jun-07 21:45

17-Jun-07 21:45

it also requires 3.1 or 3.2 installer might be missing in your OS

Colin Angus Mackay17-Jun-07 21:48

17-Jun-07 21:48

For SQL Server Enterprise you need a Server class OS.

Colin Angus Mackay17-Jun-07 21:47

17-Jun-07 21:47

Sathyaa15 wrote:
But i am unable to install the SQL Server 2005 Enterprise Edition in my PC.Why?.Please anybody give the solution for this.

The solution is to install it on a Server edition of Windows.

SQL Server Enterprise (and Standard) is not designed to run on desktop editions of Windows (Home and Professional).

If you want to run SQL Server on Windows XP then use SQL Server 2005 Express Edition.

sam#17-Jun-07 21:56

17-Jun-07 21:56

Colin Angus Mackay wrote:
The solution is to install it on a Server edition of Windows.

dear i think your are mistaken it's running perfactly at my desktop with WinXp Sp2

Colin Angus Mackay17-Jun-07 22:40