Forum Replies Created

Viewing 15 posts - 196 through 210 (of 686 total)

  • Reply To: Convert Datetime to other format

    any help in how I can do the date format change?

  • Reply To: Convert Datetime to other format

    Current Offset: UTC/GMT -5 hours

  • Reply To: Convert Datetime to other format

    i'm running my process local EST and want it converted to:

    Current:

    CEST — Central European Summer Time

    UTC/GMT +2 hours

    ON my server it's 21:06 I want that displayed as Tuesday, June 14,...

  • Reply To: Parse txt file

    What I meant was after this file was generated I could alter the output to correct the issues. The initial creation of the file was some generated process from the...

  • Reply To: Parse txt file

    I was able to fix the source that creates the jobs.txt and remove the space at the beginning of some of the records. Now The Code supplied by Jeff works...

  • Reply To: Parse txt file

    Thanks for responses... I think the problem is data related...  When I run the following query I finding some of the records starting with

    /* and

    /*

    Where it's failing is the 4th...

  • Reply To: Parse txt file

    I stated in early post I couldn't supply file but fill check table as you gave a good starting place... What about job_type in there twice?

     

    Thx.

  • Reply To: Parse txt file

    Okay I have the file loaded using BCP. I created a format file and used BCP provided... all rows loaded

    All data is now loaded to the table I used above. ...

  • Reply To: Parse txt file

    I apologize Jeff, I really appreciate the time you take to help solve issues.

    This is the code to load the file...

    Many thanks, and hope you don't go dark on this...

     

    Again...

  • Reply To: Parse txt file

    CREATE TABLE [dbo].[PSFileOrder](
    [PSFOrder_Id] [int] IDENTITY(0,1) NOT NULL,
    [PSFile] [nvarchar](500) NOT NULL,
    CONSTRAINT [PK_PSFileOrder] PRIMARY KEY CLUSTERED
    (
    [PSFOrder_Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS...
  • Reply To: Parse txt file

    When I run this section it groups the data as expected...

    SELECT df.PSFOrder_Id

    ,DataGroup = COUNT(CASE

    WHEN substring(df.PSFile,1,2) = '/*'

    THEN 1

    END) OVER (ORDER BY df.PSFOrder_Id)

    ,DataFromFile = df.PSFile

    FROM dbastuff.dbo.PSFileOrder df

    <><><>  It seems to be...

  • Reply To: Parse txt file

    I just did a Bulk Insert, any way to try and debug?

     

    Thx.

  • Reply To: Parse txt file

    I put the data in a Table now via bulk Insert, but the query now is failing...

    Msg 537, Level 16, State 3, Line 5

    Invalid length parameter passed to the LEFT...

  • Reply To: Rules based updates

    If I do the rules table approach how should I multiple comma delimited entries, or can I avoid that?

     

    Thx.

Viewing 15 posts - 196 through 210 (of 686 total)