Database Discussion Boards

Red Lake10-Jul-07 7:25

10-Jul-07 7:25

The jurors table has only two fields and I want both to appear. THere are about 20 different jurors, and I want to be able to randomly select 2 of them.

Steve Vondras
Red Lake Nation
MIS Tech
svondras@redlakenation.org

Re: Retrieve random rows in Access

Paul Conrad10-Jul-07 8:01

Paul Conrad

10-Jul-07 8:01

What are the two fields? Are you trying to do all of this from within Access or do you have an app tied into the database?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Retrieve random rows in Access

Red Lake10-Jul-07 8:06

Red Lake

10-Jul-07 8:06

The two fields are FIRST and LAST name, and I am doing this from within access.

Steve Vondras
Red Lake Nation
MIS Tech
svondras@redlakenation.org

Re: Retrieve random rows in Access

Paul Conrad10-Jul-07 8:10

Paul Conrad

10-Jul-07 8:10

You should have an id field that is a primary key. You can query by the id field with the randomly generated number.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Retrieve random rows in Access

sam#10-Jul-07 8:22

sam#

10-Jul-07 8:22

if you are able to get random row.then why don't you pick TOP 3 rows from the output

Re: Retrieve random rows in Access

Red Lake11-Jul-07 3:30

Red Lake

11-Jul-07 3:30

Where do I put TOP 3 in at on this statement:

SELECT *
FROM jurors
ORDER BY rnd();

I am very new sql thank you for your help

Steve Vondras
Red Lake Nation
MIS Tech
svondras@redlakenation.org

Re: Retrieve random rows in Access

Paul Conrad13-Jul-07 6:12

Paul Conrad

13-Jul-07 6:12

Replace the * with TOP 3...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Retrieve random rows in Access

Red Lake16-Jul-07 2:36

Red Lake

16-Jul-07 2:36

Thank you for the help.

Steve Vondras
Red Lake Nation
MIS Tech
svondras@redlakenation.org

Re: Retrieve random rows in Access

Paul Conrad16-Jul-07 7:31

Paul Conrad

16-Jul-07 7:31

No problem, Steve.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Datasets and varaible table name

joebaas10-Jul-07 3:27

joebaas

10-Jul-07 3:27

Hi all!

I've a SQL (2005) database that is structured as follows:
- a schema called "salary"
- the table name is given by the year and the effective table name. Example 2007.employees
- that gives the table name salary.[2007.employees]

In my project I've created a typed dataset with the wizard. I've then renamed the table name in the dataset without the year (ex. 2007.employees -> employees).

In the application I can choose in which year to work and should load the data from the choosen year in the dataset. I should have the possibiltiy to pass to the tabeladapter the year I want. How can I do that?

Thanks for suggestions!

Jörg

Re: Datasets and varaible table name

Paul Conrad13-Jul-07 11:50

Paul Conrad

13-Jul-07 11:50

I think you look in the properties of the data adapter and include parameters.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Datasets and varaible table name

joebaas16-Jul-07 5:14

joebaas

16-Jul-07 5:14

Yes it's possible the add parameters in the table adapter, but not for the table names. When you try to add a paramter for the table name, the query builder gives an error.

I'm now thinking to add a column "Year" in each table, so that each row is allocated in a year and all data is in one table and database.

cancel inner join

Amr M. K.10-Jul-07 1:02

Amr M. K.

10-Jul-07 1:02

Hello
How can I cancel inner join between two tables if the value in second table not exists ..
to be more clear
TableA
-Col1
-Col2
-Col3

TableB
-Col1
-Col2
-Col3
-Col9

select TableA.col1 ,TableA.col2 ,TableB.Col1
where TableA.col3=TableB.Col9

the result will diplay if the match happend I have tried to do like this
in
TableA.col3=isNull(TableB.Col9,TableA.col3)
or something like that..
the problem that I face in sqlDataSource in asp.net

aj123

Re: cancel inner join

gauthee10-Jul-07 2:04

gauthee

10-Jul-07 2:04

I did not understand your question but i guess you are looking for: 'coalesce' - try this out

Gautham

Re: cancel inner join

Pete O'Hanlon10-Jul-07 2:11

Pete O'Hanlon

10-Jul-07 2:11

