your prob. is your printing a variable in its standard format, you have to convert it WITH the Print command to get the correct output...
Type: Posts; User: Tenman
your prob. is your printing a variable in its standard format, you have to convert it WITH the Print command to get the correct output...
DECLARE @DO_Date_varchar varchar(50)
DECLARE @DOC_Date varchar(10)
DECLARE @DO_Date datetime
select @DO_Date_varchar ='20051031112810'
select @DOC_Date = LEFT(@DO_Date_varchar,8)
PRINT...
try using 103 instead of 111.....
oops... you want the year at the front, 111 should be correct
in fact
SELECT convert(datetime, '2016/10/23', 111)
works for me on my 2008 SQL database...
personally, I just painted the top of my fence with old engine oil...
I always found Kumho's to be ace in the dry, lasted forever but were lethal when it was slightly damp, I always found Toyo's to be the best all round cheapish performer, they didn't tend to last that...
if your handy with spanners, get an old Skoda Estelle.. mega fun.. starlet is a good suggestion, as is a mini.. in the mini you can have REAL fun on the road without fear of loosing your license as...
you can usually pay a bit extra to have alcohol included :)...
IIRC when we went last year it was an extra 50 euro's to have (most) alcoholic drinks inclusive, and was well worth it..
heh, or yeah, more likely as MKS says, that looks like its prob. supposed to show the IP Address (etc) that its getting over the VPN and not from your router...
do you have your router at home enabled for DHCP or is everything there on static addresses?
confusing me a bit where the hell its got that mask from though...
http://www.google.co.uk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CMgBEBYwAA&url=http%3A%2F%2Fwww.belkin.com%2Fuk%2Fold-support%2Ftech%2FF5D7230_F5D7231%2FUsing%2520F5D7230%2520Router%2520As%2520A...
not a setting in the Belkin to say use as Wireless Access Point?
I'm guessing ports 500 and 4500 need to be forwarded on the router for the main network to whatever server the phones connecting to...
Jap Import... full cream leather interior as well... major PITA when its not absolutly roasting, you have to move the aircon pump to change the oil filter... :s
*sigh*... the wife's classic mini now seems to have a problem with the aircon pump vibrating like mad when aircon is switched on, more fun for me to check soon...
I'd say the Lexus is better than the beemer, really nice chassis and quicker than a 318 or 320 I think, not really got lots of oomph though and is heavy on the juice, stretch it to a 323 or above...
Taxi to Ewood please...
heh, I was gonna say it looked more like a Micra....
Drupal... tis free...
heh, I remember someone at work buying an R32 Golf when I had my S14, he was a bit pissed when it got destroyed by my cheapy cheap 14...
check group policy for the active directory containers the users are in...
retrorides might be a good place...
http://retrorides.proboards86.com
If your NAS array is a terrastation or something like that you should get a web-control panel for it, so open a browser and go to http://nas_array_IP, you should be able to check on there if quota's...
LOL, I was thinking of the amount of small businesses who have a 2003 server sitting there with RDP for their remote access that because it just sits there working all the time is forgotten about and...
http://blogs.technet.com/b/srd/archive/2012/03/13/cve-2012-0002-a-closer-look-at-ms12-020-s-critical-issue.aspx
deffo one to be aware of and keep an eye on, I've personally turned off all external...
not a 270R, they were S14's not S14a's IIRC..