http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64755
Example:
select
distinct PLANT_ID,
userid,
update_id,
convert(varchar(10),dateadd(dd,datediff(dd,0,updateDate_Stamp),0),101)
as PO_date
from inventory..inv_log
where plant_id = 'HR'
and type = 'T'
and updateDate_Stamp > '05/01/2011'
and userID like '%SLAM%'
order by 1,2,3
Thursday, July 14, 2011
Thursday, April 28, 2011
Saturday, April 16, 2011
Friday, April 15, 2011
SVN - managing users on webfaction's SVN
Managing Users
Subversion users are managed with .htpasswd file in ~/webapps/svn, where svn is the name of the Subversion application.To add a user or change an existing user’s password:
- Open an SSH session.
- Switch to the Subversion directory. Enter cd ~/webapps/svn and press Enter.
- Enter htpasswd .htpasswd username, where username is the the user, and press Enter. A password prompt appears.
- Enter the new password and press Enter.
- Reenter the new password and press Enter.
- Open an SSH session.
- Switch to the Subversion directory. Enter cd ~/webapps/svn and press Enter.
- Enter htpasswd -D .htpasswd username, where username is the the user, and press Enter.
Saturday, March 5, 2011
SonicWall NetExtender for Mac OS X fix for Snow Leopard
TIP: GUI version of Snow Leopard/Net Extender VPN fix Thursday, March 25, 2010 Don shared an alternative to a previously reported workaround for Snow Leopard problems with SonicWall's NetExtender virtual private network client. The original fix uses Unix commands in Terminal. Don said his workaround accomplishes the same but without the command line: I also couldn't connect using SonicWall NetExtender v3.5.632 after upgrading my MacBook Pro to Snow Leopard. Since I'm not comfortable with Terminal, and our IT guys were Gone For The Day, I tried Josh Carlson_s tip and Downloaded and installed the latest version of NetExtender from the SonicWALL website using these simple steps: From: http://www.macwindows.com/snowleopardVPN.html#090209g |
Friday, February 18, 2011
Subscribe to:
Posts (Atom)