Viewing 15 posts - 1 through 15 (of 34 total)
I imported an Excel file, so I was looking at that. It's sorted by name, then by date (newest to oldest) so that the first occurrence of each customer is...
July 30, 2012 at 10:14 am
Hi Jared, Luis
"...It is creating a derived table of minimum id's when grouped by name."
Instead of creating the derived table sorted by...
July 30, 2012 at 10:06 am
Luis Cazares (7/30/2012)
SELECT m.Master, t.ID FROM @tTable t
JOIN ( SELECT MIN(ID) AS Master,
name
FROM @tTable
GROUP BY name) M ON t.name = m.name AND m.Master <> t.ID;
[/code]
Would you mind explaining what is...
July 30, 2012 at 9:10 am
That looks good, however I am using SQLite (www.sqlite.org) and it doesn't seem to work with it.
Would I need MS SQL 2008 R2 Express to run it?
July 30, 2012 at 5:41 am
Yes, that's looking good. The actual file has 51 columns and 117,000 rows but it should be possible to apply the same procedures to it.
December 3, 2011 at 9:34 am
...The "first occurrence" will be the lowest value of "Project_" in "Large". I hope that's clear!
Tom
December 3, 2011 at 8:51 am
You are correct Journeyman. The data in this table got corrupted somehow. I will try to post the correct data.
I'm not familiar with inserting Excel files into SQL so I'm...
December 3, 2011 at 8:46 am
Thanks for all the help so far.
I still don't have a solution.
If I run these queries:
SELECT [Project Country Code], [Project Number], [Unique Number], [Old dwg number], [Reuse], [Drawing no. seq],...
December 3, 2011 at 5:04 am
OK, thanks for your help.
So, with the 2 tables created details below, I want to create a third table that contains the fields from "Smalltable" and the corresponding record from...
December 1, 2011 at 6:01 am
Sorry but I'm not sure what this does. I ran the query and it says
(28 row(s) affected)
(100 row(s) affected)
Tom
Cadavre (12/1/2011)
tmccar (12/1/2011)
December 1, 2011 at 4:06 am
Yes, you are right - the drawing number should not have the ".dwg" extension
OK, here is what I've tried:
SELECT Smalltable.[Drawing Number], "Path"
FROM Smalltable
INNER JOIN Largetable
ON Smalltable.[Drawing Number]=Largetable.[Drawing Number]
But I'm not...
December 1, 2011 at 3:15 am
John Mitchell-245523 (11/29/2011)
November 30, 2011 at 1:57 am
Here is the command that I'm using which gives me 2 columns, Drawing Number and Project Number.
SELECT dbo.Largefile.[Drawing Number], MIN([Project Number])
FROM dbo.Largefile
JOIN dbo.Smallfile ON dbo.Largefile.[Drawing Number] =...
November 28, 2011 at 9:33 am
Viewing 15 posts - 1 through 15 (of 34 total)