Viewing 15 posts - 946 through 960 (of 6,486 total)
Brandie Tarvin (6/25/2012)
Why would NULL matter?
CHAR(1) doesn't have extra overhead for the flexibility of string length. VARCHAR(1) adds that extra string length flexibility, therefore has added overhead. In a...
June 25, 2012 at 10:42 am
Brandie Tarvin (6/25/2012)
Matt Miller (#4) (6/25/2012)
SQLRNNR (6/25/2012)
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?Or the date ones...
InsertedDateTime int
BAH!!!
Or...
June 25, 2012 at 10:35 am
SQLRNNR (6/25/2012)
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?Or the date ones...
InsertedDateTime int
BAH!!!
Or VarChar(1)
Wait though - is it...
June 25, 2012 at 10:19 am
Presuming you're going after a rolling 3-month average, something like this gets you there (the first part of the CTE is purely to set up the test data you provided).
;with...
June 22, 2012 at 12:32 pm
mbrooks (6/20/2012)
June 20, 2012 at 6:12 pm
Is it actually set up to fail in some way if it doesn't find any new data? A lot of case could simply be something that filters out all...
June 20, 2012 at 10:55 am
You're probably looking at something like this instead if you NEED to use the month and year criteria:
(
year(manufacturing_start_time) >= @year and (month(manufacturing_start_time)>= @month)
and (
...
June 20, 2012 at 9:16 am
Oh - my bad. the formatting made those statements disappear.
That said your year and month criteria isn't equivalent to using the date. let's take a look at this:
year(manufacturing_start_time) >=...
June 20, 2012 at 9:03 am
Your initial criteria allows for the ending date to be null. The other two don't allow for that (i.e. filter those out), which is why you are getting fewer...
June 20, 2012 at 8:03 am
I keep associating districts with a geographical area, so I cannot help but think that using distance alone is not going to serve you well in this case. Would...
June 19, 2012 at 7:46 pm
Les Cardwell (6/19/2012)
Lynn,It's a redistricting (route) requirement, where we're looking to contain each district to roughly the same number of meters (service locations). Urban growth and all that.
That's interesting, because...
June 19, 2012 at 1:59 pm
patrickmcginnis59 (6/18/2012)
The question isn't whether disparity exists, it's whether the ability to move along the income spectrum exists.
Everybody on the lower income spectrum would like to move along...
June 18, 2012 at 9:40 am
chrisn-585491 (6/18/2012)
What exactly is scary?
The last time the US income disparity was at this point was right before the Great Depression. :w00t:
Imagine the economy as a database server. Right now...
June 18, 2012 at 8:10 am
chrisn-585491 (6/15/2012)
June 15, 2012 at 1:25 pm
Lowell (6/14/2012)
/*
--Results
2.3
1.79
*/
SELECT [dbo].[ExRateProc]('USD',GETDATE()) As Results
SELECT [dbo].[ExRateProc]('oops',GETDATE()) As Results
CREATE TABLE [dbo].[ExRates](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ratedate] [date]...
June 14, 2012 at 11:07 am
Viewing 15 posts - 946 through 960 (of 6,486 total)