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 Wanet Telecoms Ltd 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. VeryGoodGirl

    Import a flat file in T-SQL

    I am trying to import a very 'messy' flat file into SQL SERVER 2000 via T-SQL. It is a screen dump. I do not know the record delimintors but think that the lines are 160 characters long. I do not see were the BULK INSERT command lets you specify a line length. Thank you.
  2. VeryGoodGirl

    rows to columns

    I have the example data: A1234 RX9999 A1234 RX8989 A1234 RX1234 A5674 RX2 A5674 RX999 I need like: A1234 RX9999 RX8989 RX1234 A5674 RX2 RX999 All fields are dynamic. Does anyone know how to pivot this in a query? I have done it with a procedure and a temporary...
  3. VeryGoodGirl

    DayofYear to actual date

    I am being passed the dayofyear (example: 169) and need to convert that into the actual date. I realize that I will need to be passed the year also. Does anyone know how to get date from dayofyear. Thank you!!!!
  4. VeryGoodGirl

    T-SQL Cursor doesn't move to next

    Below is a simple T-sql cursor. It seems to get stuck on the first row. What am I doing wrong? USE ADatabase go IF EXISTS (SELECT name FROM sysobjects WHERE name = 'pr_Update_Aircraft' AND type = 'P') DROP PROCEDURE pr_Update_Aircraft go CREATE PROCEDURE pr_Update_Aircraft...
  5. VeryGoodGirl

    Creating duplicate table in SQL SERVER 2000

    In ORACLE we just: Create table_name as (select * from another table) How can I do something similar in SQL SERVER 2000. Thank you
  6. VeryGoodGirl

    month as two digits

    I am using select ( datepart(month, variable) and want a two digit month. How do I get it?

Part and Inventory Search

Back
Top