|
Jörgen Andersson wrote: I believe one subquery is unnecessary. Try:
SELECT *
FROM Orders
WHERE OrderID IN (
SELECT TOP 1 OrderID
FROM Orders O1
GROUP BY CustomerID
ORDER BY Inserted
)
I'm not sure I understand that inner query. For one OrderID in the SELECT clause should surely be part of an aggregate function seeing as it is not in the GROUP BY clause. Also, for Inserted to be contained in the ORDER BY clause it will also have to be part of an aggregate function. What am I missing?
|
|
|
|
|
You're not missing anything, it's me having had to little coffee and a non-functional brain.
Sorry 'bout that.
Be excellent to each other. And... PARTY ON, DUDES!
Abraham Lincoln
|
|
|
|
|
Hi
I had installed SSE2008 on a Small business 2008 server.
There were two of these servers on the domain.
The server I installed on was not the main server (if that makes sense)
In any case, they reinstalled the main server, but now I cannot start the SQLSERVER agnet service. The way I understand it, when you install an instance of SSE, there are certain windows permissions set up, and now since they re-installed Small Business server, thers permissions are no longer valid. I can go into the SSE server using Management Studio, but my appplication cannot see the server. Previously whet the server was rebooted, my application also could not see the server, but then by starting the service: SQLAgent$SQLEXPRESS it worked.
Any ideas how I can fix this? (I assume re-installing a new instance of SSE woulod work, since it would create new windows accounts? But this seems like the long way around and not a very elegant solution?)
|
|
|
|
|
We have 900,000 veterans with claims in the VA. It's clear the government either cannot or will not solve this, but it needs to be solved.
I wonder one thing: is there a way to crowdsource the solution?
There are some brilliant developers and data analysts on this board. While I don't count myself among these luminaries, I feel that we could solve this.
Cheers,
Daaron
|
|
|
|
|
Daaron wrote: is there a way to crowdsource the solution?
Filed under "Silver Bullet".
What's a VA?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: What's a VA?
Presumably the US Veterans Administration.
|
|
|
|
|
Daaron wrote: is there a way to crowdsource the solution?
You need to define the problem first.
Use the best guess
|
|
|
|
|
You are getting roasted because this is entirely the wrong place to discuss this issue.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Those who seek perfection will only find imperfection
nils illegitimus carborundum
me, me, me
me, in pictures
|
|
|
|
|
|
Daaron wrote: crowdsource the solution?
Solution to what exactly?
As a guess you are referring to back claims. If so then the back log is probably caused by a lack of humans an/or effective process control. Software might help with a solution to either of those, but software itself is not a solution.
|
|
|
|
|
Hi,
I am going to create a database in MySql to show the information on the website page.
I have data in my excel sheet it is related to Bollywood Movies / Songs.
Excel Sheet coloum details : Songs Title, Movie Name, Year, Singer, Music Director, Lyrics, Picturised, Actors, Banner,
Producer, Director, Music Company. I have Posters of Movies, pictures of all actors, Music directors, Singers etc.
Now my question is :
How can I design the database to show the record on the page.
1. If any user click on the particular Movie
the table should show the details are :
Song title | Singer | Music Director | Lyrics | Picturised
Poster of the movie will show on left / right side of the same page
2. If any user click on the particular singer
the table should show the singer's filmography details are :
Movie | Year | Music Director | Music Company
3. If any user click on the particular Movie the point no. 1 will be repeat
4. If any user click on the particular Music Director
the table should show the Music Director's filmography details are :
Movie | Year | Director | Music Company
5. If any user click on the particular Movie the point no. 1 will be repeat
it will be same for any actor, Music Director, Lyrics, Director, Banner etc..
=====
How many tables should I make and the table structure with primary / foreign key info for above said.
Thanks in advance
Muveen
|
|
|
|
|
Muveen_Delhi wrote: How many tables should I make
That depends on the design; I'd recommend to normalize the database-model, that way you'll have a guaranteed correct and consistent design. Alternatively, you can download a pre-built design on databaseanswers.org[^].
Muveen_Delhi wrote: How can I design the database to show the record on the page.
Databases do not show things; they store things. What kind of app would use the database? A webapplication, a desktop application, something on a phone?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I want to develop a website using PHP for that use I need this database.
|
|
|
|
|
Do a search for tutorials creating a music application (book would be similar), work through the tutorial.
You question shows a dramatic lack of understanding of what you are attempting, the tutorials will deepen that understanding and allow you to ask sensible questions.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have the following tables.
Table SS
SID SNAME
== =====
1 AAA
2 BBB
3 CCC
Table PP
PID PNAME
== =====
1 Phase1
2 Phase2
3 Phase3
Third table (COMP) data may look like the following.
ID SID PID
== === ===
1 1 1
2 1 2
3 1 3
4 2 1
5 2 2
ID here in third table is autoincrement. I need to insert a new record in SS table and it can have mapping to many Phases in PP table.
So I want to write a
INSERT INTO COMP (col1,col2)
SELECT (col1,col2)
FROM table...
So ultimately new records needs to be inserted into the last table with a SID map and different PID.
How can I accomplish the same?
Thanks in advance.
CodingRocks
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
Assuming you have a list of PIDs you want inserted you require 3 statemants,
<pre lang="SQL">Declare @NewID int
Insert SS (fields).Values
Set @NewID = scope_identity()
insert Comp(SID,PID)
Select @NewID, PID from listofpids</pre>
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
EDIT: I Guess this makes my problem clearer
i have 2 tables
Mother with Columns (Name,NameKey)
and Children with Columns(child,childkey,Mother.NameKey)
i want to connect 2 tables
and insert many children in 1 mother
is this code possible? can't try it right now
insert into children(mother.namekey,child)<br />
values<br />
(Select namekey from mother where name='TELMA'),BEN,RON,DONNA)<br />
i know my codes above have errors even w/o trying it.
i just want to know how to make that happen and get this output
MOTHER- CHILDREN
TELMA..............BEN
............................RON
...........................Donna
modified 24-May-13 22:59pm.
|
|
|
|
|
Have you tried (have assumed that this is SQL Server)
insert into family (children) values
select 'ben'
union
select 'ron'
union
select 'donna'
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
Al Arcilla wrote: i have a table family
columns (MOTHER,CHILDREN)
How did you create it? Can you post the CREATE TABLE statement?
Al Arcilla wrote: how can i have an output like that?
Is the problem in getting the "output" based on the data, or getting the data in the table?
Al Arcilla wrote: this is the code i try i know this will not work
What does "not work" mean? Did it execute succesfull or throw an exception? If there was an error, which one? Can you post it?
I'm going to guess that your "mother" column isn't a primary key, nor an identity. In that case, it'll need a value when you do the insert;
INSERT INTO [family] (MOTHER,CHILDREN)
VALUES ("Mother", "Ben");
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
|
Hi
how can Implementation
disributed database (in one computer(at sql 2008)/two server)؟?
Thanks
m.shamshirgaran@stu.semnaniau.ac.ir
|
|
|
|
|
2 things, do NOT put your email in a forum message, edit it out ASAP. If someone needs to get to you directly they can use the email option at the bottom of the posting.
Define what you mean by <code>distributed</code> you can install 2 instances of SQL server on the same machine this could simulate a distributed environment but you need to be more explicit.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have this SQL Server 2012 trivial stored procedure:
CREATE PROCEDURE usp_SelectCompany
AS
BEGIN
SET NOCOUNT ON
SELECT * FROM Company
END
and in a SSMS window, I execute this commands below to discover my SP is much slower than directly executing SELECT * from Company, even after the SP is run once to compile it.
SELECT * INTO #Company FROM Company WHERE 1=0
INSERT #Company EXEC usp_SelectCompany
PRINT 'Start Time: ' + cast(sysdatetime() as varchar)
INSERT #Company EXEC usp_SelectCompany
PRINT 'SP Time: ' + cast(sysdatetime() as varchar)
INSERT #Company SELECT * FROM Company
PRINT 'Select Time: ' + cast(sysdatetime() as varchar)
Here is the output:
(0 row(s) affected)
(127733 row(s) affected)
Start Time: 2013-05-22 11:56:57.7208741
(127733 row(s) affected)
SP Time: 2013-05-22 11:57:03.2067327
(127733 row(s) affected)
Select Time: 2013-05-22 11:57:04.0015524
I note that the SP executes in 5.4858586 seconds, and the direct "select" statement only takes 0.7948197 seconds, or about 7 times slower.
Can anyone explain this behavior?
|
|
|
|
|
Saxet wrote: Can anyone explain this behavior?
I can't, but a wild guess would be the optimizer (select and insert vs. insert and exec some proc).
What's the timing when you move the insert-statement inside the sproc?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
It's better (1.0295934 seconds), but still slower than the select in the SSMS window.
Start Time: 2013-05-22 12:51:03.6580584
End Time: 2013-05-22 12:51:04.6876518
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
)