Search results for query: *

Hi all, I have a simple one-liner that I use to print highlighted selections from worksheets, and I want these to always print to my local printer (which is also the default printer). The problem I have is that if I have previously printed to another printer, that is the ActivePrinter, and my...

Hi All, I'm trying to create a UDF (SQL Server 2000, btw) which will take the date from a column in the same table, add years based on a calculation of two other columns, and arrive at the final date. If it's helpful to know I'm taking the end of a current lease, adding the renewal options...

Hi, I have some date data in one Db in the non-date format yyyymm. I need to copy some of it on a regular basis to another table where the destination column data type is Datetime. I'm trying to use a scheduled DTS Package to perform this task with the following code: SELECT [Acct]...

Hi there, I have a query that is itself based on two other queries. I was getting multiple hits of certain data due to there being a 2008, 2009, 2010 instance of certain records, so I applied a 'Min of' to the date field. I have a separate text field in the same query which displayed all text...

Hi, I'm fairly new to SQL Server, so apologies if this is a no-brainer. I have a SQL Server Database, with Access front end, linked through an ODBC connection. (call this "My Db") I wanted to link a table from another Db (which is on the same server as my Db) directly to Access but can't...