Viewing 15 posts - 16 through 30 (of 34 total)
Success! Filter is working great now, thanks John
Tom
November 28, 2011 at 7:13 am
This is what I've tried:
SELECT [Drawing Number], MIN([Desc])
FROM dbo.Largeone JOIN dbo.Smallone ON dbo.Largeone.[Drawing Number] = dbo.Smallone.[Drawing Number]
GROUP BY [Drawing Number]
but I get an error "Ambiguous column name - Drawing Number"...
November 28, 2011 at 4:28 am
This is as far as I've got:
select min(dbo.Largefile."Drawing Number")
from dbo.Largefile join dbo.Smallfile on dbo.Largefile."Drawing Number" = dbo.Smallfile."Drawing Number"
Here are simplified samples of the tables:
dbo.Largefile:
Size of drawingISO CodeDrawing Number
...
November 25, 2011 at 9:08 am
John, I have imported the tables into SSMS. Could you tell me what SQL query to run?
November 25, 2011 at 7:44 am
Can you help with the command? Here is what I have, but it is giving an error message:
=VLOOKUP(J2,[trim2.xlsx]Sheet2!$J$2:$J$80039,10,FALSE)
(The "drawing number" column is column J - this column is common to...
September 23, 2011 at 9:20 am
Yes, I'd forgotten about VLOOKUP , very useful command.
Thanks
September 17, 2011 at 12:27 pm
Thanks for your help so far. The file looks fine but maybe there's some corruption there.
September 7, 2011 at 10:59 am
Here is the error message from the Import/export wizard log:
The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by...
September 7, 2011 at 10:41 am
I can do that but it will not save. (Is this because it's the Express version?)
September 7, 2011 at 10:35 am
If I look at the properties, it says "autogrowth by 20MB, restricted growth to 2Gig"
September 7, 2011 at 10:31 am
Ninja's_RGR'us (9/7/2011)
Are you sure you are looking at the right file? Did you refresh after running the command?
Yes - I know because the size change to whatever I set...
September 7, 2011 at 10:15 am
Ninja's_RGR'us (9/7/2011)
Add a comma before MAXSIZE
The command runs ok, but when I check properties it still says "restricted growth"
September 7, 2011 at 9:57 am
SQLforU (9/7/2011)
1. Increase the t-log space
2. If AUTOGROWTH...
September 7, 2011 at 9:35 am
Yes, it's failing on some records though. It is not using the structure I set up in the database - it is trying to impose its own structure, where every...
September 6, 2011 at 7:14 am
Viewing 15 posts - 16 through 30 (of 34 total)