Viewing 15 posts - 1 through 15 (of 84 total)
Thank You much! I'm Sorry, I got environments and environment variables mixed up in my first post. I also specified "Data Model" where I meant "Data Flow". ...
March 5, 2015 at 10:34 am
Edited -- I was sending this before I saw your second reply with examples. I will take a look at them. -- text removed.
March 5, 2015 at 10:10 am
Along this line about the Default datetime value display (in SQL Server 2005) I do not understand why if I declare a variable as a datetime type and set it...
October 30, 2013 at 1:57 pm
DUH! In this case it is sometimes difficult to see the tree because the forest gets in the way.
Thanks very much!! I spent way too much time on...
October 22, 2013 at 7:39 am
THANK YOU DREW! Your Cross Apply example was exactly what I needed. I tried to research the Cross Apply when you first suggested it, but the complexity of...
September 13, 2011 at 8:57 am
I do not see how a GROUP BY will help as I have done that several times. What I need to do a MAX(LIVAR_DATE) with a MAX(LIVAR_TIME) in the...
September 12, 2011 at 2:08 pm
See attached .doc file with DDL of the three tables in query. The CFTVCM9200 table has a seperate LIVAR_TIME two char field to denote the hour which would be...
September 12, 2011 at 10:05 am
Well John, I didn't realize you were a Brit until you wrote "...a formidible defence" instead of "defense"!
May 4, 2011 at 8:04 am
Andy,
The most terrific pair of articles I've read in a long time. I was particulary impressed with the way you handled options and errors. Most all of the...
February 20, 2011 at 12:50 pm
Being an OLTP developer and not an actual DBA, I really don't see what the big problem is, it that I would expect personnel (DBA) resources and hardware to increase...
January 14, 2011 at 9:11 am
Calling Access, Excel, and other tools low-end IS NOT a deprecation of the tool itself. They are considered low-end development tools because they fit into the low-end of the...
December 29, 2010 at 5:59 pm
User prototyping is one possible use of low end tools such as MS Access and others (actually there are hosts of better prototyping design tools for professionals). However, I...
December 14, 2010 at 11:44 am
The arguments for and against deterministic Biometric fingerprint analysis, retinal scans, etc. vs immutable password hashing all sound totally ridiculous because there is no one method that is proportionally better...
November 9, 2010 at 9:47 pm
I believe the military (chiefly the USAF -- not sure of other branches) has already resolved this issue (and I am not talking about ultra top secret installations) for general...
November 8, 2010 at 10:14 am
I also tried all four queries and found that query 1 (SELECT COUNT(*)) was marginally faster in the Client Statistics! Possibly its server dependent?
...
October 19, 2010 at 2:09 pm
Viewing 15 posts - 1 through 15 (of 84 total)