Viewing 15 posts - 3,661 through 3,675 (of 18,926 total)
Lynn Pettis (8/7/2011)
Someone obviously took exception with my opinion.Hope my response wasn't too harse.
Harse or harsh? :hehe:
You're Your response was simply different from the one he wanted. Part...
August 7, 2011 at 6:53 pm
I can say with 100% certainty that nobody is trying to hurt anybody nor discourage anybody from doing anything, especially when it comes to helping one another.
I say this with...
August 7, 2011 at 6:42 pm
Gail already pointed out the obvious. An index is mostly usefull when you filter data. Which you are not doing in any way here. This the the...
August 7, 2011 at 6:35 pm
Jeff puts it best (check his signature). Stop trying to do something to a row and think what you want to do to a column.
This allows you to stay...
August 7, 2011 at 1:15 pm
Couple options...
BCP in
bulk insert
SSIS package.
What have you tried and where are you getting stuck?
August 7, 2011 at 1:13 pm
Lynn Pettis (8/7/2011)
August 7, 2011 at 1:12 pm
Sql server has sql express R2 which allows you to store 10 GB of data (5 times more than access last time I checked).
That version is free and only has...
August 7, 2011 at 12:32 pm
What's still unclear is the output you want.
When running my query, what's wrong with the output you get?
Edit, I think you might need to use a derived table AFTER the...
August 7, 2011 at 9:10 am
SELECT
MAX(LEFT(year, 4)) + dtMultiplier.RN AS year,
Sex, GeographyCode,SubCategory,Age,[Population]
FROM [TEMP_Table1]
CROSS JOIN (SELECT TOP (@Years) ROW_NUMBER() OVER (ORDER BY object_id) AS RN FROM sys.objects) dtMultiplier
GROUP BY Sex, GeographyCode, SubCategory, Age, [Population]...
August 7, 2011 at 7:49 am
Interesting. So how much had you done that year Lynn? Maybe that gives a bottom marker to "aim" for and surpass.
August 7, 2011 at 7:41 am
Perry Whittle (8/6/2011)
Ninja's_RGR'us (8/5/2011)
I say "then" because between all 5 of us we probably close 100-150 threads / day and we pretty much cover 24 / 7.
You should...
August 6, 2011 at 8:13 am
Ninja's_RGR'us (8/6/2011)
Grant Fritchey (8/6/2011)
GilaMonster (8/6/2011)
Grant Fritchey (8/6/2011)
In SQL Server 2008 and greater, you could use DATETIME2 data type which can also manage time zones.
DateTimeOffset, not DateTime2.
Doesn't handle daylight saving...
August 6, 2011 at 7:40 am
GilaMonster (8/6/2011)
Ninja's_RGR'us (8/5/2011)
And then you do your own work + presentations (at your own expanse, travel, hotel & all). And your blog... and answer e-mails from those blog posts...
And...
August 6, 2011 at 7:05 am
Grant Fritchey (8/6/2011)
GilaMonster (8/6/2011)
Grant Fritchey (8/6/2011)
In SQL Server 2008 and greater, you could use DATETIME2 data type which can also manage time zones.DateTimeOffset, not DateTime2.
Doesn't handle daylight saving though.
Oh...
August 6, 2011 at 6:24 am
Viewing 15 posts - 3,661 through 3,675 (of 18,926 total)