Search results for query: *

I have a table of people who move rooms. Every time they change rooms, the room gets updated along with a transfer date. I am trying make a query that will return only the record with the most recent transfer date. Can anyone point me in the right direction? Thanks! Greg

I have Crystal Reports 10 and have made several reports with it to run aginast my Great Plains companies. The reports run great, the problem is that I am the only one who can run them because I am the only one with Crystal on my computer. It's getting old runnning more and more of these for...

Can someone point me to a thread or link on working with Temp tables? I saw one on here a while back but can't find it anymore. I have been searching but found nothing. Thanks! Greh

I have a Cisco Catalyst 2948G switch. My servers have dual intel nics that are capable of running as an FEC team. I think i have everything setup right. The intel software says the nics are running as an FEC team, but the properties say it is running at 100mbps. Shouldn't it be 200mbps? I...

I am exporting the date along with results from my table my table but need it in the format yymmdd 12/17/2003 becomes 031203. To test this out, i have the following: Declare @dtYear varchar(2) Declare @dtMonth varchar (2) Declare @dtDay varchar (2) set @dtYear = right (Datepart(yyyy...