Viewing 15 posts - 1 through 15 (of 17 total)
I was considering the value of null. Apparently, I mistakenly thought (null = 0) would return false (not unknown) and then the not operator would change it to True...
June 10, 2013 at 2:42 pm
I too lucked out. I didn't like the question as posed. Having individual orders with odd quantities and pricing, was placed it out of the scope of a...
June 3, 2013 at 3:49 pm
February 25, 2011 at 12:25 pm
Thanks, I mentioned in the original "I am planning on having this be a domain account with access to the target destination"
I think this addressed your comment. As...
November 17, 2010 at 9:50 am
Somebody has their dates wrong, and if my wife has anything to say it would be me.
With that in mind the folks over at http://www.searchforancestors.com/utility/gregorian.html say that Greece adopted the...
November 8, 2010 at 9:29 am
tilew-948340 (11/4/2010)My engish beeing what it is, I did also not get the differance between the first two
Don't worry about it, I've lived in England for all...
November 5, 2010 at 10:09 am
While I fall under US jurisdiction. I try to keep an international awareness. I prefer the ymd format for very selfish and pragmatic reasons outside of SQL, file...
November 5, 2010 at 9:58 am
Hugo Kornelis (11/5/2010)
Steve Eckhart (11/5/2010)
November 5, 2010 at 9:33 am
Based on Hugo's LOGICAL progression where the group by preceeds the select. The alias is not yet defined so grouping is not possible against a column that does not...
November 2, 2010 at 12:58 pm
Michael Valentine Jones (11/2/2010)
timothy bates (11/2/2010)
November 2, 2010 at 10:55 am
Accurate question. I think any question that uses a date with obvious notation to remove all ambiguity such as '2010-Jan-01' is fine. We clearly understand which is the...
November 2, 2010 at 10:22 am
I got it right but for different reasons. If you wanted to add an additional wrinkle try:
SELECT @Var2 = ' - ', @Var3 = CONVERT(DATETIME, '01/01/2010', 101),@Var1 =...
November 1, 2010 at 12:46 pm
Nice question, I appreciate the intent of the question as I see it, 'Persisted does not mean permanent.'
October 20, 2010 at 8:50 am
Thanks for the comments.
In a view SQL Server returned n.n where in query analyzer it returned n.n0 for each.
My main point was to showcase that there is disparity in programs...
October 13, 2010 at 1:21 pm
Use of the below could be argued as an acceptable solution.
if (@SearchMe is not null and @FindMe is not null and @ReplaceMe is not null) Select #1NormalReplace =...
July 23, 2010 at 11:51 am