Recent content by Deam

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...