Viewing 15 posts - 106 through 120 (of 260 total)
David Reed (3/11/2009)
March 11, 2009 at 1:26 pm
Maybe it is best to leave Northwind alone. However, I do like GSquared's idea also. Maybe this is something to latch onto AdventureWorks, since it was built to...
March 11, 2009 at 11:35 am
I got it right, but not for the where clause...
In option A, the GROUP BY is on the NAME of the employee... bad, bad. There could be 2 John...
March 10, 2009 at 1:49 pm
Yelena Varshal (3/10/2009)
My advice is to use legal Nondisclosure Agreements
I tend to agree with Yelena. If you don't trust them, they shouldn't be there anyway. Company data or...
March 10, 2009 at 10:35 am
jcrawf02 (3/9/2009)
dphillips (3/9/2009)
March 9, 2009 at 11:38 am
Samuel Johnson (3/7/2009)
March 9, 2009 at 11:20 am
Union or none, the ultimate goal would be to manage one's finances in a manner that allows one the freedom to make the choices they desire, rather than being forced...
March 9, 2009 at 10:31 am
I feel that this cycle came about largely due to the release cycles of the open-source world. It is a bit fast, but open-source has little to lose if...
March 9, 2009 at 10:03 am
Robert Davis (3/6/2009)
Since we're talking wish list here, I would like to petition for 4 day work weeks (4 x 10 hours) as the standard.
Why stop there? Go for...
March 6, 2009 at 4:13 pm
Tomm Carr (3/6/2009)
... The last time, I took a course to get my CDL and hit the road for a year...
I have considered that very job choice many a time....
March 6, 2009 at 2:44 pm
True. Access does not strip spaces. So it depends on desired outcome.
March 6, 2009 at 2:26 pm
andrewd.smith (3/6/2009)
...A translation of this Access expression is:
LEN(SUBSTRING([Field3], 1, CHARINDEX(' or', [Field3]) - 1))
Or simply:
CHARINDEX(' or', [Field3]) - 1
March 6, 2009 at 1:10 pm
yulichka (3/6/2009)
Also, how can I convert this:Len(Left([Field3],InStr(1,[Field3]," or")-1)) Thank you
Why would you pull the LEN of a LEFT that uses a position value you will end up with in the...
March 6, 2009 at 1:07 pm
The only benefit I find useful in a union is the right to leave the union and still work side by side with those who choose to be part of...
March 6, 2009 at 9:35 am
The best counter-measure to performance reviews is a detailed log of accomplishments and contributions. Journaling is a Good Thing.
March 5, 2009 at 4:22 pm
Viewing 15 posts - 106 through 120 (of 260 total)