Forum Replies Created

Viewing 15 posts - 106 through 120 (of 5,109 total)

  • Reply To: SQL Table Issue

    Jobs90312 wrote:

    The project that I am designing in my ssis project requires me to constantly change my tables and their column types. Its a big project so when I...

    Thom~

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

    January 27, 2023 at 11:19 am

    #4142371

  • Reply To: SQL Table Issue

    Then the code page needs to be 65001. The data imports fine with me with that setting:

    • This reply was modified 3 years, 4 months ago by Thom A.

    Thom~

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

    January 27, 2023 at 10:15 am

    #4142340

  • Reply To: SQL Table Issue

    What encoding is the file saved in? UTF-16? UTF-8? Something else?

    Thom~

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

    January 27, 2023 at 10:10 am

    #4142338

  • Reply To: SQL Table Issue

    I can see you've got it set to "code page 1252" there; that's a strong suggestion the file is being read as a DT_STR not a DT_WSTR.

    Thom~

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

    January 27, 2023 at 9:58 am

    #4142334

  • Reply To: SQL Table Issue

    Seems you are using a varchar somewhere, or you've defined the column as a DT_STR rather than a DT_WSTR in your SSIS task.

    Thom~

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

    January 27, 2023 at 9:21 am

    #4142319

  • Reply To: cannot grant user view definition on a database

    For reference, there has already been some troubleshooting on this over on Stack Overflow, where there is some additional information in the comments.

    Thom~

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

    January 26, 2023 at 12:43 pm

    #4141993

  • Reply To: How to Reseed an Identity Column on Temp Table After data has been removed

    The fact that you're using a loop sounds like there are other problems too. T-SQL is a set-based language and so excels at set-based solutions. Conversely, it doesn't perform well...

    Thom~

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

    January 23, 2023 at 1:36 pm

    #4140782

  • Reply To: How to Reseed an Identity Column on Temp Table After data has been removed

    Why do you want to reseed the value? You only DELETE the rows with a ID of 1, 3, and 5.  If you reseed the IDENTITY (so that the next...

    • This reply was modified 3 years, 4 months ago by Thom A.

    Thom~

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

    January 23, 2023 at 12:58 pm

    #4140763

  • Reply To: Case expression with NULL

    Also, for those interested, this error occurs at compile/parsing rather than at execution. Take the following:

    SELECT 1/0;

    SELECT CASE WHEN 1 = 0 THEN NULL END;

    You might expect...

    Thom~

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

    January 23, 2023 at 12:26 pm

    #4140749

  • Reply To: Safa Insert

    If you get an error, what is that error?

    Thom~

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

    January 23, 2023 at 10:04 am

    #4140703

  • Reply To: Case expression with NULL

    Peter.Frissen wrote:

    But what about this? It returns null in both cases....

    declare @t int

    select case when @t is null then @t else null end

    The error specifically states it can't be a...

    Thom~

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

    January 23, 2023 at 9:52 am

    #4140698

  • Reply To: Conventions when writing queries/stored procedures

    Jeff Moden wrote:

    Also, to support Thom on his claim that 3 and 4 part naming has been deprecated, take a look at the following article written by a really smart fellow...

    Thom~

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

    January 23, 2023 at 9:01 am

    #4140682

  • Reply To: Conventions when writing queries/stored procedures

    edwardwill wrote:

    I disagree about aliasing because I don't see the point except when a table is JOINed more than once in the same statement. 

    I used to be on this...

    Thom~

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

    January 20, 2023 at 4:39 pm

    #4140105

  • Reply To: Conventions when writing queries/stored procedures

    3+ part naming for columns is (due to be) deprecated, so get out of the habit of their style. Instead, alias the object(s) in your FROM and then qualify the...

    • This reply was modified 3 years, 4 months ago by Thom A. Reason: Add about delimit identifiying

    Thom~

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

    January 20, 2023 at 4:26 pm

    #4140089

  • Reply To: Read data based on date-range in huge table is slow

    I think the topic is "bugged"... I got a notification of a response from Scott, and the forum shows they were the last to reply, but I don't see it......

    • This reply was modified 3 years, 4 months ago by Thom A.

    Thom~

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

    January 20, 2023 at 4:22 pm

    #4140087

Viewing 15 posts - 106 through 120 (of 5,109 total)