Forum Replies Created

Viewing 15 posts - 661 through 675 (of 5,109 total)

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

November 20, 2019 at 5:04 pm

#3699276

  • Reply To: power shell script for add datetime to file

    DinoRS wrote:

    I have never met a 3 digit month before

    MMM notation for a month means the first 3 characters of the name of the month? m and d, etc,...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 20, 2019 at 4:10 pm

    #3699251

  • Reply To: Flat file source to destination table is getting only top 1 record into table

    Agreed, a Script Component is what you want, not a Script Task; the 2 are distinctly different (1 for use in the Control Flow the other the Data Flow)....

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 20, 2019 at 9:11 am

    #3699126

  • Reply To: I am new to SQL world

    Jeff Moden wrote:

    Just remember that the YYYY-MM-DD formats aren't actually followed as ISO in SQL Server even though it is a valid ISO format.  For example, if you set the language...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 20, 2019 at 9:04 am

    #3699124

  • Reply To: Flat file source to destination table is getting only top 1 record into table 

    123456|20130701|AWD|WS1035575|20170201|VCDF|MA1064844|20110001|NHS|AS19474754|20160401|EFV7|LK

    Is more than 4 columns. What is your row delimiter here, the 4th | character? If so, can you change that? Using a row delimiter that's the...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 19, 2019 at 3:54 pm

    #3698873

  • Reply To: I am new to SQL world

    Kabina wrote:

    This is backend tables are on SQL server where I got access to retrieve data where datatype for POdate is nvarchar(48).

    That doesn't explain the data type choice. A varchar...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 19, 2019 at 3:47 pm

    #3698867

  • Reply To: I am new to SQL world

    Kabina wrote:

    Jeff Moden wrote:

    What is the actual datatype of the POdate column?

    Datatype is nvarchar(48) but when I run Isdate() function it shows 1 which is valid date.

    ISDATE() , like it's "friend"...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 19, 2019 at 2:13 pm

    #3698824

  • Reply To: Round at specific decimal point

    Phil Parkin wrote:

    david.wootton wrote:

    (38,0) default

    I think not. You should really test things before posting them here. Using a precision of 0 causes immediate rounding to the nearest whole number.

    2019-11-18_11-38-46

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 18, 2019 at 4:50 pm

    #3698586

  • Reply To: I am new to SQL world

    This is pseudo-SQL, but seems like you'd be better off with a start and end parameter, which you set at the start of the batch:

    DECLARE @StartDate date...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 18, 2019 at 3:46 pm

    #3698574

  • Reply To: I am new to SQL world

    Jeff Moden wrote:

    Thanks, Thom.  Understood on the 2019 stuff.  I was under the impression that it wasn't actually a "4th" type... I was under the impression that if SQL Server could...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 18, 2019 at 3:13 pm

    #3698553

  • Reply To: Round at specific decimal point

    david.wootton wrote:

    declare @num decimal

    decimal what? Where's your scale and precision?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    November 18, 2019 at 2:14 pm

    #3698530

    • Viewing 15 posts - 661 through 675 (of 5,109 total)