Viewing 15 posts - 181 through 195 (of 703 total)
You're right to not want mess with the data as stored on the database. Whether it's recorded as Pacific or Greenwich (UTC) time, I think it would be much...
February 25, 2011 at 11:48 am
Danny,
Thanks for the thoughtful and well-documented post. Your English is fine and please be assured that most people visiting this site are aware that it has an international following...
February 24, 2011 at 11:41 am
SanDroid (2/24/2011)
adam.everett (2/24/2011)
February 24, 2011 at 9:38 am
Since the original example wavered on how to specify the end of the month.....
Do use a construct of "less than the start of next month".
"<= '2/28/2011 23:59:59'" would miss...
February 15, 2011 at 8:01 pm
How are you planning to get the mash-up of rows into a single CSV file? First thing I think of is run multiple dataflow tasks serially in an SSIS...
February 15, 2011 at 7:42 pm
Jamie Longstreet-481950 (2/15/2011)
CONVERT(varchar(8),getdate(),112)='20110215'
because it is easy to remember and there are not...
February 15, 2011 at 1:38 pm
Hugo Kornelis (2/10/2011)
UMG Developer (2/10/2011)
I'm surprised at the number of people that thought DataDude was the name that hadn't been used, that is what I had...
February 10, 2011 at 12:52 pm
Building on Ian's suggestion, it should be more efficient to use the DateDiff() and DateAdd() functions rather than Convert() to isolate the time portion of a DateTime, then find the...
February 2, 2011 at 9:38 am
If the computer upon which this is run doesn't have Excel 2007 installed, you may have to install the data provider separately. Microsoft has a nice overview of connecting...
February 2, 2011 at 9:02 am
twalpole (1/31/2011)
If requesting parts ordered more than once, need to query for diff > 0
Nice catch. The difference is between a count(DISTINCT) and and a straight count. With all...
January 31, 2011 at 9:26 am
If the business decision is to ask for 99.999% availability, and the funds are allocated to provide it, then it's up to us to plan for minimal disruption and fall-over...
January 28, 2011 at 11:37 am
rollec2k5 (1/21/2011)
I was not aware about, that you can use Columns in a having Clause without having the Column in the SELCET.
Not exactly.... The HAVING clause can use aggregates...
January 21, 2011 at 9:30 am
I hope I've inferred your requirements properly from the example data, but you may have to do some more work if not. It looks as though you want to...
January 14, 2011 at 7:48 pm
Ray K (1/14/2011)
Number of days until pitchers and catchers report to Spring Training:
select datediff(dd, getdate(), '2/13/2011')😀
or, as the New York Times put it four years ago in one of...
January 14, 2011 at 6:59 pm
Viewing 15 posts - 181 through 195 (of 703 total)