Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Deam
  • Order by date
  1. Deam

    Unable to open BCP host data-file

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

    Export Multiple .csv files using DTS

    bump...anyone ?
  3. Deam

    Export Multiple .csv files using DTS

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

    Problem with Select...

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

    Summing up data in SQL

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

    Summing up data in SQL

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

    Date calculation in SQL

    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 !
  8. Deam

    Date calculation in SQL

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

    Date calculation in SQL

    It is DATETIME
  10. Deam

    Date calculation in SQL

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

    Sql auto counter

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

    A Simple Select Question...

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

    A Simple Select Question...

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

    Rounding Question

    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 !!
  15. Deam

    Rounding Question

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

    Rounding Question

    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 ?
  17. Deam

    Sorting and Grouping

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

    Sorting and Grouping

    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 ?
  19. Deam

    Automatically generate email addresses...

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

    Automatically generate email addresses...

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

Part and Inventory Search

Back
Top