Search results for query: *

I am using the below code: select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'excel 12.0;HDR=yes;imex=1; driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; extended properties=excel 12.0 xml; Database=\\sql2016\Imports\SETUP.xls', 'select * from [Employees$]') I get an error...

We have migrated our databases to a new sql instance on the same server as the current instance. Is it possible to change the sql instance that the entire report server refers to? ie. Our current SQL is named SQLData and the new instance is SQLData\Version10. Is it possible to migrate the...

This has just popped up today. Clients reported that email was down. I seem to be able to send and recieve from the local network. However outside users are unable to send but can receive. I am not able to telnet to port 25 from outside. Inside telnet works but each character manually typed...

I have one user (a member of HR group) that does not see the report list on the server's main HTTP://Server/reports page. The user gets the page header down to the line above the bar that shows "New Folder, New Data source, etc" Is there an Add-in or other control that I'm missing? I've...

I have a view returning a list of checks and related employee information. The important fields here are CheckDate, CheckAmt, EmployeeID, and EmployeeTermDate. I need to return the last check for employees that have been terminated (EmployeeTermDate not NULL). However the view returns all...

I need to return a period to date total as well as a last value from a table. Given the following data set... Declare @Temp Table(EmpId VarChar(20), Checkdate smalldatetime, Gross_Pay numeric(19,5), IRA_Contribution numeric(19,5)) Insert Into @Temp Values('01123DOE', '01/01/2010', 500.00...

I accepted IE8 and it's updates for install to our workstation group. We then found that IE8 didn't like one of the main websites (bank) used by our accounting dept. I have since created a NoIE8 group and moved the appropriate computers into it. I then set all of the IE8 updates to be...

We have the situation where a payroll was run and it created an ACH batch for processing. The payroll was then voided but the ACH batch is still listed in ACH Maintenance. If you view the detail, the transactions all show checks by either Void or Man. Void. My first thought was to go ahead...

Dynamics GP Professional 9.00.365 Integration Manager 9.00.0047 We have a few users that need to use Direct to Table imports in Integration Manager. We set the integrations up on one of our IT dept computers and everything works fine. The same integration fails on the end user workstation...

We have the situation where GP users have been removed from the SQL database users but are still present in the User setup in GP. When you attempt to delete one of these IDs the system reports a SQL error and recommends that the SQL administrator be contacted. My thoughts are that the user IDs...

Our CFO brought this to me today. When we go into Tools |Routines |Payroll | W-2 Magnetic Media only one of our current companies shows up for the 2008 filing year. If we change the year to 2007 all of our companies show up. The company that shows up also lists the correct date when the...

Maybe it is the way we were taught but I don't know this. Is it possible to have more than one version of a modified report? We have a modified SUTA report that has no SSNs. We also have a need for a simple line item report that has no headers or footers. Basically I need to know if it is...

I have a table with transaction data that includes an employee id,check date, code name, and a code ammount. The basic structure is similar to the temp table below. It will include other columns but they are not important to the report. Declare @Temp Table(EmpId VarChar(20), Checkdate...

We have several excel spreadsheets that reference SQL databases via ODBC connections. I need to change the database that they are querying because we have moved data to an archive database. Even though the ODBC link sets the default database to the new historical data the Query seems to...

We reciently upgraded to version 9 from 7. Somewhere along the route the Period End reporting of FUTA, SUTA, and Work Comp begain posting to the GL at the detail level. I am not familiar enough with the account/posting setup to find where this is configured. I'm certain it is a simple fix but...

I have a payroll report with a subreport. They are linked on the Employee Id. The subreport pulls from a table with check summary information. There is one entry for each check writen to an employee. I need the subreport to return only the last check written. As it is now it returns a...

I have an existing Metaframe server that was on 192.168.1.0 subnet. It has been moved to the otherside of our VPN to the 192.168.0.0 subnet. All appropriate TCP/IP settings in network have been set correctly. I can connect to shares, telnet, and remote administration. On our end...

I am developing a check stub report. The data table has the employee check detail information in it (employid, pay rate, number of units, paycode, paycode type, etc). I need to separate the paycode types (earning, deduction, Taxes, benefits) into their separate subreports for formating. I...

Is is possible to generate separate export files (pdf or txt) from a grouping on a report? For example, we run a report that creates a summary for a payroll kinda like a check stub. I need to be able to separate out each employees stub into its own file to send to e-mail or employee folder...

We have a flat file that contains payroll information. I know how to import the file into a table using several methods. I can set this up so that a paytech can click a 'magic button' and fire off the import. No problem there. What I need to do is to setup the system so that the data is only...