Search results for query: *

I am trying to export a csv file using bcp but get: Unable to open BCP host data-file My sproc does not return any error and does not create the file so i tried the bcp part in DOS and got the above error. I have checked the permissions. To execute the below sproc I use shrExportData...

bump...anyone ?

I need to create an automated process in SQL Server 2005 which will export about 18 files every night (via a SQL job). I have not worked a lot with DTS not to mention SQL 2005. Any help will be greatly appreciated. I don't even know where to start.

Here is the problem: I need to find out a list of Employees who have a benefit record with an end date of 12/31/2006 AND have a benefit record starting 1/1/2007 AND Had dependents enrolled in the 12/31/2006 record BUT do not have those dependents enrolled in the 1/1/2007 record. (My client...

That did not do the trick...any other suggestions

I am selecting data from 3 different tables: tEmp:(PersonID,FullName) tBenefitHist:(PersonID,BenefitID,BenefitStartDate,BenefitEndDate,PlanCode) tContributionHist:(PersonID,BenefitID,ContributionStartDate,ContributionEndDate,EmployerAmount) I need to SUM the employeramounts(from...

It is SQL server. Two weeks would be 14 days back from the time the query is run. Basically this is a sproc that is used to create a Crystal report. The Sproc needs to pull records of employees whose PeriodStartdate falls with the two weeks of the date the report is run Thanks !

Wy do I keep on getting Line 3: Incorrect syntax near '<'. When I run SQL Dennis's query ??

It is DATETIME

In my query I need to include all the records for a Person that fall between today and two weeks back. The table I am selecting records from has just one date field - PeriodStartDate Appreciate any help

I had converted some records in a SQL Server database - now I need to assign their ID fields numbers starting from 3100 to 3999. I know I have to do the Select part but how do I start numbering them ? and stop at 3999. Update Tbl_Emp SET EmpID = ????????????????? WHERE EmpID = NULL Appreciate...

You mean in the result set I want ? No I want it Active. Good point... if someone has multiple records, like: PID StartDate StatusEndDate Status 9876 8/30/1999 ACT 9876 1/28/2000 TERM 9876 2/11/2000 ACT 9876 3/13/2001 TERM It...

I need to combine two rows if the status code of the second row is Terminated: PID StartDate StatusEndDate Status 1234 5/16/2001 ACTIVE 1234 1/14/2005 TERMINATED 5678 3/16/2002 ACTIVE 5678...

Yes you are correct...and I am stumped as to what I should do...The auditors are coming in next week and I need this reolved before then !!

I should have been more clear in my initial question...I apologize... my situation is that i an selecting the salaries of some employees. When I select the yearly salary of an employee, based on the # of hours(that is the .0012 number you see) they put in I have to convert it to their hourly...

My select statement: SELECT RIGHT('00000000'+ CONVERT(varchar(8),CONVERT(numeric(8,4),(21630 * 0.00120192))),8) gives the result of 025.9975 How do I make it round up so that I get 26.00 ?

I meant changing the order of the data in the table, inside the database itself. My situation is that I am exporting data out of a sql database. Its a user interface. Inthe code the last thing it does is create a sql server table then exports it using bcp. If not in sql then maybe i can sort it...

How do I update a table to group or sort the data in it? I have a table tblEmpDep it lists all the employees and their dependents. I want to update this table so that the data is now grouped by EmpSSN or Order by EmpSSN. any ideas ?

The data is in a sql server database. If all the characters are a match then it should add a 1 or 2 or 3 at the end.

I am working on a web application where I hire someone email address should automatically get created. I need to create a java script page that would have a function to basically create email addresses on the fly for the users. So 4 employees get hired in the following order - John Smith, John...