|
|
Cmon be generous, what have you got so far, give us something more that the bare question to work with.
Select School,Subject, count(*) <br />
from suitable tables<br />
where score < 35<br />
group by School,Subject
Suitable tables will be the only challenge
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you Mycroft Holmes.
I tried this. but i am getting only one subject grouping data. i want is :-
School name ,count(lan1 marks <35), count(Lan2 marks < 35),count(Lan3 marks <35) ......I want to know school wise No of students who have failed in all subjects. Please tell me
************ S G KORE *******************
|
|
|
|
|
shiva.kore wrote: lan1 marks
What does this represent in your ideas.
Do you want a count of all students who scored < 35 in EVERY subject. This is quite a bit more complex and requires more knowledge of your data.
Basically get a distinct list of all student/scores > 35 then get a list of all student/scores who are NOT IN the > 35 list.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
We did a program 5 years ago to read a dbf table. The user now updated to Windows 7 and the program now gets this error
err=-2147467259 (80004005) [Microsoft][ODBC Driver Manager] Driver does not support this function
Connection string=Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=E:\\SPEC.DBF;Exclusive=No
It does NOT fail on the development machine which has Visual Studio 6, and Vis Studio 2005 .Net and Vis Studio 2010 are installed.
It did fail on a new Win 7 virtual machine after install the Visual Fox Pro 9 Driver (prior to the VFP driver it was getting a 429 activex failure).
It is not clear what the correct driver is to resolve this.
Can anyone help?
|
|
|
|
|
So you need to work out if it is win 7 or the virtual machine. I seem to have heard a number of complaints about drivers and virtual environments.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I think if you install MDAC_TYP 2.8 or earlier may solve your issue.
|
|
|
|
|
Hi,
I've tables, procedures and functions scripts of a oracle database. i need to convert it to sql server scripts. how to do that?.
we don't have oracle database but we have only scripts for the oracle database objects, is it possible to convert those scripts to sql server and create those objects in sql server database.
sql server version is 2005.
Thanks in Advance
|
|
|
|
|
try this oracle to sql server conversion
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
SQL Server Migration Assistant for Oracle (SSMA for Oracle), does it requires oracle client in my system, i don't have any oracle in my system at the same time i'm very new to oracle.
i've tried some trial tools but everything require oracle database but i've only oracle script.
how to convert those scripts to sql server based one.
|
|
|
|
|
best thing I could suggest is to post some of the code and we'll give you a head start on its conversion
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
Hi,
I'm posting sample table script
CREATE TABLE "DEV"."APP_ID"
( "AID" NUMBER NOT NULL ENABLE,
"ID_TYPE" NUMBER NOT NULL ENABLE,
"CREATED" DATE DEFAULT sysdate NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"UPDATED" DATE DEFAULT sysdate NOT NULL ENABLE,
"UPDATED_BY" VARCHAR2(30 BYTE) NOT NULL ENABLE,
PRIMARY KEY ("AID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "APPLICATION_DATA" ENABLE,
FOREIGN KEY ("ID_TYPE")
REFERENCES "DEV"."ID_TYPE" ("ID_TYPE") ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "APPLICATION_DATA" ;
CREATE OR REPLACE TRIGGER "DEV"."T_APP_ID"
BEFORE INSERT OR UPDATE ON APP_ID
FOR EACH ROW
BEGIN
:new.updated := sysdate;
:new.updated_by := username;
if inserting then
:new.created_by := username;
end if;
END T_APP_ID;
/
ALTER TRIGGER "DEV"."T_APP_ID" ENABLE;
|
|
|
|
|
CREATE TABLE App_ID
(
aid INTEGER PRIMARY KEY NONCLUSTERED,
id_type INTEGER FOREIGN KEY REFERENCES dev.id_type,
created DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
created_by varchar(30) NOT NULL,
updated DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_by varchar(30) NOT NULL,
)
drop table app_id
been a bit too long since I've done Oracle to remeber triggers so here an msnd refernce link triggers
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
so we have to go with manual process if we don't have oracle database.
|
|
|
|
|
Also Oracle offers free versions of their engine for developers - get one. Then get that database with those scripts, and then use a conversion tool as already suggested.
|
|
|
|
|
Thanks bhiller,
I'm downloading it. but it seems to be a huge file.
|
|
|
|
|
Hello I have been trying to learn c# and accessing ultralite I have found the link here 10 Steps to Creating a Windows Mobile Database Application Using .NET and UltraLite 10[^] Which has helped i got it working but what im trying to figure out is how to add a listbox that is controlled by the combobox. What would happen is I select say tom than the list box displays the address.I cant seem to get anywhere with it my previous coding experience is with html and vbscript.
Any help would be appreciated or if you can point me in the right direction
Thank You
Aaron
|
|
|
|
|
Not a database related question, more a C# question.
What you need to do is Handle the TextChanged or ValueChanged event of the ComboBox. In the event handler, populate the ListBox with the required data from your database etc.
Steve Jowett
-------------------------
Real Programmers don't need comments -- the code is obvious.
|
|
|
|
|
hi guys
i delete a column in a table UNWITTING
how can i restore my mistake
and retrieved my deleted column
|
|
|
|
|
Ctrl Z ?
How's the new job?
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
If you do not know how to help, shut up.
And provided you can read and comprehend
"Insults, slap-downs and sarcasm aren't welcome. Let's work to help developers, not make them feel stupid."
SG
Aham Brahmasmi!
|
|
|
|
|
SimulationofSai wrote: "Insults, slap-downs and sarcasm aren't welcome.
Yes they are... as long as they're directed at someone else.
|
|
|
|
|
You need to develop a sense of humour and read earlier threads, ass hat.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
if it had data in it then restore from backup.
As barmey as a sack of badgers
|
|
|
|
|
You can't per se, the data is gone.
However as Simon said you can restore from the last backup. S??? happens, that's what backups are for.
If this is a production DB on the otherhand, s??? should rarely happen to them, which means an awfull lot of arselicking would be required.
If there are no backups, divert blame to the DBA as s??? happens and that's what backups should be for.
If you are the DBA, and no backups have been performed, and this was the dev environment, copy the production environment to dev.
If you are the DBA, and no backups have been performed, and this was the production environment find the nearest exit and polish your resume.
Good luck!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
