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 strongm 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: *

  1. huddles2k

    export file in comma separated not like excel

    Nigel, The file is created through the DTS due to some heravy transformations of the data first.
  2. huddles2k

    export file in comma separated not like excel

    Hello all, I have a dts that exports data from a table to a comma separated file, with ansi, and CRLF as criteria. This file is then picked up by a third party package to do some other activity. This file cannot be opened, and an error indicating incorrect format is presented. When I open...
  3. huddles2k

    non-email alert

    Hello, My exchange admin is dragging his feet setting up the email service on our sql server. Is there anyway I can setup alerts when the jobs fail using a non-emailo method? I have full sql server 2000 on my laptop, and a broadcast to my connection would even suffice. cheers
  4. huddles2k

    select datetime by date and then by hour

    zhavic, thank you for the info. I used the following script and it does what I need to. SELECT DateHour, COUNT(*) AS NumberOfRecords FROM (SELECT CONVERT(char(10), SUBMIT_DTTM, 101) + ' ' + CONVERT(char(2), SUBMIT_DTTM, 8) + ':00' AS 'DateHour' FROM...
  5. huddles2k

    select datetime by date and then by hour

    Hello, I have a datetime column (Col1), and I need to select * from table_1 where Col1 >=01/17/2003 group by date and then by hour increments example: Col1 Col2 Col3 02/02/2003 12:45:00 bob red 01/18/2003 23:45:02 tony blue 04/03/2003 17:45:00 Tony...

Part and Inventory Search

Back
Top