Use the INNER JOIN syntax.

SELECT a.Col1, a.Col2 FROM TableA a 
INNER JOIN TableB b
ON b.FK_Field = a.PK_Field

This will return you rows where items are present in both tables only.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Re: cancel inner join

WoutL10-Jul-07 2:15

WoutL

10-Jul-07 2:15

Use a left join:

select TableA.col1 ,TableA.col2 ,TableB.Col1<br />
From TableA<br />
inner join TableB on TableA.col3=TableB.Col9

Wout Louwers

Re: cancel inner join

Amr M. K.10-Jul-07 2:48

Amr M. K.

10-Jul-07 2:48

yes that right..
I forget that...

aj123

INSERT query for a table?(Using two Tables)

chand1010-Jul-07 0:52

chand10

10-Jul-07 0:52

Hi
I stuck at an INSERT Query using two tables.
I have two tables Table1 and Table2.In Table1 I have 2 columns,one with dupicate value and another with null values.In Table2 I have 2 columns,both the columns have unique values.

Now I have to INSERT values from Table2 to Table1 with the corresponding or maching values like

Table1
StateCode StateName
--------- ----------
AK NULL
AK NULL
AK NULL
AL NULL
AL NULL
AL NULL
CO NULL
CO NULL
CO NULL

Table2
StateCode StateName
--------- ----------
AK Alaska
AL Alabama
AR Arkansas
AZ Arizona
CA California
CO Colorado

I have to INSERT values into Table1 in the null column from Table2 w.r.t StateCode.

Help me Confused | :confused:

Suggest me an example.

I have not failed. I've just found 10,000 ways that won't work. -Thomas A. Edison

Thank u
Chandu

Re: INSERT query for a table?(Using two Tables)

andyharman10-Jul-07 1:39

andyharman

10-Jul-07 1:39

Hi Chandu

Sounds like you need to "update". Something like:

update Table1 set StateName = Table2.StateName
  from Table2
  where Table2.StateCode = Table1.StateCode

Regards
Andy

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

Error "item has already been added.Key in dictionary" while programming in .Net using DB2 as backend

salimssss10-Jul-07 0:40

salimssss

10-Jul-07 0:40

i was trying to analyze this error.....
i want to know this error is due to frontend or backend.....
i just want the solution for this error in Frontend or backend....

dasdfsadfvasdcvasd

Re: Error "item has already been added.Key in dictionary" while programming in .Net using DB2 as backend

Paul Conrad15-Jul-07 5:24

Paul Conrad

15-Jul-07 5:24

Is the field a primary key?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

how to read an excel file in sql server 2000

Amit Sk Sharma9-Jul-07 22:00

Amit Sk Sharma

9-Jul-07 22:00

I tried a query

SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\TestSheet.xls',
'SELECT * FROM [Sheet1$]')

but its giving me error either sheet1 not found or syntax error near ')'

unable to find out the base of problem. Plz suggest me the perfect query that could be able to fetch data from excel sheet. I implemented it through front end (VB.NET) and its working properly but this time i need to write a stored procedure for the same.

With Thanks & Regards
Amit Sk Sharma

Re: how to read an excel file in sql server 2000

Paul Conrad13-Jul-07 11:51

Paul Conrad

13-Jul-07 11:51

Does Sheet1 exist in the file?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

ORA-12505 [modified]

Shajeel9-Jul-07 21:52

Shajeel

9-Jul-07 21:52

i am getting the following problem when connecting to oracle using OracleClient in C# ASP.NET 1.1:

ORA-12505: TNS:listener could not resolve SID given in connect descriptor

I am using this in connection stirng with proper user and password:

Data Source=ABC;User ID={0};Password={1};Unicode=true

where ABC is the Database added in Management Console (only client is installed on the computer), i can connect to this database using Console and also by creating dsn. Can anyone figure out the problem, as my program is running on many other pcs correctly.

-- modified at 7:06 Tuesday 10th July, 2007

Regards
Shajeel

Re: ORA-12505

andyharman11-Jul-07 3:16

andyharman

11-Jul-07 3:16

Did you configure the "tnsnames.ora" file on your PC? This may help: http://www.codeproject.com/vbscript/connection_string.asp[^]

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.