Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Using a Batch File to run an application requiring a password
- HelloIs it possible to create a Batch File to run an application that contains a password to open the application?I basicallly need an application to open on a server and continually run. It is a virtual server and when I log out of the session the application closes. So at...
- Tags: dcleary@..., password
- Discussion threads 2007-11-07
- Exporting fields from SQL server with prefixes........
- HelloI'm trying to export some data with prefixed codes against each field. Which will be then imported into another legacy system using the codes as positional pointers.e.g:Name.......Address.......Location001Smith...002High St....003ManchesterThis I can do with no probs:SELECT'001'+Name,'002'+Address,'003'+LocationFROMTableNameHowever looking at the overall data export if there are NULL values in the data it correctly...
- Tags: Databases, dcleary@..., server, Microsoft SQL Server, NULL VALUE
- Discussion threads 2007-08-23
- EXCEL Macro query
- After assigning several macros to different buttons in EXCEL 2003, How can I identify which macro is assigned to which button.Is this possible? - its certainly not straight forward with a right click or anything like that.Is there a registry setting that hold this information?I have recently acquired a database...
- Tags: Microsoft Office, dcleary@..., Microsoft Excel
- Discussion threads 2007-06-21
- Simple SELECT query from SQL Server
- I'm trying to construct a SELECT statement that will return people that have no live courses running at the moment. Please see example table below:id Name Course StartDate Status101 Johns Course1 01/04/2007 Completed101 Johns Course2 01/04/2007 Completed101 Johns Course3 01/04/2007 Live101 Johns Course4 01/04/2007 Completed101 Johns...
- Tags: Microsoft SQL Server, dcleary@..., server, John Smith
- Discussion threads 2007-06-20
- Performing a year comparison within SQL Server
- HelloI'm trying to do a comparison of a full date field to a year field using: min(SUBSTRING(CONVERT(CHAR,ISNULL(me.e_start,GETDATE),110),7,4)) "Start_Year"to convert the date field in to a year, I then want to compare this converted field to a current year view that I have created.e.g 19/06/2007 will convert to 2007me.start=(SELECT AC_YR from...
- Tags: server, Microsoft SQL Server, dcleary@..., DatePart
- Discussion threads 2007-06-19
- Excel 2003 macro query - overwrite save command needed.
- HelloI'm trying to create an overwrite save command within MS Excel 2003.I'm saving the active work book as a new file:ActiveWorkbook.SaveAs FileName:="c:Testtestfile.csv"I need to run this macro on a regular basis and sometimes the file will be already held in the location above and sometimes it won't be.When I run...
- Tags: Microsoft Office, dcleary@..., Microsoft Excel, Microsoft Excel 2003
- Discussion threads 2007-05-18
- << Previous
- page 1 of 1
- Next >>
