Viewing 15 posts - 211 through 225 (of 1,162 total)
Not entirely sure what you mean. Are you saying you had to qualify a reference to a column with its table/alias name (e.g. "table1.column1") and sometimes you don't (e.g. just...
May 23, 2013 at 7:31 am
Jeffrey Williams 3188 (5/16/2013)
May 20, 2013 at 10:23 am
Think I see what you're after. Untested, since you haven't provided data, but you need a separate sub-query to pick out just the latest call for each group. There are...
April 23, 2013 at 9:03 am
Would the fact that your "table" is called View_FactTable have anything to do with it? E.g. it must be a view that references other tables if those other tables are...
April 18, 2013 at 8:05 am
I see. I think it's still longitude first for this, but the problem is that when describing a polygon, the direction of rotation (ring orientation) is important as it defines...
April 16, 2013 at 9:34 am
Not sure which bit you're confused with. Longitude comes before Latitude for those geography methods, so the last query looks the correct way round....
April 16, 2013 at 9:12 am
lanky_doodle (4/8/2013)
So if the current month is Jan-Nov only take dates from this...
April 8, 2013 at 7:56 am
Wrapping functions around columns isn't a good idea if it can be avoided as indexes can't be used.
Give this a go and see if it's what you're after:
WHERE abr.ABR_Shift_Date >=...
April 8, 2013 at 7:33 am
Sorry, I misunderstood. When you said line, I thought you meant a row of data, rather than a Line ID in your data. You need to use dynamic SQL plus...
March 26, 2013 at 12:46 pm
so when I select line 2, there would be four columns, each with the boardings number in it, when I select line 4, there would be nine columns.
Each row has...
March 26, 2013 at 11:24 am
Presumably, the rows you're not deleting each day are the highest ID values in the set? If so, simply reseeding wouldn't help. There are obviously convoluted solutions involving deleting, updating...
March 22, 2013 at 6:20 am
How are you viewing that AWE is being used rather than regular memory allocation?
March 20, 2013 at 10:34 am
Agreed, we need the actual execution plans and DDL to help.
March 20, 2013 at 9:00 am
Did you update statistics with FULLSCAN after the 2000 upgrade? It's a compulsory step.
Other than that, we'd need full table and index definitions and the actual execution plans to see...
March 20, 2013 at 6:19 am
ChrisM@Work (3/15/2013)
What version of SQL Server are you connected to?
And what compatibility level is set for the database?
March 15, 2013 at 7:00 am
Viewing 15 posts - 211 through 225 (of 1,162 total)